I've been building collections based on file name and version. Now i'm noticing that the file may show up in the Windows\Installer\$PatchCache as well which is throwing my collections off. Question: Is it possible to build a collection based on a file name and version but have it only look at a specific path? Example.... C:\Program Files\Adobe\Reader 9.0\Reader\AcroRD32.exe Thanks in advance

Very sorry for the bother but I figured it out.

Could you please post the Collection query for users that might search the internet and find this post. Then we can properly close this post out.http://www.sccm-tools.com http://sms-hints-tricks.blogspot.com

Great idea! Software Files.File Path is like "C:\Program Files\Adobe\Reader 9.0\Reader\%" and Software Files.File Name is like "acrord%.exe" and System Resource.System OU Name is equal to ""DOMAIN.COM/CITYOU/DEPTOU/COMPUTERS" and Software Files.File Version is less than "9.3.2.136" SQL Query: 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 like "C:\\Program Files\\Adobe\\Reader 9.0\\Reader\\%" and SMS_G_System_SoftwareFile.FileName like "acrord%.exe" and SMS_R_System.SystemOUName = "DOMAIN.COM/CITYOU/DEPTOU/COMPUTERS" and SMS_G_System_SoftwareFile.FileVersion < "9.3.2.136"