When you first deploy NightWatchman, chances are that you probably have not created any Location Groups yet. If so when you open NightWatchman Management Console, you will see all of the inventoried NightWatchman clients listed in the UNASSIGNED BUILDING location group. It would be kind of difficult to provide any meaningful location reports if they remained there.
Once you’re ready to create/import the necessary location groups and assign the NightWatchman clients to them, you can use the query below to quickly learn the IP Subnet(s) connected to by the clients.
The query results can then be used as the basis for identifying all the subnets that need to be defined in the .csv import-file.
Once you’ve followed the directions in the NightWatchman Console ImportWizard Helpfile to create the .csv import-file with the IP Subnet and location info’, you can then create the location groups…and watch all the NightWatchman clients “magically” disappear from the UNASSIGNED BUILDING location group!!
|
SELECT
netbiosname as 'Computer Name',
subnet as 'IP Subnet'
from tbAFR_Dimension_ConfigurationItem ci
join tbAFR_Dimension_SystemLocator sl on ci.Id = sl.ConfigItemId
join tbAFR_Dimension_NetworkAdapters na on na.ConfigurationItemId = sl.ConfigItemId
where TierId = 1 order by 'IP Subnet'
|
Read the complete post at http://www.1e.com/techblog/post/2009/08/18/Identifying-which-IP-Subnets-to-import-for-NightWatchman-Management-Console-Location-Groups-using-the-Import-Wizard.aspx