I have 85 or so DPs across more than 5 Primary sites and sometimes I see failures in newly created Task Sequences (or even old ones) during an OS deployment due to a package not being available.
- Distribution status of a specific package on a specific distribution point – This report shows the installation status of a package on the specified distribution point.
- Distribution points without a specific package – This report shows any Distribution Points a Package is not installed on. N.B. Package MUST be targeted to the site in order to be detected
- Distribution points without a specific package in a site – This report shows any Distribution Points a Package is not installed on in the specified site. N.B. Package MUST be targeted to the site in order to be detected
- Distribution status of a specific package in a site – This report shows the installation status of a package on each of its distribution points in the specified site
Prompt Queries:
@compname
begin
if (@__filterwildcard = '')
SELECT DISTINCT SYS.Netbios_Name0
FROM v_R_System SYS
ORDER By SYS.Netbios_Name0
else
SELECT DISTINCT SYS.Netbios_Name0
FROM v_R_System SYS
WHERE SYS.Netbios_Name0 like @__filterwildcard
ORDER By SYS.Netbios_Name0
end
@DP
begin
if (@__filterwildcard = '')
SELECT DISTINCT
SUBSTRING(ServerNALPath, CHARINDEX('\\', ServerNALPath) + 2, CHARINDEX('"]', ServerNALPath) - CHARINDEX('\\', ServerNALPath) - 3 ) AS C070
FROM v_DistributionPoint
ORDER BY C070
else
SELECT DISTINCT
SUBSTRING(ServerNALPath, CHARINDEX('\\', ServerNALPath) + 2, CHARINDEX('"]', ServerNALPath) - CHARINDEX('\\', ServerNALPath) - 3 ) AS C070
FROM v_DistributionPoint
WHERE SUBSTRING(ServerNALPath, CHARINDEX('\\', ServerNALPath) + 2, CHARINDEX('"]', ServerNALPath) - CHARINDEX('\\', ServerNALPath) - 3 ) LIKE @__filterwildcard
ORDER BY C070
end
@PkgID
begin
if (@__filterwildcard = '')
SELECT DISTINCT PackageID, Name AS C062
FROM v_Package
ORDER BY Name
else
SELECT DISTINCT PackageID, Name AS C062
FROM v_Package
WHERE PackageID like @__filterwildcard
order by Name
end
@scode
begin
if (@__filterwildcard = '')
SELECT DISTINCT SiteCode, SiteName AS C062
FROM v_DistributionPoint
ORDER BY SiteCode
else
SELECT DISTINCT SiteCode, SiteName AS C062
FROM v_DistributionPoint
WHERE SiteName like @__filterwildcard
order by SiteCode
end
Reports:
- [download id=”41″] – Requires prompts @PkgID & @scode
- [download id=”42″] – Requires prompts @PkgID & @DP
- [download id=”43″] – Requires prompts @PkgID & @DP
- [download id=”44″] – Requires prompts @PkgID & @scode
