Category Archives: Uncategorized

Management Pack Recap – October 2017 Wave

This is a summary of the wave of Management Packs that were released in October 2017. Information and download location in the links provided:

DHCP 2016 MP v10.0.9.0 – here
DHCP 2012 MP v6.0.7307.0 – here
SQL 2017+ MPhere

If you know of any other Management Packs that have been released recently that I may have missed leave me a note in the comments and I’ll add them

Management Pack Recap – December 2016 Wave

This is a summary of the wave of Management Packs that were released in December 2016. Information and download location in the links provided:

Windows Server MP v10.0.8.0here
WS-Management and SMASH Device Discovery MP v7.0.8707.0here
Windows Server 2016 AD, ADFS and DNS MPshere

If you know of any other Management Packs that have been released recently that I may have missed leave me a note in the comments and I’ll add them

Management Pack Recap – August 2016 Wave

This is a summary of the wave of Management Packs that were released in August 2016. Information and download location in the links provided:

SCCM MP v5.00.8239.1009  – here
SQL Server MP (Community Technical Preview 1) v6.7.3.0here
UNIX and Linux MPs v7.5.1060.0here

If you know of any other Management Packs that have been released recently that I may have missed leave me a note in the comments and I’ll add them

Management Pack Recap – July 2016 Wave

This is a summary of the wave of Management Packs that were released in July 2016. Information and download location in the links provided:

NiCE Oracle MP 4.00here
Microsoft Azure (Technical Preview) MP v1.3.22.0 – here
Windows Server Operating System MP v6.0.7316.0here

If you know of any other Management Packs that have been released recently that I may have missed leave me a note in the comments and I’ll add them

SCOM: Updated Microsoft Azure MP (Technical Preview) v1.3.18.0

A new version of the Azure technical preview MP has been released you can get version 1.3.18.0 here

New in this version

  • Added support for Virtual Machines (non-classic) in addition to Classic Virtual Machines supported previously
  • Improved logging for the case when RDFE resources request is performed under SPN mode
  • Fixed/added display names and Knowledge Base articles
  • Improved error logging
  • Fixed resource group name validation issue (underscore symbols in resource group names led to discovery fails)
  • Added “Configuring Proxy Connection” section to the guide
  • Fixed Data Warehouse performance issue; added main aggregation for performance metrics
  • “Known Issues” section of the guide is updated

SCOM: Database Status Report version 4

I’ve made some amendments to the Database Status Report that I posted about in 2015, Version 4 is now more streamlined and cleaner.

Sample screenshot:

dbstatussample

Feel free to contact me for information on this report or the questions about the RDL.

I would be interested to hear from anyone who has any comments or suggestions on this report or ideas for future ones.

 

SCOM: Understanding Grooming and Aggregation

This posting is a continuation of my basics series, this one deals with Understanding Grooming and Aggregation, two very important concepts which can have great impact on your environment if they are not functioning properly.

First you need to understand the different between these two concepts, at their most basic, Grooming is the method where data older then a specific period, called the retention period, is deleted. Aggregation is the method where raw data, which is collected on short intervals i.e. 5 minutes, are averaged into hourly and daily time intervals used for reporting purposes.

The Operations Database

opsdb1

A stored procedure, called p_PartitioningandGrooming is run by a SCOM rule on a once a day schedule. The retention settings for each data type can be set in the console under Administration > Settings > Database Grooming.

opsdb3

You can see the history of the OpsDB grooming jobs with the following SQL query:

select * from InternalJobHistory order by InternalJobHistoryId desc

A Status of 1 indicates a successful completion.

opsdb2

The Operations Data-warehouse

The Data Warehouse is more complexyou cannot change data retention settings from the console, they exist in a table called StandardDatasetAggregation, which contains the grooming and aggregation retention periods, intervals and other related data.

DW1

Data in the DW database moves through several tables as part of the aggregations process as the data is collected it is written to a Raw Data table, from there is will move to a Staging table where it will be aggregated and then moved to a relevant aggregated data table (Hourly / Daily) where it will be available to the reporting services.

Then once the data in these tables is older then the data retention period it will be groomed out of the database.

So why is it important for aggregation to work?

Reports use the hourly and daily data in order to generate, this means that if your aggregations are not working or slow there will be gaps in your reporting. Example below:

DW3

And there you have it. the basics behind aggregation and grooming, I hope this has been informative.

Management Pack Recap – February 2016 Wave

This is a summary of the wave of Management Packs that were released in February 2016. Information and download location in the links provided:

Windows Azure Pack MP v1.0.0.466here
Unix and Linux MP v7.5.1050.0here
Windows 10 Operating System MP v10.0.0.0here

If you know of any other Management Packs that have been released recently that I may have missed leave me a note in the comments and I’ll add them

Management Pack Recap – November 2015 Wave

This is a summary of the wave of Management Packs that were released in November 2015. Information and download location in the links provided:

OpsLogix Swift Management Pack V2.5.1.57here
Visual Studio Team Foundation Server 2015 Management Pack v14.0.24622.0here
SQL Server v 6.6.3.0here
SQL Server v 6.6.4.0here
Windows Server 2012 DHCP v6.0.7299.0  here
Opslogix VMWare ManagementPack V1.3.1.1 here
Management Pack for Microsoft Azure (Technical Preview) v 1.3.10.0here

If you know of any other Management Packs that have been released recently that I may have missed leave me a note in the comments and I’ll add them.