SCCM Query to display x86 x64 Visio Installs

This query is pretty self explanatory 🙂

select distinct SMS_R_System.Name, SMS_R_System.ResourceId, SMS_R_System.MACAddresses, SMS_R_System.LastLogonUserName from SMS_R_System where SMS_R_System.ResourceId in ( select
SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID
from
SMS_G_System_ADD_REMOVE_PROGRAMS
where
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = “Microsoft Visio Standard 2010”) or SMS_R_System.ResourceId in ( select
SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID
from
SMS_G_System_ADD_REMOVE_PROGRAMS_64
where
SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName = “Microsoft Visio Standard 2010”)

Advertisements