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