widsnet.com
1Jul/110

Packages missing on DP and referenced by TS

A report to show all packages that are targeted to a distribution point bur aren't there yet, for some reason, and are referenced by a specific Task Sequence.

SELECT ps.PackageID, ps.SiteCode,
SUBSTRING(ps.ServerNALPath, CHARINDEX('\\', ps.ServerNALPath), CHARINDEX('"]',    ps.ServerNALPath) - CHARINDEX('\\',
     ps.ServerNALPath)) AS ServerNALPath,
ps.SourceVersion, ps.State, ps.LastCopied, ps.SummaryDate,
ps.InstallStatus, p.Manufacturer, p.Name
FROM
     (
         SELECT DISTINCT v_TaskSequenceReferencesInfo.ReferencePackageID AS PackageID
         FROM v_TaskSequenceReferencesInfo
         WHERE v_TaskSequenceReferencesInfo.PackageID=@TaskSequenceID
     ) RefPkgs
JOIN v_PackageStatusDistPointsSumm ps ON ps.PackageID=RefPkgs.PackageID
JOIN v_Package p ON p.PackageID=ps.PackageID
WHERE ps.InstallStatus!='Package Installation complete'
ORDER BY ps.PackageID

Prompts:

BEGIN
 IF (@__filterwildcard = '')
  SELECT PackageID AS TaskSequenceID, Name, Description FROM v_TaskSequencePackage
  ORDER BY Name
 ELSE
  SELECT PackageID AS TaskSequenceID, Name, Description FROM v_TaskSequencePackage
  WHERE PackageID LIKE @__filterwildcard
  ORDER BY Name
END
Comments (0) Trackbacks (0)

No comments yet.


Leave a comment

No trackbacks yet.