SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPAddress like "10.5.%" I have over 100 computers that I now should fit the criteria. I notice 51 results. What is interesting is when I use the criterion properties ui to create the query statement I can click on the "Value..." button and I can see 51 values that matches all the 51 I have in my collection. Now my question is why is the value only picking up 51 when I know there are over 100 and I can see others not listed. I can go to all systems and look at the properties of a computer and see that it is active and falls within the specified collection query I am building. It seems like the query statement builder isn't noticing everything. Can anyone explain what may be happening and how to resolve it. I am using SCCM 2007 R2.

Hi Adam, can you paste your query in a reply?Kent Agerlund | http://scug.dk/members/Agerlund/default.aspx | The Danish community for System Center products

What's displayed when you right-click on a resource and choose properties is from the discovery and thus from SMS_R_SYSTEM. For IP Addresses this should be coming from whatever name resolution is in place, probably DNS. SMS_G_System_NETWORK_ADAPTER_CONFIGURATION is populated from the hardware inventory which comes the system itself and may not match up with the name resolution infrastrucutre in place or may just not be be populated yet. Use Resource Explorer to confirm this on an individual basis or reporting.Jason | http://myitforum.com/cs2/blogs/jsandys | http://blogs.catapultsystems.com/jsandys/default.aspx | Twitter @JasonSandys

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_NETWORK_ADAPTER_CONFIGURATION on SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.ResourceID = SMS_R_System.ResourceId where SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPAddress like "10.5.%.%" I see what Jason is talking about. How do I access the SMS_R_System Ip address? I don't how to access the IP from that property.

Do you know how to query the SMS_R_system for the IP address? I didn't see an easy way to do it, I could be missing something.

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.IPAddresses like "192.168.%.%""Everyone is an expert at something" Kim Oppalfens Configmgr expert for lack of any other expertise. http://www.scug.be/blogs/sccm