Provided here are SQL queries that will allow you to locate client resources from a specified subnet. The first example specifies (=) a subnet, the second one uses a wildcard (Like) and finally the third allows you to specify multiple subnets.
Specific Search:
Select Distinct
SD.Name0,
IP.Ip_Subnets0
From v_Ra_System_IpSubnets IP
Join v_R_System SD on IP.ResourceID = SD.ResourceID
Where IP.Ip_Subnets0 = '192.168.1.0'
Wildcard Search:
Where IP.Ip_Subnets0 Like '192.168.1.%'
Multiple Searches:
Where IP.Ip_Subnets0 In
('192.168.1.0',
'192.168.2.0')
Order by IP.Ip_Subnets0,SD.Name0
No Comments