Relation to tbl_host, entry - deletion not possible

[jbennett]

I am trying to delete a user that is no longer with the company. In doing so, I am being presented with 6 lines as the following:

Relation to tbl_host, entry - deletion not possible

There is no host listed here, so I cannot remove the user from those hosts.

What are my options? Any help would be greatly appreciated!

[scottwilkerson]

Try the following to find the hosts this user may be contacts for

Code: Select all

cd /usr/local/nagios/etc
grep -lir "USERNAME" *

[jbennett]

Looking at the results, I'm assuming that I must remove this individuals from ALL hosts & services, not just the ones that don't list an actual host?

There has to be an easier way of mass removing them from our list of thousands of hosts, right?

[jbennett]

This shows me the rest of the list as well I'm sure. I was hoping to just be able to find the 6 hosts where it stated that deletion wasn't possible.

We have thousands of hosts. Surely there's a way to more easily remove this contact from the hosts and services than going to each item on this list individually? I have checked the templates, and unfortunately, in the template for the hosts and services, this individual is not selected under the contacts. Is there somewhere else that this can be done?

[mguthrie]

Do you have any blank entries on your hosts page by chance? The only time I've seen something like this is when an import is done and some ghost relationships get created. They show up as empty hosts on the hosts page.

I'm going to attach our new CCM beta, it installs alongside the existing CCM through the Admin->Manage Components page. It might make things a little more intuitive as to where the relationships are. You can also use the "Bulk Modifications" page to remove a contact from a list of directly related hosts or services.

[jbennett]

No blank entries that I can see. I'm assuming you mean it will just be blank all the way across the listing, yet have a check box next to it? I'm also assuming it would be at either the beginning or the end of the host list, and not in the middle of the 144 pages somewhere?

We are currently on Nagios 1.9. I will have to see if we can upgrade to 2.1 from here since they have everything locked down.

[scottwilkerson]

The Beta CCM that mguthrie posted is your ticket to removing the contact from all in in the easiest way possible

[jbennett]

Thanks, since it says that it will only work with 2.1 or later, I suppose I need to get onto upgrading our system then!

[jbennett]

I'm going to attach our new CCM beta, it installs alongside the existing CCM through the Admin->Manage Components page. It might make things a little more intuitive as to where the relationships are. You can also use the "Bulk Modifications" page to remove a contact from a list of directly related hosts or services.

Now that i'm up to date, I am looking at the info for this contact and it still only shows:

Code: Select all

Relation to tbl_host, entry - deletion not possible
Relation to tbl_host, entry - deletion not possible

Perhaps I'm not seeing it, but where do I access the bulk modifications page from?

Many thanks!

EDIT: Found it and successfully got the contact deleted!! Now to see if I can finally apply the new configuration.

Again, many many thanks!

[pouda]

Hi,

where is this Bulk modifications Option ?