How to safely query the DAS database with Public Views

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