HI, I am very new to SQL and SCCM and I need to set up a collection in SCCM 2007 based on IP range, however when using the querry this comes back with no results.The site has already been set up by my collegues and there are standard collections in place, but I need to create a seperate collection of jus the windows servers from a particular location.My Querry is very simple first on all "servers" and this works and filters out the workstations from the servers.The next step is I am filtering on AD site Names and this is filtering again - no errors.However the moment I try to run the following querry: SMS_R_System.IPAddresses like "10.(percentage sign).31.(percentage sign)" This shows no reults what so ever. There must be some other way of doing this or my query is invalid - though I get no error messages just no results.I have been trawling my way through different responses and fixes and nothing seems to work. Does someone have any suggestions for me or can point me in the right direction?Any help greatly appreciated.

Try This query in your collection, Dont forget to limit the query to the Servers collection you have created.select * 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.%.31.%"

Thanks! I will give this a whirl tomorrow.

Hi Ashu I was getting "syntax errors"with the query. However I managed to use a very simple query in the end and created the collection I needed :)But thanks for your reaction and help.

Sure, Just out of Curiosity what kind of Syntax errors did you get when you pasted the query in the collection? Coz I did not get the errors when I tested it in my environment and got the desired results.