Demystifying ConfigMgr and SQL Queries
Topic Level: 200
For many ConfigMgr Admins, ConfigMgr database and SQL queries is a big mystery. In this session, we will solve the mystery of the ConfigMgr Database, starting with how to access the database and the tools used to access the ConfigMgr database. We will move on to how to create a SQL query queries. Throughout the session, we will point out where to find the most important information and the key SQL views needed for your SQL queries.
Learning to create great SQL queries will help you find information you need and will help you when you want to create dashboards/ reports with Power BI, SQL Server Data Tools or even Excel.
What you will learn:
Learn what tools can be used to query the ConfigMgr SQL database.Learn to create SQL queriesSolving the mystery of the ConfigMgr Database.
System Center Configuration Manager Garth Jones will present on reporting and querying using SCCM. More details tbd.
Garth Jones is Chief Architect at Enhansoft (http://www.enhansoft.com/), an Ottawa-based company that develops products and services to extend the value of System Center Configuration Manager (Current Branch) (CMCB), 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 (https://mvp.support.microsoft.com/profile/Garth) for System Center Enterprise Client Management (formerly System Center Configuration Manager).
Garth is the lead author for System Center Configuration Manager Reporting Unleashed (http://www.informit.com/store/system-center-configuration-manager-reporting-unleashed-9780672337789). He is an active participant in Microsoft’s forums, as well as on windows-noob.com (https://www.windows-noob.com/) and myITForum.com (http://www.myitforum.com/).
Garth is the founder of the Ottawa Windows Server User Group (http://www.owsug.ca/) (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 a presenter at the Midwest Management Summit, MVP Days Canada, Microsoft Management Summit, EnergizeIT, ITProTeach and Techdays. Along with participating in forums, and public speaking, Garth also creates webcasts for both Enhansoft, SMSUG.ca and myITForum.com.
Deploying Windows 10 using System Center Configuration Manager 1702
In this session Todd is going to show you how to deploy a Windows image using Configuration Manager.
We will look at PXE boot, driver management, applications and packages and finally we will look at what is new in CM1606 and 1702 to better support and manage Windows 10 and Office 365.
Please RSVP so we have an idea on how many people will be attending.
Pizza and pop will be served on a first come first serve basis. Important
The building elevators are locked at 6:00 pm so make sure you arrive before then.