Share via

How to locate a Package in huge folder structure ( SCCM 2007)

  • Article

In large environments, we see a complicated folder structure for packages (SCCM). And it becomes very difficult to search for a package by selecting each and every folder.
This process becomes cumbersome if you are working on daily basis for huge package list and with lots of subfolders.

Here is the query to check the folder structure of a package you are looking for:

*select * from FolderMembers where Instancekey = 'ABC00134'   (Note: ABC00134 is package ID)
Select * from Folders where ContainerNodeID=51

*For every relevant ContainerNodeID you will find a parentcontainernode, if the value is 23, then use another command:
*Select * from Folders where ContainerNodeID=23.

*Same way repeat it until you get ContainerNodeID=0 (i.e. the root folder)
Hence to combine all ContainerNodeID through SQL query is:
*Select * from Folders where containerNodeID in (51,23,0)
*
This will give you a perfect list of rows showing 3 Rows with 3 Folder Names in symmetrical order to be checked in SCCM console.