Table Storing ADM Devices
Data model
Fields
| Field |
Type |
Description |
| alias |
NVARCHAR (100) |
Text-type secondary name for the device |
| auto_setted_user* |
BIT |
Flag to indicate if the user was automatically set |
| created_date* |
DATETIME |
Date of registration or creation of the device in ADM |
| description |
NVARCHAR (512) |
Additional information about the device |
| domain |
NVARCHAR (80) |
Domain to which the device belongs |
| guid* |
NVARCHAR (160) |
Unique identifier generated for the device |
| hardware_hash |
NVARCHAR (160) |
Hash generated by the agent at the time of device registration |
| id* |
INT |
Integer Type Primary Key |
| is_active* |
BIT |
Flag to indicate if active |
| is_discovery* |
BIT |
Flag to indicate if it was discovered |
| modification_date* |
DATETIME |
Device Modification Date |
| name* |
NVARCHAR (80) |
Device name assigned by the operating system |
| server |
NVARCHAR (100) |
Server |
| token |
NVARCHAR (510) |
Token corresponding to the guid for device requests |
| type* |
INT |
Device type, e.g., server, desktop, laptop, etc |
| username |
NVARCHAR (128) |
Username of the operating system with which the device is associated |
| workgroup |
NVARCHAR (80) |
Device group to which the device belongs |
Primary Key
References
