Saturday, July 25, 2015

SCCM report for all the applications available in SCCM

This report is for all the applications available in SCCM. Please note this is NOT for an inventory from client devices.
The following report provides;
- Application Name
- Application Vendor and
- Application Version
*********************************************************************
SELECT CI_UniqueID, DisplayName AS [Application Name], Manufacturer AS [Application Vendor], SoftwareVersion AS [Software Version]
FROM dbo.fn_ListLatestApplicationCIs(1033)

*********************************************************************
More SCCM custom reports can be found here

1 comment:

  1. May we fetch all application deployments which are marked as "Approval Required" in the deployment?

    ReplyDelete