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.
Only Windows Admistrative users will be able to view Cluster Details tab in MS SQL Monitor.
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 you're still unable to see data in the UI, kindly refer this link.


          • Related Articles

          • Real User Monitor (RUM) - Troubleshooting

            If the monitor has not polled data for long time. Follow below steps for troubleshooting Check prerequisites to done : Real User Monitor requires RUM Agent to be installed and mapped to Applications Manager. Refer the help page to know how to setup ...
          • 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 ...
          • 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 ...
          • How to get ISP data in Real User Monitor?

            By default, Real User Monitor does not show ISP data of end user. To get ISP data, you can make use of any third-party Geolocation API. Currently, RUM supports only APIs that return the response in JSON format. When you have purchased any Geolocation ...
          • 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) ...