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