AuditWizard - Administration - SQL Import - Assets
From Layton Support
(Difference between revisions)
(New page) |
Revision as of 05:19, 24 November 2016
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