Environment
- EDR Server: 7.x and Higher
Objective
- How does an administrator identify a username from just a userid number?
Resolution
A. Login to the EDR Primary server and run:
sudo psql -p 5002 cb -c "select id, username, firstname, lastname from cb_user;"
B. Alternately, once on the EDR Primary server connect to the psql database.
- Connect to psql database:
sudo psql -d cb -p 5002
- List the cb database schema tables.
cb# d\
- List all columns in the cb_user table.
cb# \d cb_user
- List in a table format, the username and user id.
cb# select id, username, firstname, lastname from cb_user;
- Log out.
cb# \q
Additional Notes
- Warning: It is not advised to modify the Postgres table without CarbonBlack Customer Support assistance due to the multiple indexes that could be affected.
Related Content