SCCM report for installed applications excluding software updates

Report gives you all the installed applications excluding software updates .You can also customise to add other sec updates which you dont want them in report by adding  AND A.DisplayName0 NOT LIKE "name" at the end of report.

SELECT A.DisplayName0,A.InstallDate0 A.Version0,A.Publisher0

FROM v_GS_ADD_REMOVE_PROGRAMS A, v_GS_COMPUTER_SYSTEM B
WHERE A.ResourceID = B.ResourceID
AND A.DisplayName0 NOT LIKE ‘Hotfix for %’
AND A.DisplayName0 NOT LIKE ‘Security Update for %’
AND A.DisplayName0 NOT LIKE ‘Update for Microsoft %’
AND A.DisplayName0 NOT LIKE ‘Update for Office %’
AND A.DisplayName0 NOT LIKE ‘Update for Outlook %’
AND A.DisplayName0 NOT LIKE ‘Update for Windows %’
AND A.DisplayName0 NOT LIKE ‘Windows XP Hotfix%’

AND Name0 = @computer

GROUP BY A.DisplayName0,A.InstallDate0,A.Version0, A.Publisher0
ORDER BY A.DisplayName0

Prompt for creating @ computer:

select Name0 from v_GS_COMPUTER_SYSTEM

Leave a Reply