Here you will find queries that will list all of the resources that are currently listed on your SMS server’s specified subnet. There are two ways in which you can retrieve this information. One is using the “Like” statement for the IP addresses first 3 octets from the IP addresses view. The other uses the IP subnet from the IP subnets view.
IP Addresses View:
Select
SYS.Name0 'Machine Name',
IP.Ip_Addresses0 'IP Address'
From v_R_System SYS
Inner Join v_Ra_System_IpAddresses IP
On SYS.ResourceId = IP.ResourceId
Where IP.Ip_Addresses0 Like '192.168.1.%'
IP Subnets View:
SN.Ip_Subnets0
Inner Join v_Ra_System_IpSubnets SN
On SYS.ResourceId = SN.ResourceId
Where SN.Ip_Subnets0 = '192.168.1.0'
No Comments