Use the SQL script below to list all the SMS resources found on a specified subnet.
SQL Query:
Select
Netbios_Name0 'Machine Name',
IP_Addresses0 'Last IP Address'
From System_IP_Address_ARR
Join System_Disc MachineName
on System_IP_Address_ARR.ItemKey = MachineName.ItemKey
Where IP_Addresses0 Like '192.168.1.%'
And Netbios_Name0 is not Null
Order by Name0 Asc
No Comments