SCCM Query for Mozilla Firefox x64

Question

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

Answer 1

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"

Answer 2

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

Answer 3

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.

Answer 4

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!