Browse by Tags
All Tags »
Queries (
RSS)
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...
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...
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...
Great post by Kenny Buntinx. Read the full post here.
Thanks to John Nelson for this query: DECLARE @ProgramFlags TABLE ( BitFlag INT PRIMARY KEY, Meaning VARCHAR(128), ...
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...
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...
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...
Article in January 2010 Issue of TechNet: http://technet.microsoft.com/en-us/magazine/ee914611.aspx “Reporting is a crucial ability for most organizations...
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...
More Posts
Next page »