I tried to create a report based on a Task Sequence to retrieve all packages that a TS contains. The only thing I'm able to have is the package name, version, etc. Is there a table or a view that contains the value : Type, Name, Package, Program and the order (all the fields that are in the task sequence editor panel) ?
Thanks
Here my current query :
select v_TaskSequencePackage.Name 'TaskSequenceName',
v_TaskSequenceReferencesInfo.PackageID 'TaskSequenceID',
v_TaskSequenceReferencesInfo.ReferenceName 'PackageName',
v_TaskSequenceReferencesInfo.ReferenceVersion 'Version'
from v_TaskSequencePackage
inner join v_TaskSequenceReferencesInfo on v_TaskSequenceReferencesInfo.PackageID = v_TaskSequencePackage.PackageID
where v_TaskSequencePackage.Name like 'Insert your Task Sequence Name Here'
- Edited by EricPare Tuesday, November 29, 2011 2:15 PM