CSV report of all configured alerts?

[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

[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

[GhostRider2110]

Thanks Scott, I will see what I can do with that...

Mitch

[scottwilkerson]

Thanks Scott, I will see what I can do with that...

Mitch

Sounds good,

Locking thread