Loading…
This event has ended. Visit the official site or create your own event on Sched.
View analytic
Monday, May 15 • 1:00pm - 2:45pm
T-SQL - The Basics of Querying Data from ConfigMgr LIMITED

Log in to save this to your schedule and see who's attending!

Feedback form is now closed.
Limited Capacity seats available

Session Description:
Learn how to use SQL Server Management Studio to create custom ConfigMgr queries. Learn the best practices of querying as well as the ConfigMgr view structure. ...Be ready to get even more data from ConfigMgr via SQL.

What you will learn:
  • The basics of T-SQL - how queries are structured, sorting and filtering data, querying multiple views.
  • How to work with different data types.
  • How to aggregate your results

Speakers
avatar for Garth Jones

Garth Jones

Chief Architect, Enhansoft
Garth Jones is Chief Architect at Enhansoft, an Ottawa-based company that develops products and services to extend the value of System Center 2012 Configuration Manager (CM12), System Center Configuration Manager 2007 (CM07) and System Center Intune. Garth started working with Systems Management Server (SMS) back in 1996. He is an MVP for System Center Enterprise Client Management (formerly System Center Configuration Manager). | Garth is the founder of the Ottawa Windows Server User Group (OWSUG) and its associated study group. He currently holds the title of Past President. | He is an active participant in... Read More →
avatar for Matthew Teegarden

Matthew Teegarden

System Administrator, Lifetouch
Matthew has worked in assisting organizations to improve productivity, services and processes within the System Center suite. In 2015 he was Vice President of the MN System Center Users Group – the largest System Center users group in the country and is currently a board member... Read More →


Monday May 15, 2017 1:00pm - 2:45pm
Lakes A


Twitter Feed