Browse by Tags
All Tags »
Queries »
SMS 2003 (
RSS)
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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. ...
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...