Device migration fields available for bulk data import

Modified on Wed, 19 Jan 2022 at 03:31 PM



Some projects may have information about devices that are not captured by the main inventory source used by ManagementStudio. E.g. Critical devices used behind a firewall. In this case, project administrators can use an Excel source to manually import the information into ManagementStudio. This article describes the fields that can be used.

For further information on data imports, please refer to this article.

Available Device Fields

Field NamesDescriptionRequired?
DeviceIdThe Device Id is a unique reference created by ManagementStudio when a device is imported into the ManagementStudio database. The use of this field will vary depending on the reason for the import:
  • Creating a New Device: This field should be left blank when importing new devices. ManagementStudio will allocate a Device Id as part of the import process
  • Updating an Existing Device: The Device Id is required to ensure the details in the bulk data import are mapped to the correct device. Device Ids can be exported from ManagementStudio and manually integrated with the bulk data import file using Excel:
    • Switch to the Devices (1) module in ManagementStudio
    • Click the Select All button (2) from the toolbar to select all devices
    • Click the Copy (3) dropdown arrow and select Export to Excel All (4)

Yes, when updating existing devices
HostNameThis is the label assigned to a device on a networkYes, when importing new devices
DomainThis is the network the device belongs to.Yes, when importing new devices
AssetTagThis is the tag affixed to a device that serves to identify it for tracking.Yes, when importing new devices
Start DateThe deployment unit start dateNo
Device TypeIts a group of devices, that allows you to gather devices and define common means to process the data they transmit. For example LaptopNo
Operating SystemIts a software that allows devices to run applications and programs. For example Microsoft Windows 7 EnterpriseNo
Process StatusThis is the internal Process status of the process the device is in.No
Service PackThis comprises of a collection of updates, fixes, enhancements to a software program delivered in the form of a single installable package.No
ProcessThe device's process can be set during the import process.  

For example, if the device is already in Scheduling, this could be added to the import file to enable ManagementStudio to change the Process from the default value of 1. Identified to the current status of 5. Scheduling.
Sub ProcessThe device's sub-process can be set during the import process.  This should be used in conjunction with the Process section above to ensure the correct sub-category is selected.

For example, if 5. Scheduling is selected as the Process, the Sub-Process should be set to Scheduling Queue or On Hold.
Migration TypeThis is the device migration type. For example, Kiosk, NormalNo
StatusThe status of the device.No
Deployment UnitThe deployment unit, the device belongs to.No
PriorityThe priority of the device can be recorded using the Priority field.  Out of the box, an administrator can choose from LowMedium and High. This field is often used to record the importance of a device.No
DU LocationThe deployment Unit location details.No
Assigned ToWho is this device assigned to within the project.No
Migration Slot StartThe device migration start date.No
MakeThe is the specific make of the device. For example Lenovo.No
Migration Slot EndThe device migration end date.No
ModelThis is the specific model of the device. For example ThinkPad T450.No
ProcessorThis the brains of a device. It's what handles the instructions of software apps. For example Core i5, Pentium.No
MemoryRefers to a device that is used to store information for immediate use in a computer hardware device. For example 8GB.No
ArchitectureThe architecture of the device. For example 32-bit, 64-bit.No
Build VersionThe build version of the device. For example 19041.804.No
IP AddressAn IP address is a numerical label assigned to each device connected to a computer network that uses the Internet protocol for communication. For example
Mac AddressIts a unique identifier assigned to a network interface controller for use as a network address in communications within a network segment. For example 00-14-22-01-23-45.No
SM Bios GuidThis defines data structures that can be used to read management information produced by the BIOS of a computer.No

Further Support

If you require further support, please visit ManagementStudio's Service Desk to search the knowledge base or create a new support ticket.