Developer Documentation Library > Interviewer - Server Admin > UNICOM Intelligence Interviewer - Server Admin architecture > UNICOM Intelligence Interviewer - Server Admin audit trail > Auditing application usage
 
Auditing application usage
The ApplicationSession and ApplicationSessionHistory tables record information about activity usage and are defined as follows:
CREATE TABLE (
ApplicationSessionId nvarchar(128) NOT NULL
SessionId nvarchar(128) NOT NULL
UserName nvarchar(128) NOT NULL
ApplicationId nvarchar(128) NOT NULL
ProjectId nvarchar(128) NULL
ApplicationSessionStart datetime(8) NOT NULL
LastUpdated datetime(8) NOT NULL ApplicationSession table only
ApplicationSessionEnd datetime(8) NOT NULL ApplicationSessionHistory table only
PrimaryDPMServer nvarchar(256) NOT NULL
CustomerAccountID uniqueidentifier NOT NULL
)
Columns
ApplicationSessionId
The ID for this activity session.
SessionId
The ID for the user's UNICOM Intelligence Interviewer - Server Admin session. This is used to link to records in the UserSession table.
UserName
The user's login name.
ApplicationId
The internal name of the activity (for example, launcher rather than UNICOM Intelligence Interviewer - Server Admin).
ProjectId
The name of the project on which the activity was run. Activities that do not run on projects, such as User Administration, have this column blank.
ApplicationSessionStart
The date and time that the user started the activity.
LastUpdated
The date and time that the record was last updated (records are updated periodically while the user is working).
ApplicationSessionEnd
The date and time that the user closed the activity.
PrimaryDPMServer
The name of the primary DPM server in which the activity was run.
CustomerAccountID
The ID of customer account in which the activity was run.
Flowchart showing interaction of session monitoring object model with the process of logging in and running activities
This flowchart shows the steps that a user takes to log in and run an activity and the points at which the session monitoring object modelobtains information for the audit trail. Boxes that contain "UNICOM Intelligence Interviewer - Server Admin" show when auditing for the UNICOM Intelligence Interviewer - Server Admin application itself starts and stops, as opposed to auditing of the activity the user is running.
This graphic is described in the surrounding text.
See also
UNICOM Intelligence Interviewer - Server Admin audit trail
See also
UNICOM Intelligence Interviewer - Server Admin audit trail