Page 1 of 1
Location of Dashboard Definitions
Posted: Thu Nov 15, 2018 3:32 pm
by awilson
Hi. Is there a way to identify all of the defined dashboards on a system?
Thanks!
Re: Location of Dashboard Definitions
Posted: Thu Nov 15, 2018 3:50 pm
by npolovenko
@awilson, Not quite sure if I understand what you mean by dashboard definitions. Are you looking to get the names of all dashboards in the XI?
I found this query to look up dashboards in MYSQL:
echo "select * from xi_usermeta where keyname = 'dashboards' \G;" | mysql -uroot -pnagiosxi nagiosxi
Re: Location of Dashboard Definitions
Posted: Thu Nov 15, 2018 3:53 pm
by awilson
I'm pretty sure that is what I need. We still have PostgreSQL and MySQL. I'll check if the nagiosxi database is in PostgreSQL.
Thanks!
Re: Location of Dashboard Definitions
Posted: Thu Nov 15, 2018 4:24 pm
by npolovenko
@awilson, You're welcome. Here's the psql version of the command:
echo "select * from xi_usermeta where keyname = 'dashboards' \G;" | psql nagiosxi nagiosxi
Re: Location of Dashboard Definitions
Posted: Thu Nov 15, 2018 4:51 pm
by awilson
We can close this. Thanks!