nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

document activity

System

does anyone have any sql queries they use to show document activity ?
more or less columns as such:

Workspace : Document Name : User ID : Action : Action Time

thanks!

Find more posts tagged with

Comments

JimL

I'll post some that I use, but keep in mind that we migrated from the old version 3 of Worksite MP so the table "owner" is IMANAGE. You may need to change that to make it work within your environment.

JimL

Select Rdn, Name_last, Name_first, Count(*) 'file Count', Sum(version_size) 'total Size'
From Imanage.doc_version Ver
Join Imanage.doc_document Doc On Ver.document_rsid = Doc.sid
Join Imanage.p_con_document_activity_log Act On Act.p_item_rsid = Doc.sid
Join Imanage.dit_trustee Tru On Act.p_doc_actor_rsid = Tru.sid
Where (act.p_created_time Between @startdate And @enddate)
Group By Rdn, Name_last, Name_first;

JimL

Select Typ.p_description, Count(*) 'file Count', Sum(version_size) 'total Size'
From Imanage.doc_version Ver
Join Imanage.doc_document Doc On Ver.document_rsid = Doc.sid
Join Imanage.p_con_document_activity_log Act On Act.p_item_rsid = Doc.sid
Join Imanage.p_mda_activity_type Typ On Typ.p_sid = Act.p_activity_type_rsid
Join Imanage.dit_trustee Tru On Act.p_doc_actor_rsid = Tru.sid
Where (act.p_created_time Between @startdate And @enddate)
Group By Typ.p_description

JimL

Select Rdn, Name_last, Name_first, Typ.p_description, Count(*) 'file Count', Sum(version_size) 'total Size'
From Imanage.doc_version Ver
Join Imanage.doc_document Doc On Ver.document_rsid = Doc.sid
Join Imanage.p_con_document_activity_log Act On Act.p_item_rsid = Doc.sid
Join Imanage.p_mda_activity_type Typ On Typ.p_sid = Act.p_activity_type_rsid
Join Imanage.dit_trustee Tru On Act.p_doc_actor_rsid = Tru.sid
Where (act.p_created_time Between @startdate And @enddate)
Group By Rdn, Name_last, Name_first, Typ.p_description

nbwoven

Another simple one for getting total no of documents

:
>select count (*) from doc_document where p_datasource='document'