Browse by Tags

Johns amazing stash
Monday, January 04, 2010 4:54 PM

John Nelson over at myITforum has a excellent blog covering SMS. You'll find a treasure trove of superb SQL queries that accomplish specific tasks as well as give you an insight in to how best to do things in SQL. Great resource for budding SQL\SMS guru's :-) Johns treasure horde of SMS knowledge Read More...

by Rob - MVP | with no comments

Filed under: SQL query, John Nelson

Simple SQL query - Show collections a client is a member of
Friday, May 15, 2009 4:11 PM

Was just asked to create a ConfigMgr query to show which collections a client is a member of: Note: Collections do not replicate upwards, so running this on your Central for a Tier 2\3 client will not show anything. Either run it on the assigned site server, or from a higher up site server where all the collections are managed ... SELECT v_FullCollectionMembership... Read More...

by Rob - MVP | with no comments

Filed under: ConfigMgr 2007, Collection membership, SQL query