Oh I agree that part is a pain, but it's a lot better than 2007 was. I suppose better by comparison, just not incredibly great.
Daniel Ratliff From: [email protected] [mailto:[email protected]] On Behalf Of Marcum, John Sent: Wednesday, October 09, 2013 8:35 AM To: '[email protected]' Subject: [mssms] RE: SQL query for containers in ConfigMgr 2012? Am I the only person who finds the search of all folders to be a PIA? I click in the search box, start typing my search and realize the all folders button didn't light up. I click in and out of the search box a few times until it finally lights up then start typing again. Then I realize I didn't click the all fodlers button so I do that which clears my search paramters so I have to retype them. ________________________________ John Marcum Sr. Desktop Architect Bradley Arant Boult Cummings LLP ________________________________ From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of Schwan, Phil Sent: Tuesday, October 08, 2013 8:36 PM To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: SQL query for containers in ConfigMgr 2012? 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]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of Daniel Ratliff Sent: Tuesday, October 8, 2013 8:56 PM To: [email protected]<mailto:[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. ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. 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.

