Need report Userid/loginid ,Department,AuditDate ,file/doc name, AUDITSTR, DATAID/ObjID.

Ravindra_Pamuri

Dear Team

can anyone help me with the below queried query.Using CS10.5 ,DB :Oracle

Need query

Userid/loginid ,Department,AuditDate ,file/doc name,foldername of the document, AUDITSTR, DATAID/ObjID.

where dataid/objid would be dynamic in the query

please provide me a query related to above if not exact.

Thanks in advance

Regards

Ravindra

Sample.xls

Colin_Schmidt

Are you wanting all Users listed having accessed any document? 

 

select k.id, k.name, kg.name “Dept”, da.auditdate, da.dataid, dt.name “Document”, dtp.name “ParentFolder”

from kuaf k

                join dauditnew da on k.id = da.performerid and da.auditid in (1, 2, 3, 4, 5, 6, 11, 14, 220, 221, 636001, 636002, 636003)

                join kuaf kg on k.groupid = kg.id

                join dtree dt on da.dataid = dt.dataid

                join dtree dtp on dt.parentid = dtp.dataid

where k.type = 0 and k.deleted = 0

 

Colin J. Schmidt

 

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, July 04, 2017 9:59 AM
To: eLink Recipient <devnull@elinkkc.opentext.com>
Subject: Need report Userid/loginid ,Department,AuditDate ,file/doc name, AUDITSTR, DATAID/ObjID.

 

Need report Userid/loginid ,Department,AuditDate ,file/doc name, AUDITSTR, DATAID/ObjID.

Posted by Pamuri, Ravindra On 07/04/2017 09:49 AM

 

Dear Team can anyone help me with the below queried query.Using CS10.5 ,DB :Oracle Need query Userid/loginid ,Department,AuditDate ,file/doc name,foldername of the document, AUDITSTR, DATAID/ObjID. where dataid/objid would be dynamic in the query please provide me a query related to above if not exact. Thanks in advance Regards Ravindra

 

Attachment Links:

Sample Log file for larger investigation.xls (25 KB)

---

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center CS16

 

---

The information contained in this e-mail is confidential and/or proprietary to Capital One and/or its affiliates and may only be used solely in performance of work or services for Capital One. The information transmitted herewith is intended only for use by the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.