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;