Thursday, October 14, 2010

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.%"

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home