CDP Manage: This query will show you all the document information

select
e.label as [Index Name]
,a.fieldvalue as [Index Value]
,b.memberno as [Member Number]
,c.DocumentID
,c.DocumentDescription
,c.DateSend
,c.RemoteID
,c.DateConfirm
,c.Pending
,c.Comment
,c.LastUpdated
,case
when c.cdpwebsignoriginated=0 then 'CDPManage Orignated'
when c.cdpwebsignoriginated=1 then 'CDPWebsign Orignated'
end as [Document Origin]
,c.HiddenDate
,d.[PageNo] as [Page#]
from DocField a
inner join
documentmember b
on
a.documentid=b.documentid
inner join document c
on
a.documentid=c.documentid
inner join
documentpage d
on
a.documentid=d.documentid
inner join IndexField e
on
a.indexfieldid=e.indexfieldid
--where c.documentid='' -- uncomment this if you are looking for a specific document
--where c.pending=1 -- uncomment this if you are looking for pending documents only
--where c.pending=0 -- uncomment this if you are looking for saved documents only
--where c.datesend is not null and c.remoteid is null and c.dateconfirm is null and c.pending=0 -- uncomment this if you are looking for files that have been sent, but not confirmed.
Order by c.documentid