Suraaj Vyas Technical Lead

I have to create an aging report which docuware does not produce out of the box. So i am looking into the database and i want to know how i can create a report which tell me at any time how many documents are assigned to each user in the workflow. Also tell me for each document type how many documents falls in categories like 0-5 days, 6-10 days, 11-15 days, 16-20 days, 21-25 days, 26-30 days and over 30 days.See below to see an example of how i need the data back.

Which tables should in database will have Assign To (System variable) information.
 

Assigned To (Workflow)	Document Type	0-5 Days	6-10 days	11-15 days	16-30 days	21-25 days	26-30 days	Over 30 days
A	abc	1						1
A	def		1	3		2
B	abc
C	abc	1		1

1.I want to stop users from deleting documents from document tray. Is that possible.
2. If not i can find the table in database which stores the documents in the tray but are removed when deleted. Are these deletions tracked

How can i run a report to get this information.