export user list

[BanditBBS]

I know I've asked this before, but I just can't find the forum post

I need to export the list of users in XI for SOC audit. I'm going to go put in a feature request to get a button added to manage users screen, but in the meantime, someone want to help me out with the postgresql command(s)

Edit: Issue #758 created

[jdalrymple]

Code: Select all

psql -U nagiosxi -d nagiosxi -c 'select username, name, email, enabled from xi_users'

If it asks for a password, find it in /usr/local/nagiosxi/html/config.inc.php

[BanditBBS]

Code: Select all

psql -U nagiosxi -d nagiosxi -c 'select username, name, email, enabled from xi_users'

If it asks for a password, find it in /usr/local/nagiosxi/html/config.inc.php

I actually knew where to find the password But it didn't prompt...thanks for the command, feel free to close this up