AuditWizard - Administration - SQL Import - Assets

From Layton Support
(Difference between revisions)
Jump to: navigation, search
(New page)
 
(Major addition)
Line 11: Line 11:
 
     _OVERWRITEDATA,_ASSETTAG
 
     _OVERWRITEDATA,_ASSETTAG
  
 +
{| class="wikitable" border="1"
 +
|-style="vertical-align:top;"
 +
! style="background:#009999; width: 200px; color: #FFFFFF"|Column Name
 +
! style="background:#009999; width: 800px; color: #FFFFFF"|Description
 +
|-style="vertical-align:top;"
 +
|_ASSETID
 +
|Serial number for internal reference. Exclude this column.
 +
|-
 +
|-style="vertical-align:top;"
 +
|_UNIQUEID
 +
|Another serial number used for internal reference to identify computers. Leave this blank.
 +
|-
 +
|-style="vertical-align:top;"
 +
|_NAME
 +
|The name of this asset.
 +
|-
 +
|-style="vertical-align:top;"
 +
|_LOCATIONID
 +
|The _LOCATIONID from the LOCATIONS table. Look up the _LOCATIONID and enter the numeric ID, not the actual name. If in doubt, enter ''1''.
 +
|-
 +
|-style="vertical-align:top;"
 +
|_DOMAINID
 +
|The _DOMAINID from the DOMAINS table. Look up the _DOMAINID and enter the numeric ID, not the actual name. If in doubt, enter ''1''.
 +
|-
 +
|-style="vertical-align:top;"
 +
|_PARENT_ASSETID
 +
|The _ASSETID of a parent asset. Most likely not applicable, so enter ''0''.
 +
|-
 +
|-style="vertical-align:top;"
 +
|_IPADDRESS
 +
|Not applicable to a device. Leave this blank.
 +
|-
 +
|-style="vertical-align:top;"
 +
|_MACADDRESS
 +
|Not applicable to a device. Leave this blank.
 +
|-
 +
|-style="vertical-align:top;"
 +
|_LASTAUDIT
 +
|Not applicable to a device. Leave this blank.
 +
|-
 +
|-style="vertical-align:top;"
 +
|_HIDDEN
 +
|Not applicable to a device. Enter ''0''.
 +
|-
 +
|-style="vertical-align:top;"
 +
|_REQUESTAUDIT
 +
|Not applicable to a device. Enter ''0''.
 +
|-
 +
|-style="vertical-align:top;"
 +
|_AGENT_STATUS
 +
|Not applicable to a device. Enter ''0''.
 +
|-
 +
|-style="vertical-align:top;"
 +
|_ASSETTYPEID
 +
|The _ASSETTYPEID from the ASSET_TYPES table. Look up the Asset Type and enter the numeric ID, not the actual name. You may have to '''[[AuditWizard - Using AuditWizard - Administration - Data Setup - Asset Types|add an asset type in AuditWizard]]'''. If in doubt, enter ''2'' (''PC'').
 +
|-
 +
|-style="vertical-align:top;"
 +
|_MAKE
 +
|The make of the asset.
 +
|-
 +
|-style="vertical-align:top;"
 +
|_MODEL
 +
|The model of the asset.
 +
|-
 +
|-style="vertical-align:top;"
 +
|_SERIAL_NUMBER
 +
|The serial number of the asset.
 +
|-
 +
|-style="vertical-align:top;"
 +
|_SUPPLIERID
 +
|The _SUPPLIERID from the SUPPLIERS table. Look up the _SUPPLIERID and enter the numeric ID, not the actual name. If in doubt, enter ''1''.
 +
|-
 +
|-style="vertical-align:top;"
 +
|_STOCK_STATUS
 +
|One of four statuses to indicate whether an asset is in use or disposed. Enter ''1'' (in use).
 +
|-
 +
|-style="vertical-align:top;"
 +
|_AGENT_VERSION
 +
|Not applicable to a device. Enter ''0''.
 +
|-
 +
|-style="vertical-align:top;"
 +
|_ALERTS_ENABLED
 +
|Not applicable to a device. Enter ''0''.
 +
|-
 +
|-style="vertical-align:top;"
 +
|_OVERWRITEDATA
 +
|Records whether or not the '''[[AuditWizard - Using AuditWizard - Administration - Auditing - Upload Options#Overwrite User-Defined Data|Overwrite User-Defined Data]]''' is enabled. Enter ''0''.
 +
|-
 +
|-style="vertical-align:top;"
 +
|_ASSETTAG
 +
|Essentially the same as _NAME. Enter the same name.
 +
|}
 
===Example CSV File===
 
===Example CSV File===
−
 
+
    _ASSETID,_UNIQUEID,_NAME,_LOCATIONID,_DOMAINID,_PARENT_ASSETID,_IPADDRESS,_MACADDRESS,_LASTAUDIT,_HIDDEN,_REQUESTAUDIT,
 +
    _AGENT_STATUS,_ASSETTYPEID,_MAKE,_MODEL,_SERIAL_NUMBER,_SUPPLIERID,_STOCK_STATUS,_AGENT_VERSION,_ALERTS_ENABLED,
 +
    _OVERWRITEDATA,_ASSETTAG
 +
    ,TAB-01,1,1,0,,,,0,0,0,17,Apple Inc.,iPad Mini 2 16GB ME784LL/A,1234567890,1,1,,0,0,TAB-01
 +
    ,TAB-02,1,1,0,,,,0,0,0,17,Apple Inc.,iPad Mini 2 16GB ME784LL/A,1234567891,1,1,,0,0,TAB-02
 +
    ,TAB-03,1,1,0,,,,0,0,0,17,Apple Inc.,iPad Mini 2 16GB ME784LL/A,1234567892,1,1,,0,0,TAB-03
 +
    ,TAB-04,1,1,0,,,,0,0,0,17,Apple Inc.,iPad Mini 2 16GB ME784LL/A,1234567893,1,1,,0,0,TAB-04
 +
    ,TAB-05,1,1,0,,,,0,0,0,17,Apple Inc.,iPad Mini 2 16GB ME784LL/A,1234567894,1,1,,0,0,TAB-05
 
