Tag Archives: SCCM Query

SCCM collection for systems with IE 9

Use the below Query to create collections for the systems with Internet explorer 9 Note :- This query will work only, when you have enabled inventory collection for *.exe files. select distinct SMS_R_System.NetbiosName, SMS_R_System.LastLogonUserName, SMS_R_System.LastLogonUserDomain, SMS_R_System.SMSAssignedSites, SMS_G_System_SoftwareFile.FileVersion from SMS_R_System inner … Continue reading

Posted in SMS Query | Tagged , | Leave a comment