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
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 ...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 ...Basic WMI connection check when unable to add monitor
Follow the below steps to check the WMI connection when unable to add the monitor in WMI mode. Supported monitors: Active Directory, Microsoft Dynamics CRM / 356 On Prem, Microsoft Dynamics AX, Microsoft Skype for Business, Network Policy Server, ...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 ...No Data in SAP Server monitor/ Unable to add SAP monitor
Problem: In Appmanager_home/logs/nms/stdout.txt , the error message "SAPDataCollector : Host information not found for server" is found. Solution: Add entry for IP Address and SAP Instance name in etc/hosts file of Applications Manager server and ...