application access usage statistics ?

[LWagner]

In CMOD 2.1, it was easy to query the audit table to produce statistics on report usage.


In CMOD 8.4.0.3, I can look at usage by user, but I can not get the application totals without looking at the document connected to the msg 66 record.  Is there a better way ?

[Nolan]

I know this is an old post but I am looking for reporting usage of reports and dumping the system log is the only option I found.  Is there anything anyone else has done to steam line this task?  Getting all msg 66 from system log, parse out AG and APP ID join to app table and get counts is very slow process to do historically.

Thanks.

J.

[jeffs42885]

Ive done this before.

Query the System log folder (Apologize for not knowing the exact query):

/usr/lpp/ars/bin/arsdoc get -h archive -u admin  -f "System Log" -i "WHERE time_stamp between 'use a range in 5 digit arsdate format' and msg_num = '66' " -agcNv -o Systemlog.out

[Nolan]

Thank you.  I will give that a try.

Cheers

J.