Is there any way where I can find out if the user has viewed a specific report?

Previous topic - Next topic

iravjani

I have a DB2 installed on a AIX machine and CMOD ver8.5 too. My client requires a report or a query to run on DB2 through which they can extract user generated event logs and store it in a db table.

They want to develop a report in which they want to find out that how many users have viewed a specific report on a required date and time?

Thanks!

johnnoel

Have you turned on Message Loggin for the specific Application Group the report is associated with? Right click the App Group and go to Message Logging Tab.

jeffs42885

I recently did a project where I captured the ENTIRE system log for a certain time

Then I used sql queries like WHERE MSG_NUM = 66 and MSG_TEXT = REPORT1234 etc..Once this was done, I had db2 put it in a csv file, I wrote a quick macro, and boom...had what I was looking for. Not sure if this is what your asking but I am sure its probably a step in the right direction!!

Justin Derrick

You should be able to create a named query that produces the information you're looking for -- you can issue that query daily (by hand, or with "arsdoc query") and deliver it via (eMail?) from there.

From your description, this should satisfy most of your client's requirements.

-JD.
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Webinars:  https://CMOD.Training/
IBM CMOD Professional Services: https://CMOD.cloud

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

demaya

Or you can use arslog where the events incl. indexes (Severity, Message, User, MsgID,...) are directly given to arslog and you can do whatever you want (email it, write it to a file, store to a dif. db and so on).

I save Err + Warning Messages and send them every 10 Minutes to the admins.