E.1 Format of exported or imported smart device list CSV file
The following table describes the format of an exported or imported smart device list CSV file.
Format of an exported or imported smart device list CSV file
|
Item#1 |
Description |
Specifiable values |
Maximum number of bytes#2 |
Imported? |
|---|---|---|---|---|
|
Name |
Name such as an asset management number |
-- |
128 |
Y |
|
OS type |
OS information acquired from the smart device |
0: iOS 1: Android |
1 |
Y |
|
IMEI/MEID |
IMEI/MEID acquired from the smart device |
15 digits |
15 |
N |
|
Phone number |
Phone number of the smart device from which the information is acquired |
Maximum of 20 characters Only numbers can be specified, excluding a hyphen (-). |
20 |
N |
|
Status |
Management status in the product |
0: Unmanaged 1: Managed |
1 |
N |
|
Current security policy |
Name of the security policy applied to the smart device |
-- |
36 |
Y#3 |
|
Current Android policy/iOS profile |
Android policy or iOS profile applied to the smart device |
-- |
36 |
Y#3 |
|
Department |
Department to which the user belongs |
-- |
128 |
Y#4 |
|
Account |
Account of the user |
-- |
128 |
Y#4 |
|
User name |
Name of the user |
-- |
128 |
Y#4 |
|
Last modified date/Time |
Date and time that the information was last modified due to registration of a smart device or import of smart device information |
yyyy/MM/dd hh:mm:ss#5 |
19 |
N |
|
Manufacturer |
Manufacturer name acquired from the smart device |
-- |
256 |
N |
|
Model number |
Model number acquired from the smart device |
-- |
256 |
N |
|
Protocol version |
Protocol version of the product |
-- |
64 |
N |
|
Language |
Language setting acquired from the smart device |
Maximum of 20 characters |
80 |
N |
|
Product name |
Product name acquired from the smart device |
Maximum of 10 characters Android iOS |
40 |
N |
|
Model name |
Model name acquired from the smart device |
-- |
256 |
N |
|
Serial number |
Serial number acquired from the smart device |
-- |
256 |
N |
|
OS version |
OS version acquired from the smart device |
-- |
32 |
N |
|
OEM name |
OEM name acquired from the smart device |
-- |
64 |
N |
|
Firmware version |
Firmware version acquired from the smart device |
-- |
64 |
N |
|
Software version |
Software version acquired from the smart device |
-- |
64 |
N |
|
Mobile network country code |
Mobile network country code acquired from the smart device |
Maximum of 10 characters |
40 |
N |
|
Mobile network operator code |
Mobile network operator code acquired from the smart device |
Maximum of 20 characters |
80 |
N |
|
Mobile network operator name |
Mobile network operator name acquired from the smart device |
Maximum of 20 characters |
80 |
N |
|
Mobile network type |
Mobile network type acquired from the smart device |
Maximum of 20 characters |
80 |
N |
|
SIM card country code |
SIM card country code acquired from the smart device |
Maximum of 10 characters |
40 |
N |
|
SIM card operator code |
SIM card operator code acquired from the smart device |
Maximum of 20 characters |
80 |
N |
|
SIM card operator name |
SIM card operator name acquired from the smart device |
-- |
256 |
N |
|
ICCID |
ICCID acquired from the smart device |
19 digits |
19 |
N |
|
SIM status code |
SIM status code acquired from the smart device |
-- |
64 |
N |
|
IMSI |
IMSI acquired from the smart device |
15 digits |
15 |
N |
|
User name |
User name acquired from the smart device |
Maximum of 20 characters |
80 |
N |
|
Roaming |
Roaming information acquired from the smart device |
0: Normal 1: Roaming |
1 |
N |
|
Android ID/Apple ID |
Android ID or Apple ID acquired from the smart device |
-- |
256 |
N |
|
|
Email address acquired from the smart device |
-- |
256 |
N |
|
Password (set or not set) |
Password (set or not set) acquired from the smart device |
0: Not set 1: Set |
1 |
N |
|
Internal storage (Total / Free [B]) |
Internal storage information acquired from the smart device |
-- |
64 |
N |
|
SD Card (Total / Free [B]) |
SD card information acquired from the smart device |
-- |
64 |
N |
|
RAM (Total / Free [B]) |
RAM information acquired from the smart device |
-- |
64 |
N |
|
Date/Time of Android policy/iOS profile application |
Date and time that the Android policy or iOS profile was applied to the smart device |
yyyy/MM/dd hh:mm:ss#5 |
19 |
N |
|
Android policy/iOS profile version |
Version of the Android policy or iOS profile applied to the smart device |
Maximum of 5 characters |
5 |
N |
|
Date/time of device details update |
Last date and time that the inventory information was collected |
yyyy/MM/dd hh:mm:ss#5 |
19 |
N |
- Legend:
-
Y: Imported
N: Not imported
--: Any value
#1: The first line of the CSV file does not contain item information.
#2: The maximum number of bytes if UTF-8 or UTF-16 is specified for the character encoding. For half-width alphanumeric characters and symbols, one character is counted as one byte. For other characters, one character is counted as four bytes.
#3: If this item is not specified, the smart device is registered as an unmanaged device.
#4: Although this is an optional item, we recommend that you specify a value.
#5: yyyy: year, MM: month, dd: day, hh: hour, mm: minute, ss: second
Related Topics