Year/Month filter and aggregation in an Excel Pivot Table in SCSM 2012

Update: there’s now an alternative method directly from the product group that creates a new dimension in Service Manager SystemCenterWorkItem cube: http://blogs.technet.com/b/servicemanager/archive/2012/12/07/incidents-or-service-requests-sliced-by-months-quarters.aspx   At the time of this writing, it seems that is not possible to filter or aggregate workitems by date selecting months and years. For example you cannot easily filter incident created in […]

OpsMgr – Is alert reporting reliable? Reprise with some light.

In my last post Is alert reporting reliable? I focused on three aspects of alerts reporting that make me assert it isn’t reliable: alerts present in the live database, but not present in the data warehouse (anymore) alerts present in the data warehouse with an inconsistent resolution state (compared to the  data in the live […]

Disk performance reporting

Disk performance reporting and trending is probably the most difficult part of performance troubleshooting and capacity planning and trending. During the years I used several counters just to understand none of them can give a synthetic and accurate answer on disk performance. Ever tried to user % idle time or % disk time? Or Avg […]

How to integrate custom SRS Reports in SCCM

In a recent SCCM deployment I’ve been asked to produce some custom reporting. These are the kind of reports it’s not easy to develop with the standard SCCM reports (ASP based) and I always used SQL reporting Services (SRS) to give some extra value. This time, with SCCM SP1, I decided these reports needed to […]