SQL Query for Sequential Software Delivery Task Status

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