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