Chris Nackers Blog

ConfigMgr and MDT Deployment Solutions

Useful Blogs

User Groups

Browse by Tags

All Tags » Queries » SMS 2003 (RSS)
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...
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...
SMS 2003 – Inventory Local Installed Printers
This information is provided as is.  Do not perform any of the steps below if you are not familiar with the processes!   In order to show the...
SMS Web Reports – Using a list to run a report or defining more than one variables for the web report prompt
I was recently working on trying to find a way to return the computer names for a given set of user names.  This is pretty easy to do from query analyzer...
Viewing Package Dependencies in SMS 2003
I know of two ways to view package dependencies. One way is use a sql query as per John Nelsons’ blog: http://myitforum.com/cs2/blogs/jnelson/archive/2008...
SMS 2003 Report – Show computers in given AD site
I wrote this report a long time ago, however i saw it pop up in a distribution list today so figured I’d post it.  I’m not a SQL guru, but this should...
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...