Subnet Collection Query, System Center 2012

This will include only one subnet - 10.0.1.0:
select *  from  SMS_R_System where SMS_R_System.IPSubnets = "10.0.1.0"
This will include two subnets - 10.0.1.0 and 10.0.2.0:
select *  from  SMS_R_System where SMS_R_System.IPSubnets = "10.0.1.0" OR SMS_R_System.IPSubnets = "10.0.2.0"

No comments: