App Control: How pull a report of all computers in the SQL database

Products

• Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

How pull a report of all computers in the SQL database, both active and deleted?

Environment

App Control: All versions

Resolution

Please run the following query against the database:

use DAS
select a.host_id,a.deleted,a.hostname,a.register_date,b.last_poll_date as Last_Checkin_date from dbo.hostmain a, dbo.host_state b where a.host_id=b.host_id;