down hosts clean up

[exp-user1]

Hi,

I have more than 200 hosts appear only on GUI as down since about 80 days.
is there a way to clean them up?

thanks.

[gsmith]

Hi

Please try: Configure, Core Config Manager:

Image25.jpg

Click on the blue Hosts box:

Image26.jpg

Do you see the hosts you want to remove there? If so click the red X under
actions. WARNING: This will remove them and their related items (services)
entirely and permanently.

If you don't see the hosts there then please provide a system profile:

To send us your system profile.
1. Login to the Nagios XI GUI using a web browser.
2. Click the "Admin" > "System Profile" Menu
3. Click the "Download Profile" button
4. Save the profile.zip file and share this in a private message and then reply to this post to bring it up in the queue.

Thanks

[exp-user1]

Hi gsmith,
system profile has been uploaded.

thanks for your prompt feedback.

[gsmith]

Hi,

I see 90 hosts and 295 hostgroups when I look at the Core Configuration Manager.

Does that sound like what you are expecting to see?

Thanks

[exp-user1]

Hi,

The home page shows 211 down hosts. but when searching for their IPs, I find no thing.
how can I clean up those down hosts?

[gsmith]

Hi,

On the Nagios XI server please do the following:

Code: Select all

mysql -u root -pnagiosxi nagios
select count(*) from nagios_hosts;
select count(*) from nagios_hosts
where display_name like '';

And let me know what the results are for the two select count(*) commands.

In the second command this: '';
is <single-quote><single-quote><semi-colon>

Thanks

[exp-user1]

Hi,

attached is the commands output.
thanks.

[gsmith]

Hi

Go to the Core Config Manager
Tools > Config File Management
Click on Write Configs and Verify Files to check for config errors
If you don't have any errors, click on Delete to remove all host and service configuration files.
Next, apply configuration. The configs will be recreated with whatever is in the database.

Let me know if that solves it.

Thanks

[exp-user1]

Hi,

No changes, the same list of down hosts.

[gsmith]

Hi

Please send me a System Backup:

Go to the Admin page, pick "Local Backup Archives" from the left-hand menu under 'System Backups' and then hit
the "Create Backup" button.

Image7.jpg

Thank you