<p align="right">[[File:btn_back_up.png|link=User Guide for AuditWizard]] [[User Guide for AuditWizard|<u>Back to Contents</u>]]</p>
 
<p align="right">[[File:btn_back_up.png|link=User Guide for AuditWizard]] [[User Guide for AuditWizard|<u>Back to Contents</u>]]</p>

Revision as of 05:32, 24 November 2016

Btn back up.png Back to Contents

Contents

Overview

A CSV file can be prepared to match the columns of the ASSET table so that an import can be done. There is no need to import computers, as they can be audited and imported that way. This procedure would normally be done on non-auditable assets. Note that any user-defined data would have to imported separately.

Table Structure

The table structure is as follows: 

   _ASSETID,_UNIQUEID,_NAME,_LOCATIONID,_DOMAINID,_PARENT_ASSETID,_IPADDRESS,_MACADDRESS,_LASTAUDIT,_HIDDEN,_REQUESTAUDIT,
   _AGENT_STATUS,_ASSETTYPEID,_MAKE,_MODEL,_SERIAL_NUMBER,_SUPPLIERID,_STOCK_STATUS,_AGENT_VERSION,_ALERTS_ENABLED,
   _OVERWRITEDATA,_ASSETTAG
Column Name Description
_ASSETID Serial number for internal reference. Exclude this column.
_UNIQUEID Another serial number used for internal reference to identify computers. Leave this blank.
_NAME The name of this asset.
_LOCATIONID The _LOCATIONID from the LOCATIONS table. Look up the _LOCATIONID and enter the numeric ID, not the actual name. If in doubt, enter 1.
_DOMAINID The _DOMAINID from the DOMAINS table. Look up the _DOMAINID and enter the numeric ID, not the actual name. If in doubt, enter 1.
_PARENT_ASSETID The _ASSETID of a parent asset. Most likely not applicable, so enter 0.
_IPADDRESS Not applicable to a device. Leave this blank.
_MACADDRESS Not applicable to a device. Leave this blank.
_LASTAUDIT Not applicable to a device. Leave this blank.
_HIDDEN Not applicable to a device. Enter 0.
_REQUESTAUDIT Not applicable to a device. Enter 0.
_AGENT_STATUS Not applicable to a device. Enter 0.
_ASSETTYPEID The _ASSETTYPEID from the ASSET_TYPES table. Look up the Asset Type and enter the numeric ID, not the actual name. You may have to add an asset type in AuditWizard. If in doubt, enter 2 (PC).
_MAKE The make of the asset.
_MODEL The model of the asset.
_SERIAL_NUMBER The serial number of the asset.
_SUPPLIERID The _SUPPLIERID from the SUPPLIERS table. Look up the _SUPPLIERID and enter the numeric ID, not the actual name. If in doubt, enter 1.
_STOCK_STATUS One of four statuses to indicate whether an asset is in use or disposed. Enter 1 (in use).
_AGENT_VERSION Not applicable to a device. Enter 0.
_ALERTS_ENABLED Not applicable to a device. Enter 0.
_OVERWRITEDATA Records whether or not the Overwrite User-Defined Data is enabled. Enter 0.
_ASSETTAG Essentially the same as _NAME. Enter the same name.

Example CSV File

   _ASSETID,_UNIQUEID,_NAME,_LOCATIONID,_DOMAINID,_PARENT_ASSETID,_IPADDRESS,_MACADDRESS,_LASTAUDIT,_HIDDEN,_REQUESTAUDIT,
   _AGENT_STATUS,_ASSETTYPEID,_MAKE,_MODEL,_SERIAL_NUMBER,_SUPPLIERID,_STOCK_STATUS,_AGENT_VERSION,_ALERTS_ENABLED,
   _OVERWRITEDATA,_ASSETTAG
   ,TAB-01,1,1,0,,,,0,0,0,17,Apple Inc.,iPad Mini 2 16GB ME784LL/A,1234567890,1,1,,0,0,TAB-01
   ,TAB-02,1,1,0,,,,0,0,0,17,Apple Inc.,iPad Mini 2 16GB ME784LL/A,1234567891,1,1,,0,0,TAB-02
   ,TAB-03,1,1,0,,,,0,0,0,17,Apple Inc.,iPad Mini 2 16GB ME784LL/A,1234567892,1,1,,0,0,TAB-03
   ,TAB-04,1,1,0,,,,0,0,0,17,Apple Inc.,iPad Mini 2 16GB ME784LL/A,1234567893,1,1,,0,0,TAB-04
   ,TAB-05,1,1,0,,,,0,0,0,17,Apple Inc.,iPad Mini 2 16GB ME784LL/A,1234567894,1,1,,0,0,TAB-05

Btn back up.png Back to Contents

Retrieved from "http://laytontechnology.com/support/index.php?title=AuditWizard_-_Administration_-_SQL_Import_-_Assets&oldid=7171"
Personal tools
Namespaces

Variants
Actions
Main Page
Online User Guides
General Support
Release Notes
Toolbox