:::: MENU ::::

SQL query for “X” package DP status

SQL  query  for “X” package DP status..By using Package Name

 

 

select

SUBSTRING(dp.ServerNALPath, CHARINDEX(‘\\’, dp.ServerNALPath) + 2, CHARINDEX(‘”]’, dp.ServerNALPath) – CHARINDEX(‘\\’, dp.ServerNALPath) – 3 ) AS [Code Server Name],

dp.SiteCode,stat.SourceVersion,pstat.UpdateTime,stat.InstallStatus,

dp.PackageID,V_package.Name AS [Package Name] 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 INNER JOIN

V_package ON V_package.packageid=dp.PackageID

where V_package.name = ‘Package Name’


So, what do you think ?