SCCM Query for Mozilla Firefox x64

Tonito Dux 956 Reputation points
2020-09-01T10:58:48.07+00:00

Hi,

I use this query to find out which objects have versions less than X version, but for some reason it does not work for Mozilla Firefox x64. Can somebody fix this query:

select SMS_R_System.Name, SMS_R_System.Client, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName, SMS_G_System_ADD_REMOVE_PROGRAMS.Version from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Google Chrome%" and SMS_G_System_ADD_REMOVE_PROGRAMS.Version < "85.0.4183.83"

Thanks

Microsoft Configuration Manager
0 comments
Accepted answer
  1. Tonito Dux 956 Reputation points
    2020-09-03T07:00:00.17+00:00

    Hi,

    to answer to myself:

    select SMS_R_System.Name, SMS_R_System.Client, SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName, SMS_G_System_ADD_REMOVE_PROGRAMS_64.Version from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS_64 on SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "Mozilla Firefox%" and SMS_G_System_ADD_REMOVE_PROGRAMS_64.Version < "80.0"

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Garth 5,801 Reputation points
    2020-09-01T12:42:58.46+00:00

    That is because you are only looking at hte 32bit ARP data. You need to look at the 64 bit ARP class., SMS_G_System_ADD_REMOVE_PROGRAMS64

    0 comments
  2. Simon Ren-MSFT 31,756 Reputation points Microsoft Vendor
    2020-09-02T08:46:00.303+00:00

    Hi,

    Thank you for coming Microsoft Q&A forum.

    Agree with Garth here. SMS_G_System_ADD_REMOVE_PROGRAMS will only find 32-bit versions of applications, so you may want to duplicate these same statements for 64-bit by using the SMS_G_System_ADD_REMOVE_PROGRAMS_64 table.

    For more information, please refer to:
    Subselect WQL Query to Find PCs That Do Not Have Either x86 or x64 Versions of Software Installed
    USE SCCM TO QUERY FOR GREATER THAN/LESS THAN APPLICATION VERSIONS

    Please note: The links are not from Microsoft, just for your reference. Thanks for your time.

    Best regards,
    Simon
    If the response is helpful, please click "Accept Answer" and upvote it.

    0 comments
  3. Tonito Dux 956 Reputation points
    2020-09-02T13:53:26.66+00:00

    Hi and thank you both for answering.

    Would it be an issue if you simply re-wrote the query? I am simply not good writing the queries.

    I searched again the internet but did not find a WORKING query.

    Cheers!

    0 comments