Import Device Data (Hardware Inventory Data)
Device hardware inventory data can be import via the Sam360 Web Portal ‘Import Data’ page. To import device data…
- Log in to the Sam360 web portal.
- Click the ‘Settings’ button on the top right of the screen.
- Click on the ‘Import Data’ menu option on the left menu bar.
- Select ‘Device Data’ from the ‘Data Import Type’ dropdown menu
- Click the ‘Choose file’ button to browse for the file to be imported. Select the file and click ‘Open’ Note: Only one file can be imported at a time, the content and format of this file are explained below
- Click the ‘Upload’ button.
- The device data will now be imported and queued for processing. Data is generally processed within a minute of importing, although this can be longer if the platform is busy.
Import File Format
Device data can only be imported as a single CSV file. The CSV file format used for the device data file is described below.
Device Data CSV format
The Device Data Hardware Inventory Details import CSV file (comma delimited) should contain the following columns.
Column Title | Description | Sample Value |
---|---|---|
Name | Unique machine name (MANDATORY) | Device1 |
Domain | The machines domain name | testdomain |
DomainFQN | The machines domain name, long form | testdomain.local |
BiosSerialNumber | The machines BIOS serial number | VMware-50 2f d3 7b d2 44 e7 36-a5 32 d4 b7 91 a7 bc 55 |
SystemBIOSDate | The machines BIOS release date | 2014-14-04 00:00:00 |
ADLastLogonDate | The last time the machine connected to AD | 2018-04-17 21:45:00 |
LastScanTime | When the last hardware scan was performed | 2018-04-17 22:22:00 |
TotalRAM | The amount of RAM the machine has | 16382 |
Processors | The machines processor count | 4 |
Cores | The total number of cores per processor | 1 |
LogicalProcessors | The machines logical processor count | 4 |
ProcessorName | The machines processor name | Intel(R) Xeon(R) CPU E5-2650 v2 @ 2.60GHz |
SystemProductName | The machine model | VMware Virtual Platform |
A sample Device Data import file can be downloaded here.
Leave A Comment