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

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