How to clean up host objects displayed as 'n/a' under Hosts dashboard (4327505)

How to clean up host objects displayed as 'n/a' under Hosts dashboard

Under hosts dashboard, one hosts shows ‘n/a’ but  the other host with same name has data.

WORKAROUND:

Run attached groovy script to delete the hosts that shows 'n/a':

Go to Dashboards | Administration | Tooling | Script console
Select tab Scripts
Click Add
Copy & Paste the attached groovy script for Enter Script Text area on the pop-up window.
Click Run

The script output message will look like:
'x' Objs[type:Host] been deleted!Done!