AuditWizard - Administration - SQL Import - Locations

Back to Contents

Overview

As SQL Server is not maintained or supported by Layton Technology, our support can only be limited.

It is not possible to import all location information using the Assets and Locations method because that method imports assets with their locations. The asset is the focus of that method. A list of locations have to be imported directly into the database using Management Studio.

Table Structure

The table structure is as follows:

   _LOCATIONID,_FULLNAME,_NAME,_PARENTID,_START_IPADDRESS,_END_IPADDRESS,_HIDDEN

Column Name	Description
_LOCATIONID	Serial number for internal reference.
_FULLNAME	The name, with any parent names, separated by a backslash \.
_NAME	The name of this location without any parent names.
_PARENTID	The _LOCATIONID of any parent one level up.
_START_IPADDRESS	The starting IP address of a range that represents this location (optional).
_END_IPADDRESS	The ending IP address of the range (optional).
_HIDDEN	Unused at this time. Enter 0.

Example CSV File

   _LOCATIONID,_FULLNAME,_NAME,_PARENTID,_START_IPADDRESS,_END_IPADDRESS,_HIDDEN
   1,Home,Home,NULL,,,0
   14,Home\Site 01,Site 01,1,,,0
   15,Home\Site 02,Site 02,1,,,0
   16,Home\Site 03,Site 03,1,,,0
   17,Home\Site 01\Location 01,Location 01,14,13.14.5.1,13.14.5.255,0
   18,Home\Site 01\Location 02,Location 02,14,13.15.5.1,13.15.5.255,0
   19,Home\Site 02\Location 01,Location 01,15,48.3.14.1,48.3.14.255,0
   20,Home\Site 02\Location 02,Location 02,15,48.3.15.1,48.3.15.255,0
   21,Home\Site 02\Location 03,Location 03,15,,,0
   22,Home\Site 02\Location 04,Location 04,15,,,0
   23,Home\Site 03\Location 01,Location 01,16,,,0
   24,Home\Site 03\Location 02,Location 02,16,,,0
   25,Home\Site 03\Location 03,Location 03,16,,,0

Back to Contents