The ExComputers view provides access to the metadata of all computers running the Carbon Black App ControlAgent at your site.
To see a list of this data for all computers in the console, click Assets > Computers on the console menu. To see this data for a single computer, click on the name of a computer on the Computers page.
Field Name |
Data Type |
Special Values |
Comments |
---|---|---|---|
|
int |
|
Primary key |
|
nvarchar |
|
Date and time when Computer Information was collected |
|
XML |
|
A meta-field containing data (in XML format) about the computer including number of drives and free space on each; number, model and speed of processors; total system RAM |
|
varchar |
Windows, Mac, Linux |
|
|
int |
|
Size (megabytes) of installed memory on this computer |
|
int |
|
Number of processors on this computer |
|
float |
|
Speed of computer processor in MHz |
|
varchar |
|
Last recorded IP address of this computer. This can be either an IPv4 or IPv6 address. |
|
varchar |
Yes, No |
Yes if agent on this computer is connected to the App ControlCarbon Black App Control Server |
|
int |
|
Number of days this computer has been offline |
|
varchar |
Yes, No |
Yes if agent has been uninstalled from this computer |
|
varchar |
Yes, No |
Yes if computer has been deleted from the Computers list in the Carbon Black App Control Server |
|
datetime |
|
Date and time this computer first connected to the Carbon Black App Control Server |
|
varchar |
Control, Visibility, Agent Disabled |
Mode of the policy this computer belongs to |
|
varchar |
|
Version of the agent installed on this computer |
|
varchar |
|
Date and time this computer last connected to the Carbon Black App Control Server |
|
varchar |
‘Manual’, ‘Automatic’ |
How policy is assigned to this agent (automatic means it was assigned by Active Directory mapping) |
|
varchar |
Up to date, Completed, Not supported, Scheduled, Waiting, Not requested, Agent uninstalled, Reboot required, Blocked, Upgrade requested, Unknown |
Current upgrade status of this agent Change Note: ‘Upgrade requested was added in 7.0.0. |
|
varchar |
Policy out of date, Approvals out of date, Enforcement Level out of date, Out of date, Up to date |
Current policy status of this computer Change Note: Value Enforcement Level out of date was SecCon out of date in 6.0.2. |
|
nvarchar |
|
Name of this computer |
|
nvarchar |
|
Comma-separated list of users that have ever logged on to this computer |
|
nvarchar |
High (Block Unapproved), Medium (Prompt Unapproved), Low (Monitor Unapproved), None (Visibility), None (Disabled) |
Enforcement Level used when this computer is online |
|
nvarchar |
High (Block Unapproved), Medium (Prompt Unapproved), Low (Monitor Unapproved), None (Visibility), None (Disabled) |
Enforcement Level used when this computer is offline |
|
nvarchar |
|
Optional custom tag assigned to this computer |
|
nvarchar |
|
Short name of this computer’s OS |
|
nvarchar |
|
Long name of this computer’s OS |
|
nvarchar |
|
Name of the last policy for this agent |
|
nvarchar |
|
Description of the last policy this agent has joined |
|
nvarchar |
|
Machine model of this computer |
|
nvarchar |
|
Processor model of this computer |
|
nvarchar |
|
Agent upgrade error (if any) |
|
int |
|
Progress of synchronization of this computer with the App Control Server (percent) |
|
varchar |
Yes, No |
Yes if computer is a template. No if it is not (includes clones and non-cloned computers). |
|
int |
|
The ID of the parent template computer. If the value is 0, the computer does not have a template parent and is not a clone. If the value is non-zero, the computer is a clone. |
|
varchar |
‘Yes’,’No’ |
Yes if computer is a virtual machine. No if it is not. |
|
varchar |
|
If Virtualized is Yes, the platform of the virtual machine. Currently, this is either VMware, Unknown, or blank. |