Enabling data collection for Cluster Details in MS SQL Monitor

Enabling data collection for Cluster Details in MS SQL Monitor

If you have installed Applications Manager in Linux, Cluster Tab details won't be available.
Domain Administrator account (with privileges to execute WMI queries) is required for cluster monitoring.
To view cluster details, you must have provided Windows authentication credentials or must have added a Windows Monitor.
If you have done both, and data is still not getting populated, follow the steps given below:

1. Run the script:
From the Applications Manager server, navigate to <AppManager_Home>\working\conf\application\scripts\ in a command prompt and run the script wincluster.vbs
Usage: cscript wincluster.vbs <ClusterName> <UserName> <Password> 0
For Example: cscript wincluster.vbs servcluster1 domain\admin admin 0
2. Check the result of the script:
  1. If the cscript returns data but isn't being dispalyed in the UI, send the following files to the APM Support team:

    1. Screenshot of Edit monitor page and Cluster Details Page
    2. SIF files
    3. Share the csript result
  1. If the cscript returns the below result in the command prompt, or if the logs contain errors, follow the steps that follow:
Copyright (C) Microsoft Corporation. All rights are reserved.
Error # Access is denied.
  1. From your AppManager machine, run the Wbemtest and connect to the Cluster using the namespace root\mscluster with the added credential and check if Wbemtest is successful.
  2. For remote connection, replace root\mscluster with \\clusterIP or hostName\root\mscluster and check the Wbemtest connectivity.
  3. Verify if the the user has the WMI privileges to access the data.
  4. Once Wbemtest is connected, click on the Query tab and execute the following wmi query in wbemtest and check whether you retrieve the data:
    select * from MSCluster_Resource
Note : Make sure via wbemtest if the namespace "root\mscluster" is accessible & all permissions are provided.
If proper permission is not provided then the Cluster Details tab will display no data.
If you're still unable to see data in the UI, kindly refer this link.


                New to ADManager Plus?

                  New to ADSelfService Plus?

                    • Related Articles

                    • Real User Monitor (RUM) - Troubleshooting

                      If the monitor has not polled data for a long time, follow the steps below for troubleshooting: Step 1: Check prerequisites to be done Real User Monitor requires the RUM Agent to be installed and mapped to the Applications Manager. Refer the help ...
                    • Why are few database metrics in the Database tab showing empty values in MS SQL monitor?

                      Why are few database metrics in Database tab showing empty values in MS SQL monitor? Before Applications Manager version 13910, We were showing high-level metrics for MS SQL monitor's Database usage from SQL server performance counters. But from ...
                    • Troubleshooting Hyper-V-Cluster data collection

                      In Hyper-V clusters, the data is collected via WMI. So if any of data is not retrieved properly in the UI, you can check and troubleshoot by executing the VBScript. 1) Go to Applications Manager's installed directory and navigate to the path ...
                    • How is Backup Age calculated for MS SQL DB monitor?

                      Backup Age displays the number of hours passed since the backup operation was completed. In simple terms, it is the difference between the current time and the time at which backup was performed. Backup Age (hours) = Current Time - Backup Time By ...
                    • Troubleshooting MS SQL login failure

                      Problem:  The following error message appears in MS SQL monitor during login: "Login Failed. The login is from an untrusted domain and cannot be used with Windows authentication"  Solution: Verify if the password of the SQL account (domain\username) ...