Folders are listed in vFolderMembers (note this is folder membership so there will be no entries for empty folders; those could be found in the Folders table). That should hopefully point you in the right direction...haven't had time to create any updated queries.
That said, the ConfigMgr 2012 console makes it much easier to search for stuff ;) -Phil From: [email protected] [mailto:[email protected]] On Behalf Of Daniel Ratliff Sent: Tuesday, October 8, 2013 8:56 PM To: [email protected] Subject: [mssms] SQL query for containers in ConfigMgr 2012? Anyone know any of the views/tables to determine containers in 2012? I found a post from Phil for 2007 but I don't see any of the views/tables in my db. http://myitforum.com/myitforumwp/2012/07/10/where-is-that-darned-package-or-collection/ Daniel Ratliff The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information. ________________________________ PRIVILEGED AND CONFIDENTIAL. This email and any files transmitted with it are privileged and confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender. If you are not the named addressee you should not disseminate, distribute or copy this e-mail or any of its attachments.
