Auditing application usage

Interviewer - Server Admin > UNICOM Intelligence Interviewer - Server Admin architecture > UNICOM Intelligence Interviewer - Server Admin audit trail > 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.