SQL Query : Distribution Status of a Specific Package

This query will return all DPs to where the package has been pushed.

Select SUBSTRING(dp.ServerNALPath, CHARINDEX('\\', dp.ServerNALPath) + 2, CHARINDEX('"]', dp.ServerNALPath) - CHARINDEX('\\', dp.ServerNALPath) - 3 ) AS ServerName,
 dp.SiteCode,
 stat.SourceVersion,
 pstat.UpdateTime,
 stat.InstallStatus,
 dp.PackageID,
 case when dp.IsPeerDP=1 then '*' else '' end as BranchDP
 FROM v_DistributionPoint dp
 left join v_PackageStatusDistPointsSumm stat on dp.ServerNALPath=stat.ServerNALPath
 and dp.PackageID=stat.PackageID
 left join v_PackageStatus pstat on dp.ServerNALPath=pstat.PkgServer
 and dp.PackageID=pstat.PackageID
 WHERE dp.PackageID='XX10001'

Sample Output

 

Related posts

Leave a Comment