MMS 2017

Session Description:
Everyone wants reports, and there are tons of tools and technologies available for creating them. But no matter how great an Excel-crack you are, or how shiny and crisp your PowerBI reports look, there are still big challenges facing you, because regardless of which reporting tool you use you still need to know how to find your data, and how to query it from the database. This session is a step-by-step training for using native T-SQL to create queries which you can use in your ConfigMgr reports.

What you will learn:

• Writing native T-SQL queries in SQL Server Management Studio

• Creating views and stored procedures to save your queries

• Querying System Center databases and using the queries in reports

• A collection of sample queries is yours to take away