The following table shows the views available in the bit9_public schema.
Detail about the data in each view is shown in subsequent tables in Database View Details. The full schema diagram for the bit9_public schema is shown in Schema Diagram for bit9_public.
| View Name |
Description |
Primary Key |
Foreign Keys |
|---|---|---|---|
| ExInfo |
Public properties of servers and schema in the Carbon Black App Control Server environment |
Property_Id |
(None) |
| ExEvents |
All events shown on the Events page |
Event_Id |
File_Catalog_Id, Root_File_Catalog_Id, Computer_Id |
| ExMeters |
All executions of metered files |
Event_Id |
Computer_Id, File_Catalog_Id |
| ExComputers |
Metadata of all computers |
Computer_Id |
(None) |
| ExFileCatalog |
Metadata for all unique hashes |
File_Catalog_Id |
(None) |
| ExFileInstances |
Metadata of all file instances on all computers |
File_Instance_Id |
File_Instance_Group_Id, Computer_Id, File_Catalog_Id |
| ExDeletedFileInstances |
Metadata of all deleted file instances |
Deleted_File_Instance_Id |
File_Instance_Group_Id, Computer_Id, File_Catalog_Id |
| ExFileInstanceGroups |
Metadata of all file instance groups |
File_Instance_Group_Id |
Computer_Id, File_Catalog_Id |
| ExApprovalRequests |
All approval requests shown on the Approval Requests page |
Approval_Request_Id |
File_Catalog_Id, Process_File_Catalog_Id, Root_File_Catalog_Id, Computer_Id |
