SQL query to display all the servers monitored except Windows in Applications Manager

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:
  1. Open SQL Management Studio.
  2. Connect to the Applications Manager database.
  3. 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.