Your manager rushes to you and asks you to identify the Folder location of a culprit collection. You goes to SCCM console and search for it either with name or collection ID. You get the half detail but your manager asked for folder location and you scratches your head because from console you cant identify the folder location of that collection.
Dont worry!! running below query, you can get the folder detail quickly. Here we go:
Open SQL Server Management Studio > Access SCCM Database(preferably CAS) > New query > Run below query
select c.SiteID as 'Collection ID',c.CollectionName,f.Name
as 'Folder Name', f.FolderPath from vCollections c
inner join FolderMembers fm on fm.InstanceKey=c.SiteID
inner join folders f on f.ContainerNodeID=fm.ContainerNodeID
Output looks like below:
0 comments:
Post a Comment