SQL query for 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


Leave a Comment