Query to find missing file and filtered
Hello all,
I am trying to modify this query with no success to find systems that do not have Symantec Antivirus but filter by NetBIOS name, so I only get back systems that are like "IS%". Can some one help....?
Thanks,
Evans
I am trying to modify this query with no success to find systems that do not have Symantec Antivirus but filter by NetBIOS name, so I only get back systems that are like "IS%". Can some one help....?
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 where ResourceId not in (select SMS_R_System.ResourceID 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.FileName = "VPC32.exe")
Thanks,
Evans
0 Comments
[ + ] Show comments
Answers (0)
Please log in to answer
Be the first to answer this question
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.
