ExComputers

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.