Aria Operations SCOM Managment Pack not collecting data

Products

• VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

The Microsoft (MS) SCOM Management Pack (MP) is unable to collect data from Microsoft SQL Databases (DBs). 

Environment

• VMware Aria Operations 8.16.0
• MS SCOM Management Pack 9.0.0

Cause

This occurs because the Microsoft.SQLServer.Windows.Database resource kind is missing from the scom.properties configuration file.

Resolution

Workaround:

1. SSH to the adapter instance collector with root.
2. Change directory using the command below:

   cd /usr/lib/vmware-vcops/user/plugins/inbound/msscom_adapter3/conf

3. Edit the file scom.properties using vi.
4. Add the following resource kind at the end of the file:

   Microsoft.SQLServer.Windows.Database

5. Ensure the adapter instance is collecting from the same collector where the changes were made.

   Note: This procedure must be performed on each collector that hosts the MS SCOM adapter.

6. Navigate to Data Sources > Integrations > Adapter instance.
7. Wait for 15 to 20 minutes for the databases to be mapped.
8. Wait for 30 minutes to 1 hour for metrics to show up.