Any one ? On Fri, Feb 12, 2016 at 8:37 AM, Kevin Ray <[email protected]> wrote:
> 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.. >> >> >> >> >> >> > >
