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:

• Packages in task sequence targeted but not installed.sql (573 downloads )  – @tsid
• TaskSequences referenced by a specific package.sql (635 downloads )  – @PkgID
• Compare two Task Sequeneces.sql (541 downloads )  – @tsid1 & @tsid2