SCCM 2012 all collections with folder name (full path like EX:---*root\Prduction\Appv\ *)i'm looking for .....
I tried with below SQL query its not giving properly.. *select c.SiteID as 'Collection ID',c.CollectionName,f.Name as 'Folder Name' from vCollections c* *inner join FolderMembers fm on fm.InstanceKey=c.SiteID* *inner join folders f on f.ContainerNodeID=fm.ContainerNodeID* If you guys have SQL query or Powershell please help with it -------- On Tue, Feb 9, 2016 at 9:29 AM, Schwan, Phil <[email protected]> wrote: > If you need to do it programmatically, the ConfigMgr PowerShell module is > the better way to go: > > > > $FolderObj = Get-WmiObject -Class SMS_ObjectContainerNode -Namespace > Root\SMS\Site_$SiteCode -filter "Name='$FolderName'" | foreach > {$_.ContainerNodeID} > > > > Get-WmiObject -Class SMS_ObjectContainerItem -Namespace > Root\SMS\Site_$SiteCode -filter "ContainerNodeID='$FolderObjID'" | > ForEach-Object { > > Get-CMDeviceCollection -CollectionID $_.InstanceKey | foreach > {$_.Name} > > } > > > > What specifically are you trying to accomplish? > > _________________________________________________________________ > > Phil Schwan | Technical Architect, Enterprise Windows Services > > *Microsoft VTSP (**[email protected] <[email protected]>**)* > > *Project Leadership Associates* | 2000 Town Center, Suite 1900, > Southfield, MI 48075 > > Lync: 312.756.1626 Mobile: 419.262.5133 > > www.projectleadership.net [image: linkedin_logo-19x20] > <http://www.linkedin.com/in/philschwan>[image: Twitter-Logo1-20x20] > <https://twitter.com/philschwan> [image: wordpress-logo3] > <http://myitforum.com/myitforumwp/author/philschwan> > > *[image: Description: Description: Description: Arrow email]**Lead with > Strategy. Leverage Technology. Deliver Results.* > > > > > > > > > > > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *Eswar Koneti > *Sent:* Tuesday, February 9, 2016 9:51 AM > *To:* [email protected] > *Cc:* mssms <[email protected]> > *Subject:* Re: [mssms] SQL query for SCCM collection folder path > > > > you can use search function (search sub folders) for apps packages task > sequences etc. > > https://blogs.technet.microsoft.com/configmgrteam/2011/06/27/tips-for-finding-objects-in-the-configuration-manager-2012-console > / > > Regards, > Eswar Koneti > www.eskonr.com > sent from mobile device,please excuse any typo's as a result. > > On Feb 9, 2016, at 6:46 AM, Kevin Ray <[email protected]> wrote: > > Hi Team, > > > > > > For SCCM 2012 I want to find the all collections or specific collection > folder path > > > > and > > > > For Specific Application or package or Task sequence folder path using SQL > query.. > > > > > >
