Cb Response: Where can I get the information of sensor version in the database?

Products

• Carbon Black EDR (formerly Cb Response)

Issue/Introduction

Where can I get the information of sensor version in the database? 

Environment

• Cb Response Console: All Versions

Resolution

1. The 'sensors_registrations' table has a BUILD_ID column that shows the version build number: 

psql -d cb -p 5002 -c "select count(build_id) as count,build_id from sensor_registrations group by build_id order by count desc;"

2. Then, correlate the build ID's with the version numbers from the sensor_builds table: 

psql -d cb -p 5002 -c "select * from sensor_builds;"

Additional Information

• The 'sensor_registrations' table in PSQL also has the information about the status of the endpoints (uninstalled, check-in times, etc)