troubleshooting Question

SMS Query

Avatar of Mister_Spock
Mister_SpockFlag for United States of America asked on
Microsoft Server OS
3 Comments1 Solution1200 ViewsLast Modified:
I need help with a SMS Query. I can search on FILE_NAME = "Acrobat.exe" and FILE_VERSION is less than "8.0%" OR I can search for FILE_NAME = ""Illustrator.exe" but not both at the same time. I am using a sub select and have tried many different things.

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_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.FileName = "Acrobat.exe" and SMS_G_System_SoftwareFile.FileVersion < "8.0%" and SMS_G_System_SYSTEM.Name not in (select  distinct 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.FileName != "Illustrator.exe")
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros