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

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

book

Article ID: 289665

calendar_today

Updated On:

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;