SMS 2.0 Query

[rsekar]

How do you write a query in SMS 2.0 to check for an existence of a file? What I am trying to is to get the Query to list all the machines that are not installed with a particular software/

 

[tbrennans]

select SMS_G_System_SYSTEM.Name, SMS_R_System.LastLogonUserName from SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SYSTEM.Name not in (select SMS_G_System_SYSTEM.Name from SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileVersion = "4.03.003.1000" and SMS_G_System_SoftwareFile.FileName = "software.exe")