I recently had a need to create an OpsMgr report to show performance data with a "threshold" line, so that it would be easy to see data points that went over a defined threshold. We can't do this with the built-in generic performance report, so I put together this one:
The following parameters are available in the report:
Start Date / End DateTime range that we are interested in.
Object NameSelect the performance object that you are interested in. This is populated by the objects in the vPerformnaceRule view in the Data Warehouse database.
Counter NameSelect the counter that you are interested in. This is populated by the counters in the vPerformanceRule view, based on the Object that was selected.
ComputerSelect the computers that you are interested in. This is populated with a list of computers that have data in the Data Warehouse for the performance object that was selected.
Threshold LineOptional. Enter a value for the threshold. A red line will be drawn at this value on the chart, and any data point above this value will be labeled with the computer name and the value for the data point.
Min / Max Sale ValueOptional. This is the minimum and maximum values to for the "Value" axis on the chart. If not defined, these will be calculated based on the values of the data returned.
Data TypeSelect the data set to use from the Data Warehouse....options are "Hourly" (hourly average of the data points), "Daily" (daily average of the data points), and "Raw" (all data points).
GMTOffsetI don't have the cool time zone selector in this report, so you'll need to enter the GMT offset for the time zone that the data should be converted to (data in the Data Warehouse is stored in GMT time). For example, if the computers you are interested in are in New York (Eastern Time), you would enter "-5" (without the quotes).
Report TitleEnter a title for the report