Collection query for installed software

[urichai]

Hi everyone,

I've created a query to populate a collection for an audit of Symantec Endpoint Protection. The results were less than I expected. The collection only found 200'ish pc's when there should be well over 2000. I've got my Hardware Inventory cycle set to 12 hours and I waited around a few days to see if that number increased but it didn't. Maybe my query syntax is just not right. Please review and let me know what the heck I'm doing wrong.

 

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client 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 = "Symantec Endpoint Protection" and SMS_R_System.Client = 1

[GarthMJ]

You are only querying the x86 software titles. You need to use the x64 view to get the x64 SW titles.

[urichai]

Ooohhhhhhhh !!! That makes complete sense. That would explain my results perfectly.

How do I change it to query x64 ?

[urichai]

I think I just answered my own question ....

SMS_G_System_ADD_REMOVE_PROGRAMS_64 ?

[urichai]

Worked like a charm. Thanks for your help GarthMJ. Have a great day !

[GarthMJ]

Just keep in mind that you can't query for both x86 and x64 within the same query. You will need to use sub select queries or you can use two different queries fro the collections.