SCCM Reporting and You!


SCCM Reporting and You!

Session Description:

Have you ever had to answer the question, who has Visio installed? How many Dell computers do you have? We all know that SCCM is a great product but where would it be without reporting? You couldn’t answer those questions without it. We also all know that the built-in reports never give you exactly what you want. So Create your own! In this session, SCCM Reporting and You, Garth will walk us from start to finish in creating a useful report. Starting with a SQL query that can be found on his blog, he will show how to test the SQL query. Next he will create a basic report before taking the report from Plain Jane to a work of art.

What you will learn:

* Learn what tools can be used to query and report on data within ConfigMgr Database

* Learn the tips and tricks to reporting

* Learn the tips and tricks for SQL query tools

BIO Garth Jones is Chief Architect at Enhansoft, an Ottawa-based company that develops products and services to extend the value of System Center Configuration Manager (SCCM) Current Branch (CMCB), System Center 2012 Configuration Manager (SCCM 2012), System Center Configuration Manager 2007 (SCCM) 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 lead author for System Center Configuration Manager Reporting Unleashed. He is an active participant in Microsoft’s forums, as well as on and 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.

Garth is often called upon to be a speaker. He presented numerous times to OWSUG, and was has been presenter at the Midwest Management Summit, ITProTeach, MVP Days Canada, Microsoft Management Summit, EnergizeIT, and Techdays. Along with participating in forums, and public speaking, Garth also creates webcasts for both Enhansoft, and