Query sccm2012 check package if its referenced into a task secuence

Hi Sometimes we don’t know what we are referencing in our task secuences . For this proposal … we can use a sql query connecting to our site database to get all Task secuences where our desired package are referenced

I’ts a good method before deleting a package when we don’t have info about the software or is corrupted

Here is the query anyway ( this must be run in sql management studio ), you will only need the PACKAGE ID to check the query

select tsr.packageID, tsr.referencepackageid, tsr.referencename, tsp.packageid, tsp.name
from v_tasksequenceReferencesInfo tsr

join v_tasksequencePackage tsp On tsr.packageID = tsp.packageid

where tsr.ReferencePackageID = ‘BCN000A2’ — ID PACKAGE

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.