Query Audit Log LiveReport

Hi Guys,We have a requirement where only the technical Livelink team can have access to the Admin Pages and no one else. At present we have some super users wanting to access the Query Audit Log section on the Admin Pages, but we dont want to give them the Admin Pages Password. So I have 2 questions:1. Is there a way for the users to access this page without knowing the Admin Pages password (or seeing the Admin Home link at bottom of page)2. Is there a Livereport I can run to do what this page does?Cheers.

Find more posts tagged with

Comments

Nair_Krishnankutty_(nairkrishnankutty_-_(deleted))

The table is DAUDITNEW if you are on version 9.5 or above or DAUDIT if prior.If it is oracle you can do a describe schemaSelect distinct(auditstr) from dauditnew a ;That should give you the events that are being audited.Here is a ORACLE query that one can write to know about 'Login' in the system 30 days form when it is executed.select * from dauditnew a where upper(auditstr)='LOGIN' and trunc(auditdate) < trunc(sysdate -30)If you were interested in a dataid you just have to put a filter based on dataid*****Oscript****Llivelink was written by a very talented architchturally sound understanding lot.Each objects can have commands showing up on them differently from what is already supplied by OT.So in one of my implementations I was asked to put a extra command to a folder object and it should show up only if the executing user was part of a special group.You could perhaps emulate the same techniques.See if you need pointers for this,or post in the dev/builder sections

Sumartini_Krisman

Hi - I was wondering if you ever got the answers for #2? I have to custom a report for Support Team to audit activities only on a group of people. Thanks for any info you can share.

Lindsay_Davies

Message from Lindsay Davies <ldavies@opentext.com> via eLink

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

Hi Krisman,

You would need to expand the group to determine the IDs of the users in the group.

For a given group (in table KUAF) , look up the members by joining to table KUAFChildren.

This gets more complex if you know the group could contain nested groups.

However, there are lots of examples of determining the total membership - search through the discussion forum.

Bear in mind that the techniques available differ according to your database - Oracle or SQL server.

Then use that list of IDs as one of your filters on DAuditNew.

I expect you have lots of other requirements that you have not mentioned.

One way to get more help is to do the same sort of thing through the Admin pages and look at the connect logs to see what statements were actually executed.

Good luck.

Lindsay

From: eLink Discussion: Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 2011 January 05, Wed 13:47
To: eLink Recipient
Subject: Livereport for Query audit Log

Livereport for Query audit Log		Posted by skrisman@visteon.com (Sumartini, Krisman) on 2011/01/05 08:41
In reply to: Query Audit Log LiveReport		Posted by disabled24 (DISABLED, DISABLED) on 2007/07/05 05:44

Hi - I was wondering if you ever got the answers for #2? I have to custom a report for Support Team to audit activities only on a group of people. Thanks for any info you can share.