Loading…
This event has ended. Visit the official site or create your own event on Sched.
Back To Schedule
Monday, May 15 • 3:00pm - 4:45pm
T-SQL Queries: Report Fundamentals to Advanced Concepts LIMITED

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Tweet Share
Feedback form is now closed.
Limited Capacity seats available
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
Speakers
avatar for Andrew Craig

Andrew Craig

Senior Consultant, itnetX AG
I work for itnetX in Switzerland where I implement bespoke solutions for customers. Nothing here is out-of-the-box. My work involves the automation of business processes and the integration of , not exclusively but mainly, Microsoft System Center Technologies. Come and talk to me... Read More →
avatar for Dieter Gasser

Dieter Gasser

Head of Product Management, itnetX
Dieter Gasser is an IT consultant and a management partner of itnetX AG, headquartered in Switzerland. He has a strong focus on the delivery and customization of Service Manager. Dieter has been working in IT for more than 16 years, and has focused on Microsoft technologies. He started... Read More →

Reference Configuration Manager 2007 SQL Views Schema vsd
Reference Configuration Manager 2007 SQL Views xls
T SQL Queries pdf
Queries zip
Monday May 15, 2017 3:00pm - 4:45pm CDT
Lakes A
  SQL, ConfigMgr, SCOM

Attendees (51)