Operations Manager Distributed Application Health Visual In Power BI (With Awesome Status Icons!)
Back in 2011 Steve Beaumont created an awesome post on SCOM Distributed App Dashboard. I decided to use this post to replicate the dashboard in Power BI! The SQL Query To retrieve the information required, we’ll use the below updated SQL script to pull back the information required. SELECT BaseManagedEntity.DisplayName AS ‘Application’,MAX(State.HealthState) […]