How to safely query the DAS database with Public Views
search cancel

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