View with information related to a device
Fields
| Field | Type | Description |
|---|---|---|
| agent_profile | NVARCHAR (510) | Profile of the agent assigned to the device |
| agent_version* | NVARCHAR (30) | Device Agent Version |
| conflict_status | INT | Device conflict status |
| creation_date* | DATETIME | Date of creation of the device in the system |
| days_since_last_inventory | INT | Days since the last device inventory update |
| description | NVARCHAR (512) | Device description |
| disk_usage* | FLOAT | Current device disk usage |
| domain | NVARCHAR (80) | Domain or workgroup to which the device belongs |
| ema | BIT | Indicates if the device is? managed by EMA |
| guid* | NVARCHAR (160) | Unique global identifier (GUID) of the device |
| hardware_hash | NVARCHAR (160) | Device hardware hash |
| id* | INT | Unique device identifier |
| ip_address | NVARCHAR (8000) | Device IP address |
| ip_registred | NVARCHAR (80) | Registered IP address of the device |
| is_persistence | BIT | Indicates whether the device has persistence enabled |
| last_communication_update | DATETIME | Date of last device communication update |
| last_inventory | DATETIME | Date of last update of device inventory |
| manufacturer | NVARCHAR (1024) | Device Manufacturer Name |
| manufacturer_id | INT | Device Manufacturer Identifier |
| min_since_last_communication | INT | Minutes since last device communication update |
| model | NVARCHAR (510) | Device Model |
| motherboard_serial | NVARCHAR (510) | Device Motherboard Serial Number |
| name* | NVARCHAR (80) | Device Name |
| operating_system | NVARCHAR (512) | Device operating system name |
| operating_system_version_id | INT | Device OS Version Identifier |
| responsible_user_email | NVARCHAR (510) | Email from the user responsible for the device |
| responsible_user_id | INT | Identifier of the user responsible for the device |
| responsible_user_name | NVARCHAR (510) | Name of the user responsible for the device |
| serial | NVARCHAR (510) | Device serial number |
| token | NVARCHAR (510) | Device token for identification |
| type* | INT | Device type identifier |
| type_name* | NVARCHAR (128) | Device Type |
| user_name | NVARCHAR (128) | Name of the user registered on the device |
| virtualization* | INT | Device Virtualization Capability |
| vpro* | BIT | Support for device vPro technology |