Thursday, September 13, 2012

[OpsMgr 2007 R2][OpsMgr 2012] Correspondence between categories (PerformanceCollection, Alert, Custom...) and IDs

Jean-Sebastien DUCHENE has made a correspondence table that could be useful to create reports where you may need to make the match between IDs and categories of rules, monitors, or discoveries.
Table in Operations Manager DB or in the DW sometimes contains IDs and sometimes contains the Category (string). When category is given by it's ID, you have to convert it in a string.

If you have a doubt on what I'm speaking about - here is a screen shot in the authoring console :


These parameters in SCOM DBs are sometimes hard coded with an ID, and sometimes "in clear" in a string.

No-one before has done this correspondence - thanks to him to provide this table !

ID
Category
0
PerformanceCollection
1
Operations
2
EventCollection
3
StateCollection
4
SoftwareAndUpdates
5
Alert
6
System
7
Custom
8
AvailabilityHealth
9
PerformanceHealth
10
ConfigurationHealth
11
SecurityHealth
12
Discovery
13
Notification
14
DSIntegration
15
ConnectorFramework
16
ExceptionMonitoring
17
Maintenance


This posting is provided "AS IS" with no warranties.

No comments:

Post a Comment