SCCM 2012 - Software Registered in add and remove programs excluding software updates

If you need the list of apps installed in add remove program and not the installed updates. This Query will be helpful.


Select A.DisplayName0 as 'Name of Software Installed',A.InstallDate0 as 'Date of Install', A.Version0 as 'Version Number',A.Publisher0 as 'Publisher Name'
FROM v_GS_ADD_REMOVE_PROGRAMS A, v_GS_COMPUTER_SYSTEM B
WHERE A.ResourceID = B.ResourceID
AND A.DisplayName0 NOT Like 'Update for Microsoft%'
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.Version0, A.Publisher0,A.InstallDate0
ORDER BY A.DisplayName0