Info: List workflow steps for a container mapping (4301395)

Issue
Sometimes it might be necessary to verify all of the workflow steps which have taken place in Stage 2 for a container mapping. This article explains how that can be done.
Solution
The following query can be run on the Archive Shuttle Directory Database to obtain the information:
 

declare @sContainerID varchar(45)
declare @sTargetID varchar(45)
declare @iMappingID int
set @iMappingID = xxxx
select ws.ContainerMappingId,ws.WorkflowSequenceId, ws.TaskExecutionStatusId, ws.workflowstatusid, ws.LastUpdateDateUtc, wfs.CommandId, c.Name
from dbo.WorkflowStatus ws, dbo.WorkflowSequence wfs,dbo.Command c
where ws.WorkflowSequenceId = wfs.workflowsequenceid and wfs.CommandId = c.CommandId and containermappingid = @iMappingID
order by LastUpdateDateUtc