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
