Trending with Temporal tables

Trending is a very important component for BI work.  For a customer, it’s important know where they’ve been relative to where they are now; as well as help indicate where they’re headed.  In the past, this was typically accomplished by storing historical records in the same table or in history tables.  This certainly is an…

0

Reporting on SCOM Data: Piecing the data together (Part 2)

In my last blog post, Reporting on SCOM Data: Piecing the data together (Part 1), I discussed collecting host details from the SCOM DW db.  This provided a great foundation for correlating Health State and Alert data into the existing hierarchy that our customer wanted to see.  In this post, I’ll focus on querying the…

0

Reporting on SCOM Data: Piecing the data together (Part 1)

In my last post, Reporting on SCOM Data: Single Pane of Glass, I provided an overview of what we provided our customer that enabled them to view the Health State of their entire enterprise in one location.  In this post, I’m going to begin covering how we pulled together the data to present those views.  Special…

0

Reporting on SCOM Data: A Single Pane of Glass

Over the past 6 months or so, I’ve been building SSRS and Power BI reports based on SCOM data.  At first glance, this sounds super simple.  Just write some reports on top of the SCOM DW db.  However, rarely are things ever that simple. My customer had requirements that everyone from executives to technicians be able to…

2