Configmgr(SCCM) report for computers falls within Subnet

had a requirement to see how many computer falls within the specific subnet.

select a.name0,b.IP_Subnets0 from v_R_System a,dbo.v_RA_System_IPSubnets b
where a.ResourceID=b.ResourceID and b.IP_Subnets0 in ('192.168.10.0')
group by a.name0,b.IP_Subnets0

You can include other subnet details if you need.

2 Responses to "Configmgr(SCCM) report for computers falls within Subnet"

  1. hello there and thank you for your info – I've certainly picked up anything new from right here. I did however expertise several technical issues using this web site, since I experienced to reload the web site a lot of times previous to I could get it to load correctly. I had been wondering if your web host is OK? Not that I'm complaining, but sluggish loading instances times will sometimes affect your placement in google and could damage your high quality score if advertising and marketing with Adwords.
    Anyway I am adding this RSS to my email and can look out for much more of your respective intriguing content.
    Make sure you update this again soon.

    Reply

Leave a Reply