Bulk Edit Status / Icon Image?

[rkane]

I'd like to be able to clear the "status image" and "icon image" fields on all my host and service configs. Intention is to apply those via template. I don't see a way to do this through the Bulk Modifications Tool. What's the best way to achieve this?

[ssax]

There is not currently a way to do this outside of running some SQL queries.

NOTE: Please make sure you have an XI backup before running these commands:

https://assets.nagios.com/downloads/nag ... ios-XI.pdf

To remove the icon_image and statusmap_image from ALL of the hosts:

Code: Select all

echo "update tbl_host set icon_image = '', statusmap_image='';" | mysql -uroot -pnagiosxi nagiosql

To remove the icon_image from ALL of the services (services don't have a statusmap_image):

Code: Select all

echo "update tbl_service set icon_image = '';" | mysql -uroot -pnagiosxi nagiosql

Then Apply Configuration.