CB Response: How to Export all Isolated Sensors to CSV

By CB_Support posted Apr 09, 2019 11:04 PM

Recommend

Environment

CB Response 6.2 and Higher
RHEL/CENTOS: All Supported Versions

Objective

Export all isolated hosts to csv

Resolution

While logged in as the root user run the following command

psql -d cb -p 5002 -c "select id,computer_name,network_isolation_enabled,build_id from sensor_registrations where network_isolation_enabled='t';" >> /tmp/NAME.csv

Additional Notes

See this idea to add additional CB Response Sensor filters to the Console
CbR Sensors - Add more column search filters by Status, OS, etc.

Blog Viewer