Hi guys, Been deploying FEP on some servers, but lost track on which and how many. Now im trying to create a query for a collection with the following: OS: Server FEP 2010 not installed I can't seem to figure it out... :C I would appreciate some help from a SQL geek cos I can't figure it out with criterias only.

Hi, Try this out, it will list all SCCM client with an OS with "Server" in the name, check in both add remove programs and add remove programs 64 for "Microsoft Forefront Endpoint protection%: Regards, Jörgen 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_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.Caption like "%server%" and SMS_R_System.ResourceId not in (select distinct 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 like "Microsoft Forefront Endpoint Protection%") and SMS_R_System.ResourceId not in (select distinct SMS_R_System.ResourceId 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 "Microsoft Forefront Endpoint Protection%")-- My System Center blog ccmexec.com -- Twitter @ccmexec

Fast and effective, thanks Jörgen :)