SCOM Managed Instance plugin

The SCOM Managed Instance (MI) data source accesses data in the SCOM MI PaaS monitoring service. The SCOM Managed Instance plugin also connects to traditional SCOM installation by connecting directly to the OperationsManagerDW database without utilizing the Relay agent. Made in partnership with Microsoft.

See also: Blog: SCOM MI data source.

Before you start

You will need

• A username and password to the SCOM data warehouse database.
• A URL and port

Configure SCOM Managed Instance in Azure

Do the following to configure SCOM MI PaaS.

1. Log in to the Azure Portal.
2. Search for SCOM Managed Instance and click on the instance to connect to SquaredUp.
3. Under Reports select the PowerBI tab.
4. Copy the DB Name and DB Host URL. You will use these when Configuring the data source in SquaredUp.
5. Make note of the username and password that will access the Azure resource.

Configure SCOM SQL Server

Do the following to configure a traditional SCOM database server:

1. Log in to the SCOM database server hosting the OperationalWarehouseDW database.
2. Open SQL Server Management Studio (SSMS).
3. Open the Server Properties dialog and change the SQL Server Authentication from Windows Authentication mode to SQL Server and Windows Authentication mode.
4. Create a new login under the Security node. This account requires the following:
   1. SQL Server authentication
   2. Public Server Role
   3. Be mapped to the OperationsManagerDW database with the following roles:
      • db_datareader
      • public
      • OpsMgrReader
      • SCOM_HealthService
   4. Grant permission to connect to the database engine.
   5. Login enabled.
5. Make a note of the username, password, server FQDN, and port.

Configuring the data source

1. Display Name:
   Enter a name for your data source. This helps you to identify this data source in the list of your data sources.

2. DB Name:
   Enter the DB Name for the Data Warehouse database. This value can be found in the Reports section of the SCOM managed instance, but is usually OperationsManagerDW.
3. DB Host URL:
   Enter the URL / FQDN of the SCOM MI database server. This value can be found in the Reports section of the SCOM MI Instance.

   Keep the comma and port after the URL, for example, server.domain.local,1433 or server.domain.local,3342

4. Username:
   Enter the username that has access to the database.
5. Password:
   Enter the password for the Username you entered.

6. Restrict access to this data source:
   You can enable this option if you only want certain users or groups to have access to the data source, or the permission to link it to new workspaces. See data source access control for more information.

7. Install Sample Dashboards:
   Select whether you would like to install sample dashboards with the data source. By default, this is set to on.

   You can also add a data source from Settings > Data Sources > Add data source, but sample dashboards are not added when using this method.

8. Click Test and add to validate the data source configuration. SquaredUp will now attempt to connect to SquaredUp using the provided authentication method. If this process fails, see Testing and troubleshooting for assistance with the corresponding errors.

Next Steps

Data streams

The following data streams are installed with this plugin.

Metric

This data stream calls an API endpoint to get metrics from your SCOM instance. The following parameters can be configured:

• Object Name:
  Enter the name of the object you want metrics for, for example, LogicalDisk.
• Counter Name:
  Enter a name for the metric, for example, Free Megabytes.
• Instance Name:
• Optionally, enter the name of the SCOM MI instance you want metrics from.
• Top N:
• Optionally, enter the Top N number of items you want to see in the results.
• Sort descending:
• Select if you want to sort the results descending instead of ascending.

Was this article helpful?