Create an ip range query on sccm 2012 sp1

[offrock]

Hi everybody,

 

I need to create an ip range query to a collection, i saw a lot of explanations:

 

I create this query for the ip range 10.201.0.50 10.201.0.254

 

select *
from SMS_R_System
where IPAddresses like "10.201.0.[5-9][0-9]"
or IPAddresses like "10.201.0.1[0-9][0-9]"
or IPAddresses like "10.201.0.2[0-5][0-4]"

 

But nothing machines display

 

In the general tab it's empty, is it normal?

 

thanks guys !!