SMS/ConfigMgr SQL query to find the list of systems in a specific IP subnet

SELECT SYS.Netbios_Name0, SYS.User_Domain0, SYS.User_Name0, AIP.IP_Subnets0, SYS.Client_Version0
FROM v_R_System  as SYS
JOIN v_RA_System_IPSubnets as AIP on SYS.ResourceID=AIP.ResourceID
WHERE AIP.IP_Subnets0 = '192.168.0.0'
Order by SYS.Netbios_Name0
Replace 192.168.0.1 with your IP subnet.

1 comments:

Anonymous said...

please tell me how to add multiple subnets

Post a Comment