Chris Nackers Blog

ConfigMgr and MDT Deployment Solutions

Useful Blogs

User Groups

Browse by Tags

All Tags » SQL (RSS)
Editing CM12 reports in the ConfigMgr console with SQL Server 2008 R2
Fellow MVP Steve Thompson has created a nice post for reporting in ConfigMgr 2012. Read the full post here. Presently, if you have installed ConfigMgr...
ConfigMgr-Update Driver Source Paths SQL Query
CAUTION: Editing the Database directly is unsupported. Proceed at your own risk. In addition to my previous post , in which I used a script to update the...
Beginners Guide to Writing SCCM Reports
John Marcum has created a nice blog post for how to get started creating your own SQL based web reports.  Read his full post here. There are often...
Configuration Manager-Reporting Services Access Denied When Running R3 Power Management Reports
Ran into an issue at a client this week that I haven’t run into before.  When trying to access the new R3 power management reports, we were receiving...
SQL Query To Show Program Flags
Thanks to John Nelson for this query:   DECLARE @ProgramFlags TABLE (    BitFlag INT PRIMARY KEY,    Meaning VARCHAR(128),   ...
ConfigMgr–Prerequisite Checker-SQL Server Sysadmin Rights Bug
Was working on setting up a new Central Site for a client today and noticed what appears to be a bug in the pre-req checker.  This was building a...
ConfigMgr SP1/SP2 Now Supports SQL 2008 R2
This and other support announcements located here: http://blogs.technet.com/b/configmgrteam/archive/2010/06/30/configuration-manager-support-announcements...
Free Microsoft Books For Download
Here’s a bunch of free books for download.  Very Cool! Free eBook: Moving to Microsoft Visual Studio 2010 (DRAFT Preview) Free eBook: Moving to Microsoft...
SQL query to identify missing SMS/ConfigMgr boundaries
This came up on the MSSMS list from myitforum.  Here is the final result of the collaboration.  Here is a SQL query you can use to help identify...
Finding the OU of a system in SMS/ConfigMgr
Alex Semibratov started up a blog and has a nice post on how to find the actual OU of a computer. If you have ever looked at the information you will notice...
Creating a Collection Query based upon Hardware Inventory
Credit to Dave Fuller for which this information is based upon. I posted previously on how to use a SQL statement for updating collection membership. ...
Creating a Collection Query From SQL
Credit to Dave Fuller for which this information is based upon. Creating a collection query that is based upon SQL can be done.  It’s a little complicated...