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.
Now execute the below queries one by one and share the query result to appmanager-support@manageengine.com
- 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?
Related Articles
Troubleshoot - Duplicate APMInsight Monitors
Introduction: Duplicate monitors might be created in APMInsight due to various reasons. This article will help you identify and resolve the issue of duplicate monitors. The common causes include: - Changes in monitor configuration. (apminsight.conf ...How to perform migration to fix "ID out of allocated range" issue or unable to add managed server into admin server due to "server id does not match" error in Applications Manager
If the id value used internally for the monitors crosses the server id value specified in Settings -> Support -> Installation Information -> Server Id - Managed server, then you will get the following alert in Admin server: For existing Managed ...Unable to add Exchange Server monitor
Check whether all the prerequisites are done. The prerequisites can be found here: https://www.manageengine.com/products/applications_manager/help/prerequisites-for-applications-manager.html#ExchangeServer WMI Mode If unable to add the Exchange ...Unable to Add Kubernetes Monitor
If you are having trouble adding a Kubernetes monitor in Applications Manager, ensure that the the prerequisites have been met: Verify whether you can establish an SSH connection to the Kubernetes server from the APM installed machine. Use the ...Unable to add MS Office SharePoint monitor
Check if all the prerequisites are done. The prerequisites can be found here: https://www.manageengine.com/products/applications_manager/help/prerequisites-for-applications-manager.html#SharePointServer WMI Mode If unable to add the SharePoint ...