How to find a package in the console

-- How to find a package in SCCM Console

SELECT * FROM vFolderMembers WHERE ObjectType = 2 ORDER BY InstanceKey

 -- For a particular package, InstanceKey is the PackageID:

SELECT * FROM vFolderMembers WHERE ObjectType = 2

and InstanceKey = 'XXX00480'

 -- ContainerNodeID is the parent folder for the package. Then use:

SELECT * FROM vSMS_Folders

WHERE ContainerNodeID = 167795

ORDER BY ContainerNodeID

 -- Now traverse the parents up to the root. When ContainerNodeID = 0, that's the root
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s