CB Response: How to Export all Isolated Sensors to CSV

Products

• Carbon Black EDR (formerly Cb Response)

Issue/Introduction

Export all isolated hosts to csv

Environment

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

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 Information

See this idea to add additional CB Response Sensor filters to the Console
https://community.carbonblack.com/t5/Idea-Central/CbR-Sensors-Add-more-column-search-filters-by-Status-OS-etc/idi-p/63444