Livelink usage

David_Turpie

Hi allI am trying to find a report that will give me a count and list of names of users who have accessed/used our Livelink implementation.I know there is a default report "Explorer Professional Users Since [Date]" but this does not take into consideration users accessing Livelink through the web.Has anyone else done this already or have ideas on how we might do this?Thanks.David.

jamespate

Create a LiveReport like this for for user LOGINs in the last 7 days:SELECT KUAF.NAME USERNAME,COUNT(*) LOGINSFROM KUAF,DAUDITWHERE DAUDIT.USERID=KUAF.IDAND DAUDIT.AUDITDATE>SYSDATE-7AND DAUDIT.EVENT='LOGIN'GROUP BY KUAF.NAMEORDER BY KUAF.NAMEThis is for Oracle 8i and Livelink 9.1 SP3