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

On the Jobs page select Import from the split-button below the table and upload the collector-jobs-scom-jobs.xml file.

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.