May 17 2012

SCCM report – Packages that have been updated since original content was distributed


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


I use a maximum of one Google Ad per post to help offset some of my blog hosting costs.


Tags: , , , , ,

Posted May 17, 2012 by danovich in category "SMS / SCCM

Leave a Reply