:::: MENU ::::

How to find SCCM 2012 collection location

<strong>select c.SiteID as 'Collection ID',c.CollectionName,f.Name </strong>
<strong>as 'Folder Name' from vCollections c</strong>
<strong>inner join FolderMembers fm on fm.InstanceKey=c.SiteID</strong>
<strong>inner join folders f on f.ContainerNodeID=fm.ContainerNodeID</strong>

So, what do you think ?