How to safely query the DAS database with Public Views
book
Article ID: 290684
calendar_today
Updated On:
Products
Carbon Black App Control (formerly Cb Protection)
Issue/Introduction
This document explains the public views built in to the DAS database that can be safely queried without the worry of locking the live DAS database.
Environment
App Control Server: All Supported Versions
Microsoft SQL Server: All Supported Versions
Resolution
1. Open SQL Server Management Studio and connect to the database. 2. In the Object Explorer pane, expand Databases > das > Views 3. The public views begin with the prefix "bit9_public". Ex:
bit9_public.ExApprovalRequests
bit9_public.ExComputers
bit9_public.ExDeletedFileInstances
bit9_public.ExEvents
bit9_public.ExFileCatalog
bit9_public.ExFileInstanceGroups
bit9_public.ExFileInstances
bit9_public.ExInfo
bit9_public.ExMeters
Additional Information
A sample query will look like:
use das
select Computer, Policy, Policy_Status from bit9_public.ExComputers