Technical Tip: Exporting Users from CMDB to CSV with Custom Column Names

As of now, exporting users directly from the FortiSIEM GUI is not supported. However, this can be accomplished via the Supervisor CLI by querying the PostgreSQL database (ph_user table).

Steps:

1. Export All Users with Default Column Names:

psql -U phoenix phoenixdb -c "SELECT * FROM ph_user;" --csv > /tmp/ph_user.csv

2. Export with Custom, User-Friendly Column Names:

    

psql -U phoenix -d phoenixdb -c "SELECT id AS \"User ID\", description AS \"Description\", name AS \"User Name\", rbac_profile_name AS \"FortiSIEM Role\" FROM ph_user;" --csv > ph_user_custom_filename.csv

Formatting Notes:

To rename database columns in the output, use the following format:

original_database_column AS \"Custom Display Name\"

To identify which database fields map to GUI display labels, cross-reference the CSV exported from the first command.

For example:

rbac_profile_name in the database corresponds to the FortiSIEM Role in the GUI.