Chris Nackers Blog

ConfigMgr and MDT Deployment Solutions

Useful Blogs

User Groups

Browse by Tags

All Tags » Queries » ConfigMgr (RSS)
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...
ConfigMgr–Creating A Collection For All Systems Not Approved
Saw this past by on the MSSMS list today and thought it was good info.  Thanks to Brandon Linton for contributing it. Collection query: select SMS_R_SYSTEM...
Posted: Apr 11 2011, 04:34 PM by cnackers | with no comments
Filed under: , ,
How to retrieve the Lenovo Modelname (Full name) instead of TypeNumber within Configmgr
Great post by Kenny Buntinx. Read the full post here.
SQL Query To Show Program Flags
Thanks to John Nelson for this query:   DECLARE @ProgramFlags TABLE (    BitFlag INT PRIMARY KEY,    Meaning VARCHAR(128),   ...
ConfigMgr Inventory–Group Policy Preferences
Trevor Sullivan has a nice post over on his blog talking about inventorying your systems to find out which systems don’t have the Group Policy Preferences...
System Center Configuration Manager (ConfigMgr)–Updating Package Source Paths
The information provided in this post is provided as-is, this is most likely unsupported, proceed at your own risk. There are times when you may need to...
ConfigMgr–Exclude Members Of Another Collection
Was working on a crazy collection query today for a client and I needed to exclude the members of another collection in addition to the other queries I...
SQL Server Reporting Services and System Center Configuration Manager
Article in January 2010 Issue of TechNet: http://technet.microsoft.com/en-us/magazine/ee914611.aspx “Reporting is a crucial ability for most organizations...