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%'))

SCCM 2012 R2 - Collection Query for IE 11 installed Computers

SCCM 2012 R2 - Collection Query for IE 11 installed Computers


select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceID inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceID where SMS_G_System_SoftwareFile.FilePath like "%\\Program Files\\Internet Explorer\\" and SMS_G_System_SoftwareFile.FileName like "iexplore.exe" and SMS_G_System_SoftwareFile.FileVersion like "11.%"