AskiaField: Statistic_SupervisorActions table
Audit on supervisor actions
There is now a way of logging supervisor actions. A lot of user actions will be logged in the statistics database – Statistic_SupervisorActions.
The data logged can be accessed in SQL server. Later on this will be followed by API access and possible a view in Supervisor.
Database format:
- StatSupervisorAction (Auto number)
- SupervisorID (User ID that did the action)
- Source (Number to define the application source)
- 0 = System
- 1 = CCA
- 2 = Supervisor
- 3 = API
- 4 = CATI
- 5 = CAPI
- 6 = SpeechService
- 7 = JobLink
- 8 = RecordingManagementService
- 9 = MessageQueue
- SourceID
- Source = API -> statistics_SessionAPI.SessionID
- Source = Supervisor -> statistics_SessionSupervisor.SessionID
- Source = JobLink -> JobLinkID
- Source = CATI -> statistic_Session.SessionID
-
ObjectType (type of the main object where the action took place)
-1 = Unknown
0 = OutboundGroup
1 = InboundGroup
2 = Agent
3 = Location
4 = Restriction
5 = IVRProject
6 = Route
7 = Task
8 = EmailBox
9 = Web
10 = List
11 = Skill
12 = Alarm
13 = Recording
14 = InboundNumber
15 = GeneralAlarm
16 = Pause
17 = Module
24 = GeneralSetting
25 = InboundBlackList
26 = SLA
27 = PredefinedMessage
28 = MailingOptions
29 = CapiGroup
30 = Report
31 = ReportFieldType
32 = LogFile
33 = CodingGroup
34 = AgentSetting
35 = Workspace
36 = TimezoneMatchingSet
37 = CTArchitectSetting
38 = SpeechKeywordGroup
40 = JobLink
41 = SpeechJobLink
42 = WebConnection
43 = JobSchedule
71 = SurveyTask
72 = VBScriptTask
73 = CTScriptTask
91 = WebChat
92 = WebCallMe
100 = Job
101 = SpeechJob
110 = ListJobEmail
111 = ListJobUpdateData
112 = ListJobSwitchContactMode
- ObjectId (Main object where the action took place)
- TimeUTC (Time when the action took place)
- Action (Change properties / delete / <action depending on object type>)
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 extra data, depending on the action)