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

[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.

[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.