Supervisor logging

From version 5.4, many supervisor actions are logged in the statistics database Statistic_SupervisorActions. This data can be viewed in SQL Server. At a future date, a viewer will be provided via the API or in the Supervisor module. A record in the table is created for each recorded supervisor action.

The following fields are stored in the database:

• StatSupervisorAction: This number is a unique number automatically assigned to each log record.
• SupervisorID:  The ID of the that carried out the action being logged.
• Source: A number that identifies the application source, as follows:
  • 0: System
  • 1: CCA
  • 2: Supervisor
  • 3: API
  • 4: CATI
  • 5: CAPI
  • 6: SpeechService
  • 7: JobLink (the SourceID column indicates the instance)
• SourceID: provides further information (supplemental to Source, above) about the application source, as follows:
  • If Source indicates API (3), then SourceID indicates the value in statistics_SessionAPI.SessionID
  • If Source indicates CATI (4), then SourceID indicates the value in statistic_Session.SessionID
  • If Source indicates JobLink (7), then SourceID indicates the JobLinkID
• ObjectType: indicates the type of the main object where the action took place.
• ObjectId: the ID of the main object where the action took place.
• TimeUTC: the time and date at which the action took place.
• Action: Indicates the action type, as a number. The following ranges indicate the action category:
  • 000 - 099: Global actions & shared actions
  • 100 - 199: Agent
  • 200 - 299: Task
  • 300 - 399: List
  • 400 - 499: Groups
  • 500 - 599: Reports
  • 600 - 699: Job links

ActionData: XML-based additional data, depending on the action.