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: ...Integrating Applications Manager backend Microsoft SQL database with Power BI Desktop
Overview This KB provides step-by-step instructions to connect Power BI Desktop to your Applications Manager's Microsoft SQL backend database, enabling you to create custom reports and dashboards using Applications Manager's performance metrics and ...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
Kerberos Authentication Setup for MS SQL Monitor Applications Manager Configuration Guide Table of Contents Step 1: Register & Verify the SPN Step 2: Generate & Verify the Keytab File Step 3: Configure the login.conf File Step 4: Configure ...Enabling Kerberos Authentication for Applications Manager's MS SQL Backend Database
Follow the steps given below to enable Kerberos authentication for the MS SQL backend database: 1. Stop the Applications Manager service. Open the Applications Manager Home directory in the command prompt and run the commands below one by one. For ...