Devices Import Guide

CSV Order Friendly Name Description Required for new record? Required for update? Other Requirements Sample CSV Data
1 Device Name The workstation name for the computer. For BYOX devices, leave this field blank. YES YES No spaces or special characters allowed. WS1234105428
2 Asset ID The asset identifier for the device. NO NO No spaces or special characters allowed. XX1234005428
3 Serial Number This is the manufacturer’s alphanumeric, unique identification number for the device. Only mandatory for school-owned assets. YES NO No spaces or special characters allowed. 573M32S
4 MAC Address The physical mac address of the device’s primary network adapter. This field is used as the unique identifier for BYOX devices and is mandatory for BYOX devices. NO NO Spaces and special characters (including ‘:’) are not allowed. 3C970EC021F1
5 Manufacturer The brand (make) of the device. Only mandatory for school-owned assets. YES NO Lenovo
6 Model The model of the device. Only mandatory for school-owned assets. YES NO Latitude E5400
7 Description A custom text description for the device. NO NO N/A CFS Computer
8 Device Type Specifies whether the device is a school-owned asset. YES NO Accepted values: ‘School’, ‘BYOX’ School
9 Purchase Date The date the device was invoiced (acquired). NO NO Needs to be a valid date (DD/MM/YYYY). 24-11-2015
10 Warranty Expiry The date the device’s warranty cover expires. NO NO Needs to be a valid date (DD/MM/YYYY). Must be greater (more recent) than ‘Purchase_Date’. 24-11-2015
11 Status The current state of the device. This field is only required for school-owned devices. BYOX devices inherent this attribute from their assigned owner. YES NO Accepted values: ‘Disposed’, ‘Active’, ‘Spare Parts’, ‘Stolen / Missing’, ‘Suspended’. Active
12 Insurance Specifies whether or not the device is covered by insurance (accidental damage protection). YES NO Accepted values: ‘No’, ‘Yes’. Yes
13 Insurance Expiry The date the device’s accidental damage protection (insurance) cover expires. NO NO Needs to be a valid date (DD/MM/YYYY). Must be greater (more recent) than ‘Purchase_Date’. 24-11-2015
14 Campus Identifies the device’s location YES NO Ensure exact match with the actual name of the campus in OrchestrateIT (case sensitive). This field is only required for school-owned devices. BYOX devices inherit this attribute from their assigned owner. Gold Coast
15 Manufacturer UUID The manufacturer’s unique identifier for the device. NO NO N/A 1AF4199D-D408-411D-9106-48B67B389735
16 Initial Authentication Date (BYOX) The date that the BYOX device was initially connected to the network. NO NO Needs to be a valid date (DD/MM/YYYY). 24-11-2015
17 Last Connection Date (BYOX) The date that the BYOX device was most recently seen on the network. NO NO Needs to be a valid date (DD/MM/YYYY). 24-11-2015
18 BYOX Profile The name of the BYOX profile assigned to the device. NO NO N/A Windows 10
19 Assigned User The ID number or username of an existing user whom the device should be assigned to, commencing from the date of import. If you require the ability to assign a custom start date or to assign historic device ownership records, please use the ‘User Device Assignment’ import mode instead. NO NO This field is mandatory for BYOX devices and optional for school assets. 1234567890E