Chris Nackers Blog

ConfigMgr and MDT Deployment Solutions

Useful Blogs

User Groups

Browse by Tags

All Tags » Queries (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...
Identifying Collections A Computer Is in
This query will show you what collections a computer is a member of.  Thanks to Todd and Brian on the SCCM myITForum list. Select v_R_System.Name0...
ConfigMgr and/or MDT – Useful WMI Queries and WMI Tools
Wanted to post a blog entry with typical WMI “backend” queries for limiting Task Sequence steps. My intention is to update this as I find more queries...
Advanced reporting against Add/Remove Programs (ARP), filtering and appending data – Part 2
I’m not a SQL expert by any means, so if you see something that isn’t quite right, well i already said I'm not a SQL expert :) This process involves...
Advanced reporting against Add/Remove Programs (ARP), filtering and appending data
I’m not a SQL expert by any means, so if you see something that isn’t quite right, well i already said I'm not a SQL expert :) This process involves...
WMIC Alias/WMI Class Mapping
http://blogs.1e.com/index.php/2009/09/23/wmic-aliaswmi-class-mapping/ Nice post by Mike that shows the various WMI alias’s and queries that are useful...
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...
More Posts Next page »