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]<mailto:[email protected]>)
Project Leadership Associates | 2000 Town Center, Suite 1900, Southfield, MI 
48075
Lync: 312.756.1626  Mobile: 419.262.5133
www.projectleadership.net<http://www.projectleadership.net/> 
[linkedin_logo-19x20] <http://www.linkedin.com/in/philschwan> 
[Twitter-Logo1-20x20] <https://twitter.com/philschwan>  [wordpress-logo3] 
<http://myitforum.com/myitforumwp/author/philschwan>
[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<http://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]<mailto:[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..



Reply via email to