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
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 ...How to enable Kerberos Authentication for Applications Manager's MS SQL backend database?
Follow the steps given below to enable Kerberos authentication for MS SQL backend database: 1. Stop Applications Manager service. Open Applications Manager Home directory in command prompt and run the below commands one by one. For ...Applications Manager default tomcat is down
If your Tomcat Monitor is down, it could probably be due to changes in Hostname/IP address of the machine in which Applications Manager is installed. You can verify the same using the steps given below: Navigate to ...How do I migrate the MS SQL DB used by Applications Manager to another MS SQL server?
Follow the steps given below to migrate MS SQL database of Applications Manager to another MS SQL server: 1. Shutdown Applications Manager completely before the database migration. a. Stop Applications Manager service. b. Shutdown Applications ...