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 id=”45″] – @tsid
  • [download id=”46″] – @PkgID
  • [download id=”47″] – @tsid1 & @tsid2

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This blog is kept spam free by WP-SpamFree.