Inventory Spreadsheet Templates

IT Asset Management (Cloud)

In contrast with other chapters in this document, this chapter takes a different approach: rather than documenting the schema of the central database for IT Asset Management, it describes the formats acceptable for spreadsheet (.xslx) or comma-separated value (.csv) files that can be used to import various kinds of inventory information into the central database. For each data element, it shows which database table, and which column in that table, is the final destination for the imported data. (For details about importing inventory as spreadsheets or CSV files, see the chapter Importing Inventory Spreadsheets and CSV Files in the companion volume, IT Asset Management System Reference.)

Such spreadsheet (including CSV) files can be imported through two different paths:
  • Using the web interface for IT Asset Management, the data may be uploaded directly to the central application server(s) as a one-time upload
  • Optionally with a repeatable schedule, the data may also be uploaded through an inventory beacon.

The same templates are used for inventory imports through either of these channels.