DMSA
Back to current versionRestore this version

VIEW DAILY DATABASE SESSION AUDITS#

The View Daily Database Session Audits (DMSA) allows you to view database sessions that occurred on a specific day.

Data for the 'View Instance Alerts By Day' screen is maintained on the P2K_AM_SESSION_AUDITS table.

Session ID
Session Source
Employee #
User
Log In
Log Out

Timestam
This field indicates the time of the alert.
Employee #
The employee to whom the alert was sent will be indicated in this field.
Function Name
The function on which the event occurred will be listed in this field.
Event Text
The actual wording of the alert will be listed here.
Exception Info
Further details of the exception that triggered the alert will be shown in this field.