I needed to quickly identify all of the packages in a SCCM environment that had been updated since their original source (version 1) was distributed, along with the date this occured. The following simple SQL query formed a nice reports. This displays all packages Source Date and Version, ordered by Source Date where sourceversion is greater than 1 (updated since original content was distributed):
select PackageID,Name,PkgSourcePath,SourceDate,SourceVersion from v_Package where SourceVersion > 1 order by SourceDate DESC
Related Articles
No user responded in this post
Leave A Reply