Unable to add hosts due to stray entries in tables ( for Server Monitors)
Navigate to Settings -> Tools -> Support -> Database Summary to access the query tool.
![](https://pitstop.manageengine.com/galleryDocuments/edbsnccc7ed23f9f0d37dc984cf35ce06afba58039758fa93d6b846202bc646ecb9c0d55c14a9c12d84490bec2138d4af335e?inline=true)
Now execute the below queries one by one and share the query result to appmanager-support@manageengine.com
![](https://img.zohostatic.com/zde/static/images/info.png)
- select * from Node where NAME like '%Host_Name%' or NAME like '%IP_Address%' ;
- select * from IpAddress where NAME like '%Host_Name%' or NAME like '%IP_Address%';
- select * from ManagedObject where NAME like '%Host_Name%' or NAME like '%IP_Address%';
- select * from TopoObject where NAME like '%Host_Name%' or NAME like '%IP_Address%' ;
- select * from CollectData where RESOURCENAME like '%Host_Name%' or RESOURCENAME like '%IP_Address%';
- select * from HostDetails where RESOURCENAME like '%Host_Name%' or RESOURCENAME like '%IP_Address%' ;
- select * from InetService where TARGETNAME like '%Host_Name%' or TARGETNAME like '%IP_Address%';
- select * from AM_ManagedObject where RESOURCENAME like '%Host_Name%' or RESOURCENAME like '%IP_Address%' ;
Note: Replace the Host_Name and IP_Address with actual value of the monitor your trying to add without replacing the '%' symbol in the query.
New to ADSelfService Plus?