This technical tutorial webinar provides an introduction to querying your SCOM Data Warehouse, together with examples of some of the awesome insights you can glean from it.
The webinar starts with an introduction to SQL querying the SCOM DW that should be suitable for all comers, regardless of experience, including connecting to the DW using SQL Management Studio, the views you’ll need to get to the data you want and general best practices, as well as some simple T-SQL terms you’ll need to construct your first queries.
We then move on to some example queries, including alert correlation, performance trending and downtime reporting.
By combining queries likes these with SquaredUp’s flexible SQL Tile, you can create some awesome dashboards and perspectives, such as the example alert ‘analytics’ perspective which, for any given alert, automatically shows previous recent occurrences, where else that same alert has been occuring and Mean Time to Resolution for that particular alert.
As you put this into action in your environment and hopefully create some great use-cases and queries of your own, we’d actively encourage you to share those back to the rest of the SCOM community, either via us or any other means. Similarly, if you need a bit of extra guidance, why not hop over to our Community Answers platform, where you’ll find a large and active community of SCOM experts ready to help.
In terms of putting this into action in your own environment, here’s a few important things to keep in mind;
Click here to download the slides for the session.
Coffee Break webinars run on the last Tuesday of every month and are bite-sized tutorials for SCOM and SquaredUp enthusiasts.
Sign up for the Coffee Break series here.