Microsoft System Center Operations Manager

Overview

Microsoft System Center Operations Manager (SCOM) is an agent-based monitoring system for the Microsoft Windows operating system and compatible applications.

SCOM collects and stores statistics from Windows servers in Operations (PerformanceDataAllView) and DataWareHouse (vperf_raw, vperf_hourly, vperf_daily) database views.

Axibase Collector queries PerformanceDataAllViewin the SCOM Operations database view every 30 minutes to offload incremental data into Axibase Time Series Database for long-term retention and operations analytics.

Requirements

  • Microsoft System Center Operations Manager 2012+.

Installation

Import Microsoft SCOM JDBC job

Configure Microsoft SCOM Database Connection

  • Open the Data Sources > Databases page and select the scom database.
  • Provide connection parameters to the target scom-2012 database as displayed below:

  • Execute test query to check the connection:
SELECT 1
  • Query result must be Query OK.

Verify Job Configuration

  • Open SCOM job.
  • Set Data Source to scom.

  • Choose one of target ATSD instances if the Collector instance is connected to multiple ATSD servers.
  • Save the Job.
  • Open each configuration, click Test and review the output. See Data Queries below.

Schedule the Job

  • Open the JDBC Job page and click Run for the Microsoft SCOM JDBC job.
  • Ensure that the job status is COMPLETED and Items Read and Sent commands are greater than 0.

  • If there are no errors, set job status to Enabled and save the job.

Verify Metrics in ATSD

  • Log in to ATSD.
  • Open the Metrics tab and filter metrics by prefix scom.*.

Viewing Data in ATSD

Metrics

Properties

Entity Groups

  • scom-servers
  • scom-databases

Portals

Data Queries

Data queries that offload recent metrics and properties.