Netaphor SiteAudit™ Asset Tool

The SiteAudit Asset Tool is a new tool that is installed with SiteAudit version 7.0.  This tool can be used to perform the following actions:

• Import a company organization including department addresses, contacts, networks, and other details
• Automatically import discovery networks, ranges, and IP addresses or save an import file to import at a later time
• Automatically import the organization hierarchy or save an import file for import at a later time
• Create, edit, and delete custom fields
• Export or import asset information and custom field values

Using the SiteAudit Asset Tool

The SiteAudit Asset Tool can be launched from the Windows Start menu

• When used with SiteAudit OnSite, the Asset Tool connects automatically to the same database configured in the SiteAudit Viewer
• A DCF file, that provides access to one or more customer, is used to access SiteAudit Hosted customer databases

The SiteAudit Asset Tool application

Using a DCF file with the Asset Tool (Control Panel can create DCF file)

A DCF file is required to connect to SiteAudit Hosted customers. Refer to the following article to learn how to create your DCF file.

1. Click the button, 'Use DCF file' which opens the Open file dialog
2. Navigate to the folder where the DCF file resides and select it
3. Click the 'Open' button
4. Use the Database dropdown list to select the desired customer

Exporting Asset Data with the SiteAudit Asset Tool

The SiteAudit Asset Tool can be used to change the value of asset information and custom fields. It is always recommended to first export the asset data, which creates a CSV file containing the existing information properly formatted. Open the CSV file in Excel, edit the desired fields, then save an import the modified file.

Before exporting, verify that 'Server' and 'Database' fields are correct

1. Open the 'Netaphor SiteAudit Asset Tool'
2. Click the button 'Asset Data'
3. Select 'Export...' from the drop down menu

A File Explorer will appear once 'Export...' has been selected.

Select the folder where the file is saved and enter a file name

The exported data now can be opened with excel and modified with excel

A successful export log will also be displayed in the Asset Tool's TextBox

The file can be edited in Microsoft Excel and imported to update the customer database with the desired changes. The image below is an example of asset information that has been exported from a customer database.

Import Asset and Custom Field Information into Customer Database

In order to import asset information and custom field values into a SiteAudit customer database, it is necessary to provide a properly formatted file as shown in the example below. This file can be generated by first exporting the asset data as described in the previous section.

New data has been added to the following columns (The columns have been selected in grey): 

• asset_tag
• nss_string_0 
• nss_date_0
• nss_integer_0

These columns are 'Custom Fields.' In order to use these columns, 'Custom Fields' must first be created.
Go the section Create and modify Custom Fields with the SiteAudit Asset Tool for information on creating Custom Fields.

The CSV file now ready to be imported back into the SiteAudit Viewer, to Import back into SiteAudit.

Importing asset data with the SiteAudit AssetTool

Before  importing, verify that the 'Server' and 'Database' fields are correct

1. Open 'Netaphor SiteAudit Asset Tool'
   
2. Click the button 'Asset Data'
   
3. Select 'Import...' from the drop down menu

Select the CSV file that should be imported.

example: 

• Name of the CSV file: export.CSV
• Path of the CSV file: C:\tmp\export.csv

The example below shows SiteAudit View before an import.
*Note the values in the column, 'Asset Tag'

After an import has occurred, the column 'Asset Tag' has been updated.

An export log will be displayed in the Asset Tool's TextBox, which is underneath the 'Database' field
In the example below, a successful export log is displayed.

Import company information with the SiteAudit Asset Tool

The SiteAudit Asset Tool takes Company information in a CSV File and then transforms the CSV File into two XML files. Once the transformation as has taken place,
a prompt will be generated asking whether to import the information into SiteAudit Viewer or not.

Company Information: 

• Organizational hierarchy 
• Printer department assignments,
• Contact information
• Discovery ranges  
• Other data

For more information, read these articles:

• importing Company Information: Importing Organization
• Discovery Ranges: Importing Discovery Ranges
• Networks addresses: Importing Discovery Networks
• Device IP addresses: Importing Discovery IP Addresses

Before importing, verify that 'Server' and 'Database' fields are correct

1. Open the 'Netaphor SiteAudit Asset Tool'
2. Click the button 'Company'
3. Select 'Import Information...' from the drop down menu

'Select Import Template' dialogue should appear.

4. Select the the CSV file to import
5. Click 'Open'

6. Click 'Yes'

Two new XML files have been created.
The XML files will be imported into the SiteAudit Viewer

Note: If the inventory has not updated after a Company Information import has occurred.

• right click on the first node in the inventory section
• select 'Company Organization...'

Company Organization Before an import has occurred

Company Organization After an Import has occurred

Inventory Before an import has occurred

Inventory After an Import has occurred

A successful Import log will also be displayed in the Asset Tool's Text Box

Sample Organization Import File

The organization import is a CSV file. A sample import file is installed with the SiteAudit Viewer or SiteAudit Control Panel and is located in the following folder C:\Program Files\Netaphor\SiteAudit\Samples\en\Organization_Import_Template.csv  This file is also attached at the bottom of this article and produces the following organization.

Create and modify Custom Fields with the SiteAudit Asset Tool

The SiteAudit Asset Tool Custom Fields tool allows the user

• Save: 15 custom fields
  
• 6 string fields
• 3 date fields
• 6 integer fields
  
• Reset
• Resets the text fields before the custom field is saved, once the field is saved, the field cannot be reset.
  
• Delete
• Deletes a custom field