/build/static/layout/Breadcrumb_cap_w.png

SCCM 2012 R2 Query for Software not Installed - Prompts for Software Name

Today I created this custom query to help look for devices which do not have a specified software installed.  I create the query to prompt for the collection and then then enter a value for Software.ARPDisplay Name.  Here is the query:


select distinct SMS_R_System.Name, SMS_R_System.OperatingSystemNameandVersion, SMS_G_System_CH_ClientSummary.ClientActiveStatus, SMS_R_System.IPAddresses, SMS_R_System.LastLogonUserName from  SMS_R_System inner join SMS_G_System_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_CH_ClientSummary on SMS_G_System_CH_ClientSummary.ResourceID = SMS_R_System.ResourceId

where SMS_R_System.ResourceId not in (select SMS_R_System.ResourceId from  SMS_R_System inner join SMS_G_System_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_CH_ClientSummary on SMS_G_System_CH_ClientSummary.ResourceID = SMS_R_System.ResourceId

where SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName like ##PRM:SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName##)

order by SMS_R_System.Name


Let me know if you find this useful.



Comments

This post is locked

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