SCCM 2012 Reports for installed Software(Inventory)

SCCM 2012 Reports for installed Software(Inventory)

This is sample report for MS Project

SELECT DISTINCT
                         sys.Netbios_Name0 AS [Computer Name], sys.User_Domain0 AS [Domain Name], sys.User_Name0 AS [User Name], sys.Operating_System_Name_and0 AS OS, arp.DisplayName0 AS [Software Name],
                         arp.Version0 AS [Version Number]
FROM            dbo.v_R_System AS sys INNER JOIN
                         dbo.v_Add_Remove_Programs AS arp ON sys.ResourceID = arp.ResourceID
WHERE        (arp.DisplayName0 LIKE N'%Project%') AND (NOT (arp.DisplayName0 LIKE N'%Security Update%')) AND (NOT (arp.DisplayName0 LIKE N'Hotfix%')) AND (NOT (arp.DisplayName0 LIKE N'Update for Microsoft%'))
                         AND (NOT (arp.DisplayName0 LIKE N'Microsoft Project MUI%')) AND (NOT (arp.DisplayName0 LIKE N'Microsoft Office Project MUI%')) AND (NOT (arp.DisplayName0 LIKE N'%Update For Windows%'))