Not 100% sure about the Parallel transition, but you'll need the Documents, Status, TransitionHistory, Transitions and others. This might get you started:
Select p.path 'Folder Path', d.filename 'File name', th.transitionnr 'Transition #', t.name 'Transition Name', u.username 'Transitioned By',
th.comment 'Transition Comment', CONVERT (VarChar, th.date, 101) 'Date of Transition' , s.name 'Current Document State'
From Documents d
/** DocumentsInProjects lists all of the documents that are in a project. It does not list the project names.
You need to join the Projects table if you want the folder names and paths **/
Inner join DocumentsInProjects dp on d.documentid = dp.documentid
Inner join Projects p on dp.projectid = p.projectid
Inner join Status s on d.currentstatusid = s.statusid
/** TransitionHistory lists all of the documents that have gone through a workflow transition. It does not list the Transition names.
You need to join the Transitins table if you want the Tranistion names**/
Inner join TransitionHistory th on d.documentid = th.documentid
Inner join Transitions t on th.transitionid = t.transitionid
Inner join Users u on u.userid = th.userid
Where (d.deleted = 0) and (d.ObjectTypeId = 1)
Order by d.filename, th.transitionnr
Whoa - thank you very much! Getting so much more than I asked for is great. Pretty sure this will do the trick or at least get me down the path to success. Thanks again.