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

[#1]

Environment

• CB Response: All Versions

Objective

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.

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