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.

Table 1. ExComputers View Details

Field Name

Data Type

Special Values

Comments

Computer_Id

int

 

Primary key

Audit_Date

nvarchar

 

Date and time when Computer Information was collected

Computer_Information

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

Platform

varchar

Windows, Mac, Linux

 

Memory_Size

int

 

Size (megabytes) of installed memory on this computer

Processor_Count

int

 

Number of processors on this computer

Processor_Speed

float

 

Speed of computer processor in MHz

IP_Address

varchar

 

Last recorded IP address of this computer. This can be either an IPv4 or IPv6 address.

Connected

varchar

Yes, No

Yes if agent on this computer is connected to the App ControlCarbon Black App Control Server

Days_Offline

int

 

Number of days this computer has been offline

Computer_Uninstalled

varchar

Yes, No

Yes if agent has been uninstalled from this computer

Computer_Deleted

varchar

Yes, No

Yes if computer has been deleted from the Computers list in the Carbon Black App Control Server

Date_Created

datetime

 

Date and time this computer first connected to the Carbon Black App Control Server

Policy_Mode

varchar

Control, Visibility, Agent Disabled

Mode of the policy this computer belongs to

Agent_Version

varchar

 

Version of the agent installed on this computer

Poll_Date

varchar

 

Date and time this computer last connected to the Carbon Black App Control Server

Policy_Assignment

varchar

‘Manual’, ‘Automatic’

How policy is assigned to this agent (automatic means it was assigned by Active Directory mapping)

Upgrade_Status

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.

Policy_Status

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.

Computer

nvarchar

 

Name of this computer

Users

nvarchar

 

Comma-separated list of users that have ever logged on to this computer

Enforcement_Level

nvarchar

High (Block Unapproved), Medium (Prompt Unapproved), Low (Monitor Unapproved), None (Visibility), None (Disabled)

Enforcement Level used when this computer is online

Disconnected_Level

 

nvarchar

High (Block Unapproved), Medium (Prompt Unapproved), Low (Monitor Unapproved), None (Visibility), None (Disabled)

Enforcement Level used when this computer is offline

Computer_Tag

nvarchar

 

Optional custom tag assigned to this computer

OS_Short_Name

nvarchar

 

Short name of this computer’s OS

OS_Long_Name

nvarchar

 

Long name of this computer’s OS

Policy

nvarchar

 

Name of the last policy for this agent

Policy_Description

nvarchar

 

Description of the last policy this agent has joined

Machine_Model

nvarchar

 

Machine model of this computer

Processor_Model

nvarchar

 

Processor model of this computer

Upgrade_Error

nvarchar

 

Agent upgrade error (if any)

Synch_Percent

int

 

Progress of synchronization of this computer with the App Control Server (percent)

Template

varchar

Yes, No

Yes if computer is a template. No if it is not (includes clones and non-cloned computers).

Template_Computer_Id

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.

Virtualized

varchar

‘Yes’,’No’

Yes if computer is a virtual machine. No if it is not.

Virtual_Platform

varchar

 

If Virtualized is Yes, the platform of the virtual machine. Currently, this is either VMware, Unknown, or blank.