I'm looking for a SQL query to get ALL of the data that appears in a documents history (right-click on a file, select History).

I found a query in the forums from 2 years ago -   - but this does not return all of the data that is displayed in the history dialog box. It has the workflow transitions but not a record of when the document was created, or each time it was is checked in, etc.

I think that data from the Revisions table needs to be combined with data from the TransitionHistory table but I'm not sure of how to do that.

Thanks.