Show all Application Packages Sorted by Date (SQL)

Purpose: Query SCCM 2012 database for all created Applications and sort them by Date

If you need to query details about Applications in SCCM 2012, you cannot do that in WQL. The Admin Console currently supports only to query the old Package-format applications. Should you require information about the new Applications that were introduced in SCCM 2012, you need to use SQL and play with the SQL Server Report Builder to get the report into SCCM.


An example: give or take attributes as you desire.

1
2
3
4
5
select DateCreated, DateLastModified, DisplayName, Manufacturer, SoftwareVersion, CreatedBy, LastModifiedBy 
from fn_ListLatestApplicationCIs(1033) 
 
GROUP BY DateCreated,DateLastModified,DisplayName,Manufacturer,SoftwareVersion,CreatedBy, LastModifiedBy 
ORDER BY DateCreated DESC
select DateCreated, DateLastModified, DisplayName, Manufacturer, SoftwareVersion, CreatedBy, LastModifiedBy 
from fn_ListLatestApplicationCIs(1033) 

GROUP BY DateCreated,DateLastModified,DisplayName,Manufacturer,SoftwareVersion,CreatedBy, LastModifiedBy 
ORDER BY DateCreated DESC

 

Leave a Reply

Your email address will not be published. Required fields are marked *


five − = three

Post Navigation