query related to collections

[Prajwal Desai]

I have deployed SCCM 2007 R3 in my company.. I have created collections for laptops and Workstations. We have symantec antivrus clients (12.1) installed on laptops and workstations. Can i write a query to find the computers where symantec AV clients are not installed. I wrote query to find symantec AV installed, its working fine. But how do i find computers where symantec AV is not installed. Please help me out...

[Robert R.]

This should help you out:

 

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 where SMS_R_System.ResourceId not in (select SMS_R_SYSTEM.ResourceID 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 = "ENTER NAME AS IT APPEARS IN PROGRAMS AND FEATURES " and SMS_G_System_ADD_REMOVE_PROGRAMS.Version = "ENTER VERSION NUMBER AS IT APPEARS IN PROGRAMS AND FEATURES") and SMS_R_System.Client = 1