Packages and Source Path of the Packages

Below is the SQL query for a Task sequence ID” 'CE100053'” with referenced packages and Source path of the packages

SELECT     TOP (100) PERCENT ps.Name AS C062, ps.SourceVersion, ps.SourceDate, ps.Targeted AS NumberOfDPsTargeted0, ps.Installed AS NumberOfDPsInstalled0,

                      ps.Retrying AS NumberOfDPsRetrying0, ps.Failed AS NumberOfDPsFailed0, ps.SourceSite, ps.SourceSize, ps.SourceCompressedSize, ps.PackageID,

                      dbo.v_Package.PkgSourcePath AS [Pkg Source Path]

FROM         (SELECT DISTINCT ReferencePackageID AS PackageID

                       FROM          dbo.v_TaskSequenceReferencesInfo

                       WHERE      (PackageID = 'CE100053')) AS RefPkgs INNER JOIN

                      dbo.v_PackageStatusRootSummarizer AS ps ON ps.PackageID = RefPkgs.PackageID INNER JOIN

                      dbo.v_Package ON ps.PackageID = dbo.v_Package.PackageID

ORDER BY C062

If you are migrating from sccm 2007 to sccm 2012.. you might need this query to identify the packages UNC path or Drive letters based packages

Selet package ID, name, PkgSourcepath from v_ackage where (PkgSourcepath like '\\') or pkgsourcepath like '%c:%')

order by PackageID