Build a collection based on folder Existence

[RegDriver]

Hi Guys,

Pretty new to this game. Im trying to build a collection based on PC,s having a certain folder on there C drive. can you tell me if this is correct??

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 where SMS_G_System_SoftwareFile.FilePath = "C:\\test"

Cheers