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