I have a few different collections setup and set to look for anything where the client is not installed or is NULL. The problem is that I have another set for an individual division and I thought the only difference is that one is looking in everywhere and the other is only looking within a certain division.Here's my "everything without clients" collection: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.OperatingSystemNameandVersion not like "%server%" and SMS_R_System.SystemOUName = "int.chickasaw.net" and (SMS_R_System.Client = 0 or SMS_R_System.Client is null )Here's my division non-client: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.SystemOUName = "INT.CHICKASAW.NET/CNHD" and SMS_R_System.OperatingSystemNameandVersion not like "%Server%" and (SMS_R_System.Client = 0 or SMS_R_System.Client is null )There are 0 computers in my "All Computers without client" and there are 10 in the "CNHD". I do know which collection I should base my report off of.

What was bothering me so much is that we had your collection, John, but when I tried to use it to break down by AD group/division, it would show computers in it, but the one that didn't look at any AD groups (your original collection) had nothing.

So this returns nothing? 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.Client = 0 or SMS_R_System.Client is null) and SMS_R_System.OperatingSystemNameandVersion not like "%server%" John Marcum | http://www.TrueSec.com/en/Training.htm | http://myitforum.com/cs2/blogs/jmarcum