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; } } }

Need LiveReport to Audit Documents in a Folder

18User3_(Delete)_2154966

Using Livelink 9.1 SP2 (Oracle)Is it possible to:write a report that will show a folder's contents and who has viewed or fetched each document in the folder (need a list by folder, by document and who has viewed/fetched each document with date)it's basically running an audit for each document without having to do it one at a timeIf possible or anyone has done this, please provide the specific way to set this up. Thanks,

Find more posts tagged with

Comments

Timo_Schrama_(citeeuser1_-_(deleted))

I've made a LiveReport showing Object and number of views/fetches in a list. I'm using SQL and Livelink 9.2, so things will probably be a little different on your setup.It goes like:select dtree.gif, dtree.permid, dtree.subtype, dtree.name, dtree.dataid, count(*) "Aantal" from dtree, daudit where dtree.parentid=%1 and dtree.dataid=daudit.dataid and (daudit.event='VIEW' or daudit.event='FETCH') group by dtree.gif, dtree.permid, dtree.subtype, dtree.name, dtree.dataid UNION select gif, permid, subtype, name, dataid, ' ' from dtree where dataid not in (select dataid from daudit where daudit.event='VIEW' or daudit.event='FETCH') and dtree.parentid=%1 group by name, gif, permid, subtype, dataidLet me know if this works for you!Greetings,Timo Schrama

Victoria_Freihofer_(rgsinc01admin_-_(deleted))

Message from Olson, Leonard <<A HREF="mailto:len.olson@rgsinc.com">len.olson@rgsinc.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

How is %1 configured? Is it a user input - type container? Also, if this report is available to your general user population I'd recommend including a "filter by permissions" parameter, which you could do as a %2 in your WHERE clause. Otherwise, a user could potentially discover the existence of documents which they have no permission to see.

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, October 24, 2003 8:19
To: eLink Recipient

I've made a LiveReport showing Object and number of views/fetches in a list.		Posted by CiteeUser1 (Schrama, Timo) on 10/24/2003 08:14 AM
In reply to: Need LiveReport to Audit Documents in a Folder		Posted by 18User3 on 08/11/2003 04:07 PM

I've made a LiveReport showing Object and number of views/fetches in a list.

I'm using SQL and Livelink 9.2, so things will probably be a little different on your setup.

It goes like:
select dtree.gif, dtree.permid, dtree.subtype, dtree.name, dtree.dataid, count(*) "Aantal" from dtree, daudit where dtree.parentid=%1 and dtree.dataid=daudit.dataid and (daudit.event='VIEW' or daudit.event='FETCH') group by dtree.gif, dtree.permid, dtree.subtype, dtree.name, dtree.dataid UNION select gif, permid, subtype, name, dataid, ' ' from dtree where dataid not in (select dataid from daudit where daudit.event='VIEW' or daudit.event='FETCH') and dtree.parentid=%1 group by name, gif, permid, subtype, dataid

Let me know if this works for you!

Greetings,

Timo Schrama

Dave_Ebels_(jocoadmin_-_(deleted))

I use this to count the number of 'hits' (views & fetches) by user in a folder structure. This could easily be expanded to include other information.Auto Live reportInput type Number (User input 1)SQLselect name, count(*) "number of hits" from daudit,kuaf where userid=id and (EVENT='VIEW' or EVENT='FETCH') and dataid in (select dataid from dtree start with dataid in (%1) connect by prior dataid=parentid) group by name order by count(*)descYour return here will be a list of users and the number of views or fetches each user has.Dave EbelsJohnson Controlsdave.j.ebels@jci.com

Steve_McDonough

I use the following report to display the information that you are looking for:SELECT COUNT (*) "Times", DA.DNAME "Document", DA.EVENT "Event", K.LASTNAME + ', ' + K.FIRSTNAME "Accessed By", DA.AUDITDATE "Date Accessed" FROM DAUDIT DA, KUAF K, DTREE WHERE DA.DATAID IN (SELECT DATAID FROM DTREE WHERE PARENTID = %2) AND DA.EVENT IN ('FETCH', 'VIEW') AND DA.USERID = K.ID AND DA.DATAID = DTREE.DATAID AND DA.DATAID <> 4607 AND K.ID <> 1000 AND %1 AND %3 GROUP BY DA.DNAME, DA.EVENT, K.LASTNAME + ', ' + K.FIRSTNAME, DA.AUDITDATE ORDER BY DA.AUDITDATE DESCInput Type is "Container" Param %1 = "Filter Document"Param %2 = "User Input 1"Param %3 = "Filter Permissions"Report Format = "Auto LiveReport"Our database is MSSQL but I don't think that there is anything in the syntax that would not work in Oracle.Hope that this helps!Leon