This will give you information on the status of Sequential Software Delivery Tasks which you can build dynamic collections in Altiris.
In your search criteria use the AdvertisementName of one of the programs that will execute within the Sequential task NOT the actual name of the Sequential task.
Select vc.name, vc.guid,st.status, st.exitcode, it.name From inv_synch_status st Join vcomputer vc on vc.guid = st._resourceguid Join item it on st.taskid = it.guid Where st.synchronizationid in (select guid from item where name Like '%%) and st.status = 'completed' Order by it.name