Environment
- Cb Response Console: All Versions
Question
Where can I get the information of sensor version in the database?
Answer
- 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;"
- 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 Notes
- The 'sensor_registrations' table in PSQL also has the information about the status of the endpoints (uninstalled, check-in times, etc)
Related Content