SQL query to display all the servers monitored except Windows in Applications Manager
To obtain the list of all the servers monitored other than Windows, follow the steps given below:
- Open SQL Management Studio.
- Connect to the Applications Manager database.
- Execute the below query in Admin or Managed server:
SELECT RESOURCEID,RESOURCENAME,DISPLAYNAME,TYPE FROM AM_ManagedObject WHERE TYPE IN ('Linux','Novell','SUN','SUN PC','Sun Solaris','AIX','AS400/iSeries','HP-UX','HP-TRU64','HP-UX / Tru64','FreeBSD','OpenBSD','FreeBSD / OpenBSD','Mac OS');
This will display the list of all the servers monitored in Applications Manager, except Windows server.
Note: The above-mentioned query will display only unique values. New to ADSelfService Plus?
Related Articles
Applications Manager Database Migration Using SQL Dump
Step 1: Rename Directories Skip this step if the directories are already renamed. Rename <AppManager_home>/working/pgsql to <AppManager_home>/working/pgsql_11. Rename <AppManager_home>/working/pgsql_15.5 to <AppManager_home>/working/pgsql. Step 1.1: ...Enabling gMSA Account Authentication for SQL Server In Applications Manager
Using a gMSA Account for Applications Manager's SQL Server Backend Important prerequisites before starting the installation: A gMSA account can only be used when Applications Manager is running as a service on Windows platform. To use gMSA account ...Using Kerberos Authentication with ManageEngine Applications Manager for Windows Monitoring
What is Kerberos? Kerberos is a secure authentication protocol used in Active Directory (AD) domains. It uses encrypted "tickets" instead of passwords to allow ManageEngine Applications Manager to connect to a target server securely. When a server is ...Enabling Kerberos Authentication for SQL Server in Applications Manager
I. How to implement Kerberos Authentication for Applications Manager's MS SQL Back-End Database? 1. Stop Applications Manager service. Open Applications Manager's home directory in the command prompt and run the below commands one by one: For Windows ...Maintenance of Applications Manager backend database
Note: Please take complete database backup without fail prior to these steps. I. Applications Manager with PostgreSQL Database. Shutdown all Applications Manager related process as follows: For windows: Open services.msc --> stop ManageEngine ...