WQL query to find machines with IE version 7
select distinct SMS_G_System_SoftwareFile.FileDescription, SMS_G_System_SoftwareFile.FileVersion,SMS_G_System_SYSTEM.Name,
SMS_G_System_OPERATING_SYSTEM.Caption from SMS_R_System inner join SMS_G_System_SoftwareFile on
SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_SYSTEM on
SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_OPERATING_SYSTEM on
SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId WHERE
SMS_G_System_SoftwareFile.FileName = "iexplore.exe" AND SMS_G_System_SoftwareFile.FilePath like "%prog%internet%"
and SMS_G_System_SoftwareFile.Fileversion like "7.%"
SMS_G_System_OPERATING_SYSTEM.Caption from SMS_R_System inner join SMS_G_System_SoftwareFile on
SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_SYSTEM on
SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_OPERATING_SYSTEM on
SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId WHERE
SMS_G_System_SoftwareFile.FileName = "iexplore.exe" AND SMS_G_System_SoftwareFile.FilePath like "%prog%internet%"
and SMS_G_System_SoftwareFile.Fileversion like "7.%"
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home