Page 1 of 1
CSV report of all configured alerts?
Posted: Thu Nov 07, 2019 8:30 am
by GhostRider2110
Is there a way to produce a report that would have, for all systems, by system each alert that is configured for that system? Mgmt wants something like that....
Thanks
Mitch
Re: CSV report of all configured alerts?
Posted: Thu Nov 07, 2019 9:49 am
by scottwilkerson
You can get it in JSON through the API, Help -> Objects Reference
objects/host
objects/service
You could also pull it out of the database with something like this:
Code: Select all
echo "select name1 as host, name2 as service from nagios_objects where is_active=1 and objecttype_id IN (1,2) order by host,service;"|mysql -pnagiosxi nagios
Re: CSV report of all configured alerts?
Posted: Thu Nov 07, 2019 10:12 am
by GhostRider2110
Thanks Scott, I will see what I can do with that...
Mitch
Re: CSV report of all configured alerts?
Posted: Thu Nov 07, 2019 10:25 am
by scottwilkerson
GhostRider2110 wrote:Thanks Scott, I will see what I can do with that...
Mitch
Sounds good,
Locking thread