CB Response: How to get the current sensor count directly from the database using a query

Products

• Carbon Black EDR (formerly Cb Response)

Issue/Introduction

How to get the current sensor count directly from the database using a query. This is mainly required if you want to forward this information to an SIEM.

Environment

• CB Response: All Versions

Resolution

Run the below query on CB Response Server's CLI for getting the current sensor count output.

psql -d cb -p 5002 -c "select count (*) from sensor_registrations where last_checkin_time > now() - interval '1 day';"