Page 1 of 1

export user list

Posted: Mon Sep 14, 2015 9:24 am
by 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

Re: export user list

Posted: Mon Sep 14, 2015 9:48 am
by 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

Re: export user list

Posted: Mon Sep 14, 2015 9:51 am
by BanditBBS
jdalrymple wrote:

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