You can join vSMS_Folders and vFolderMembers in combination with packages. Probably can do the same with Collections and Applications.
From: [email protected] To: [email protected] Subject: [mssms] SQL views for reporting on location of objects in ConfigMgr 2012 console Date: Fri, 28 Mar 2014 17:27:32 +0000 Hey does anyone know if there are SQL views that will have the hierarchy of container node IDs for objects like collections, packages, applications etc? I’d like to build a report to show which folder an item is located in. For example in 2007 there was a view for collections v_CollectToSubCollect which gave the parent collection to each sub collection. Jeff Krueger IT - Endpoint Design Services Henry Ford Health System [email protected] 248.853.4466 CONFIDENTIALITY NOTICE: This email contains information from the sender that may be CONFIDENTIAL, LEGALLY PRIVILEGED, PROPRIETARY or otherwise protected from disclosure. This email is intended for use only by the person or entity to whom it is addressed. If you are not the intended recipient, any use, disclosure, copying, distribution, printing, or any action taken in reliance on the contents of this email, is strictly prohibited. If you received this email in error, please contact the sending party by reply email, delete the email from your computer system and shred any paper copies. Note to Patients: There are a number of risks you should consider before using e-mail to communicate with us. See our Privacy & Security page on www.henryford.com for more detailed information as well as information concerning MyChart, our new patient portal. If you do not believe that our policy gives you the privacy and security protection you need, do not send e-mail or Internet communications to us.
