Browse by Tags

All Tags » CTE (RSS)

ConfigMgr - Query to find all CM folders and show where they are in the console by jnelson

In response to a forum post, I've decided to write a quick article on getting folders from CM (and showing subfolder structure) and showing what kinds...

SMS 2003 - Query to pull logged on user records from all sources by jnelson

I was trolling the forums lately on MyITForm.com and was reading some conversations about logged on user records. It made me think of all the sources where...
Filed under: , ,

SMS Web Report (SQL 2005+) - Show SMS program execution chaining hierarchy visually using CTE (Common Table Expressions) in SQL 2005+ by jnelson

In response to a request on the forums, here's a SQL query that uses common table expressions (CTE) to visually return the program execution chain...
Copyright - www.myITforum.com, Inc. - 2010 All Rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems