Device Overview
Fields
| Field | Type | Description |
|---|---|---|
| agent_profile | NVARCHAR (510) | Profile of the nvarchar type agent |
| agent_version* | NVARCHAR (30) | Agent Version Installed on the nvarchar Device |
| communication_address | NVARCHAR (80) | IP of the device with which it communicates with the nvarchar conserver |
| conserver | NVARCHAR (500) | Url of the Server with which it communicates of type nvarchar |
| creation_date* | DATETIME | Date of the agent’s first communication with the datetime server |
| days_since_last_inventory | INT | Days elapsed without carrying out an entire inventory |
| description | NVARCHAR (512) | Device description |
| device_id* | INT | Primary Key Device Code |
| device_name* | NVARCHAR (80) | Device Name |
| device_type | VARCHAR (7) | Define the device type (Unknown, Desktop, Laptop, Server, Printer, Switch, Router) |
| device_user_name | NVARCHAR (128) | Username of the nvarchar device |
| domain | NVARCHAR (80) | Domain to which the device belongs |
| is_active | VARCHAR (2) | Determines if the device is ? Active or non-varchar type |
| is_discovery | VARCHAR (2) | Does it establish if the device was discovered or if the agent was installed? Manually varchar type |
| last_communication_update | DATETIME | Time and date of the agent’s last communication with the datetime server |
| last_inventory | DATETIME | Date and time of the last generated inventory of type datetime |
| manufacturer | NVARCHAR (1024) | Manufacturer of the nvarchar type device |
| min_since_last_communication | INT | Minutes since last integer communication |
| model | NVARCHAR (510) | Model of the nvarchar type device |
| operating_system | NVARCHAR (512) | Operating system of the nvarchar type device |
| operating_system_version | NVARCHAR (510) | Version of the operating system of type nvarchar |
| platform | VARCHAR (7) | Varchar Type Device Platform |
| responsible_user_email | NVARCHAR (510) | Mail from the user responsible for the nvarchar device |
| responsible_user_name | NVARCHAR (510) | User responsible for the nvarchar type device |
| serial | NVARCHAR (510) | Serial of the nvarchar type device |