Browse
Tools
Categories

 Featured
SiteAudit Asset Tool

Reference Number: AA-01141 Views: 5399 Last Updated: 09-16-2020 09:48 AM 0 Rating/ Voters

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:

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

For more information on Custom Fields: Custom Fields

Before creating Custom Fields, verify that the 'Server' and 'Database' fields are correct

1. Open the 'Netaphor SiteAudit Asset Tool'
2. Click the button 'Custom Fields'
3. Select 'Modify Custom Field Properties...' from the drop down menu


'Modify Custom Field Properties' window opens


Add String

4.a. Click the button, 'Add String'
5.a. Fill in the fields:

  • Column Name (Mandatory)
  • Category
  • Description

6.a. Click the button, 'Save'

A Custom Field String is added to SiteAudit


Add Integer

4.b. Click the button, 'Add Integer'
5.b. Fill in the fields:

  • Column Name (Mandatory)
  • Category
  • Description

6.b. Click the button, 'Save'

A Custom Field Integer is added to SiteAudit


Add Date

4.c. Click the button, 'Add String'
5.c. Fill in the fields:

  • Column Name (Mandatory)
  • Category
  • Description

6.c. Click the button, 'Save'

A Custom Field Date is added to SiteAudit


Delete a Custom Field

1. Select the Custom Filed to be deleted
2. Click the button, 'Delete'


Viewing the Custom Fields in SiteAudit

1. Open SiteAudit Viewer
2. Click on the Inventory Tab
3. Right Click the column header
4. Select the 'Column Chooser'


'Customization' window appears

5. Double-Click on the custom fields that were created in order to add them to the SiteAudit Viewer


The Custom Fields Appear in the SiteAudit Viewer


To quickly update Custom Fields
1. Export asset data from the SiteAudit Asset Tool
2. Open the CSV file with excel
4. Modify the Custom Fields
5. Save the modified CSV File
6. Import the modified CSV file with the SiteAudit Asset Tool
7. Verify the imported data is correct in SiteAudit


To inspect each printers Custom Fields Closely:

1. Right-Click on the printer that should be inspected
2. Select 'Details...' from the drop down menu



3. Click the 'Custom Fields' tab


Attachments
Organization_Import_Template.csv 2.7 Kb Download File