Convert SCCM query to WMI


  • Hello - We will soon be upgrading to SCCM current branch.  However until then we are using SCCM 2007 (I know, I kow...).  We are rolling out software via SCCM and AD GPO.  For the GPO, we will use a WMI query to find all installed Firefox versions less than 45.0.2.  I will also use a similar query for SCCM.  However I'm hoping one of you could interpret the below SCCM and convert it into a WMI query.  Or perhaps they are the same.  I'd really appreciate it.

    select distinct SMS_G_System_SYSTEM.Name, SMS_G_System_SoftwareFile.FileName, SMS_G_System_SoftwareFile.FileVersion, SMS_R_System.SystemOUName 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.FilePath like "%\\Program Files\\Mozilla Firefox\\" or SMS_G_System_SoftwareFile.FilePath like "%\\Program Files (x86)\\Mozilla Firefox\\") and SMS_G_System_SoftwareFile.FileVersion < "45.0.2" and SMS_G_System_SoftwareFile.FileName = "firefox.exe" order by SMS_G_System_SYSTEM.Name

    • Moved by Garth JonesMVP Tuesday, June 07, 2016 8:17 PM Not a CM07 Q. It is a GPO Q.
    Tuesday, June 07, 2016 4:44 PM