Task Sequence and Package Management Reports

There are 3 reports in this group;

The first returns a list of all packages in a Task Sequence and the DPs they are targeted at that are in a “not installed” state. Currently this only detects targeted and not installed, once I figure out the SQL i’ll update this so it includes DPs that it is not targeted at as well.

The second lists all Task Sequences that reference a specific package, the idea here is if you wish to replace a package with a newer version or decommission a package you can get a list of all of the TSes that include it.

The third and final report compares two Task Sequences and returns a list of packages that are in one but not the other along with the ID of the Task Sequence that it is in.

Prompts:

@tsid

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

@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

Reports:

• [Download not found] – @tsid
• [Download not found] – @PkgID
• [Download not found] – @tsid1 & @tsid2