Nagios Support Forum

When looking under info of my hosts created with the Windows Server Config wizard, I noticed the following information:

Relational information for server of table tbl_host:
Relation to tbl_service, entry server-Ping - deletion not possible
Relation to tbl_service, entry server-CPU Usage - deletion not possible
Relation to tbl_service, entry server-Memory Usage - deletion not possible
Relation to tbl_service, entry server-Uptime - deletion not possible
Relation to tbl_service, entry server-Drive C: Disk Usage - deletion not possible
Relation to tbl_service, entry server-Page File Usage - deletion not possible
Relation to tbl_service, entry server-Logon Errors - deletion not possible
Relation to tbl_service, entry server-Available Memory - deletion not possible
Relation to tbl_service, entry server-Processor Time - deletion not possible

I know these are referencing the services created during the config wizard.

My questions:

1) Why are they not possible to delete?

2) Is there a way to manually delete them from the database? If so, how?

The message you're seeing are generated by NagiosQL, and they're basically just saying that these hosts currently have dependent services in the database. If you need to delete hosts, you first need to delete all of it's services, then you should be able to delete the host. The idea is that it's supposed to be a failsafe so that someone doesn't accidentally delete a ton of services by deleting a host.

We've got documentation that's almost finished that talks in detail about host management, I'm hoping to have it out in the next couple of days actually.

To delete a host:
Go to Core Config Manager->Services-> then use the filter to search by host.
Select all items for that host, and select "delete" from the "With Checked" dropdown.
Now you can delete that host from the hosts management page.

Cool, thanks so much! I did have one more question. Nagios XI seems to be the core Nagios product implemented with NagiosQL and a few other either customizations or add-ons. What are some other elements that Nagios XI incorporates?

Nagios XI is still based on Nagios Core, but the idea behind is XI is to broaden the spectrum of who can use it. Nagios Core is geared towards a more technical user that doesn't mind diving in and manually editing config files and using command-line, etc. Nagios XI handles those configurations for you but still allows for more advanced/manual configurations as well. It allows users to do just about anything they need through the user interface, including installing components, addons, creating templates for contact groups, hosts, services, etc. The idea behind this is flexibility in who can utilize the software. Custom Views and Dashboards are another key feature that can be created for each user. I'm sure there's more that I'm missing, but hopefully that gives an idea.