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

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

book

Article ID: 285528

calendar_today

Updated On:

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';"