[{TableOfContents }]
!!!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|]:This field identifies the session by a unique number.
;[Session Source|SESSION_SOURCE]:This field is used to display the program that is the source of the session.
;[Employee #|PERSON_CODE]:This field identifies the employee who accessed the database.
;[User|USER_NAME]:This field identifies the user who accessed the database.
;[Log In|LOG_IN_TIMESTAMP]:The start time of the session is indicated in this field.
;[Log Out|LOG_OUT_TIMESTAMP]:The end time of the session is indicated in this field.

[CLEANUP]

[{If var='loginstatus' contains 'authenticated'
----
![Notes|Edit:Internal.DMSA] 	
[{InsertPage page='Internal.DMSA' default='Click to create a new notes page'}]