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  

Read More