Scroll

AskiaField: Statistic_SupervisorActions table

AskiaField: Statistic_SupervisorActions table

Follow

Audit on supervisor actions

 


New way of logging supervisor actions. A lot of user actions will be logged in: statistics database – Statistic_SupervisorActions. 
The data logged can be accessed in SQL server at first. Later this should 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
    • System = 0,
    • Cca = 1,
    • Supervisor = 2,
    • Api = 3,
    • Cati = 4,
    • Capi = 5,
    • SpeechService = 6,
    • JobLink = 7, //source ID = instance
    • RecordingManagementService = 8
  • 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)

Unknown = -1,
OutboundGroup = 0,
InboundGroup = 1,
Agent = 2,
Location = 3,
Restriction = 4,
IVRProject = 5,
Route = 6,
Task = 7,
SurveyTask = 71,
VBScriptTask = 72,
CTScriptTask = 73,
EmailBox = 8,
Web = 9,
WebChat = 91,
WebCallMe = 92,
List = 10,
Skill = 11,
Alarm = 12,
Recording = 13,
InboundNumber = 14,
GeneralAlarm = 16,
Pause = 17,
Module = 18,
GeneralSetting = 24,
InboundBlackList = 25,
Sla = 26,
PredefinedMessage = 27,
MailingOptions = 28,
CapiGroup = 29,
Report = 30,
ReportFieldType = 31,
LogFile = 32,
CodingGroup = 33,
AgentSetting = 34,
Workspace = 35,
TimezoneMatchingSet = 36,
CTArchitectSetting = 37,
SpeechKeywordGroup = 38,
JobLink = 40,
SpeechJobLink = 41,
WebConnection = 42,
JobSchedule = 43,
Job = 100,
SpeechJob = 101,
ListJobEmail = 110,
ListJobUpdateData = 111,
ListJobSwitchContactMode = 112

  • 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
None = 0,
Login = 1,
Logout = 2,
ChangePassword = 3,
CreateObject = 10,
UpdateObject = 11,
DeleteObject = 12,
RunReport = 13,
FindCall = 14,
FindContact = 15,
SendMessage = 16,
ListenInCall = 17,
RecordCall = 18,
PlayRecording = 19,
GetRecording = 20,
DeleteRecording = 21,
AcknowledgeAlarm = 22,
DeleteAlarm = 23,
ReloadAllProjects = 23,
DownloadFile = 25,
UploadFile = 26,
ViewLogFile = 27,
GetCallDetails = 28,
GetCallAnnotations = 29,
DisconnectWebConnection = 30,
ImportTaskPackage = 31,
StopReport = 32,

Custom = 99,

//100 - 199 : agent
Agent_Disconnect = 100,
Agent_ListenIn = 101,
Agent_SeeIn = 102,
Agent_ViewSoftPhoneTrace = 103,
Agent_AddMembership = 104,
Agent_RemoveMembership = 105,
Agent_ActivateMembership = 106,
Agent_DeactivateMembership = 107,
Agent_CreateAuthenticationToken = 108,
Agent_DeleteAuthenticationToken = 109,
Agent_UpdateAuthenticationToken = 110,

//200 - 299 : task
Task_UpdateTask = 200,
Task_CreatePackage = 201,
Task_FindInterviews = 202,
Task_GetInterviewsData = 203,
Task_GetInterviewData = 204,
Task_UpdateInterview = 205,
Task_SetInterviewStatus = 206,
Task_DeleteInterview = 207,
Task_DeleteInterviews = 208,
Task_Export = 209,
Task_Reload = 210,
Task_AddWebConnection = 211,
Task_RemoveWebConnection = 212,
Task_SetWebConnectionOnlineStatus = 213,
Task_AddList = 214,
Task_RemoveList = 215,
Task_Quota_Update = 217

//300 - 399 : list
List_StartTelephony = 300,
List_StopTelephony = 301,
List_StartMailing = 302,
List_StopMailing = 303,
List_SwitchContactsFromWebToTelephony = 304,
List_Export = 305,
List_UpdateWithExternalData = 306,
List_ContactSetField = 307,
List_ContactSetPriority = 307,
List_ContactSetTimezone = 307,
List_ContactSetCallNow = 308,
List_ContactRecover = 309,
List_ContactResetInterview = 310,
List_ContactChangeMode = 311,
List_ContactSetAppointment = 312,
List_ContactSetAppointmentAgent = 312,
List_SendTestEmail = 313,

//400 - 499 : groups
Group_AddAgent = 400,
Group_RemoveAgent = 401,
Group_ActivateAgent = 402,
Group_DeactivateAgent = 403,

//500 - 599 : reports
Report_GetWorkingCopy = 500,
Report_Update = 501,

//600 - 699 : job links
JobLink_Start = 600,
JobLink_Stop = 601

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)
Have more questions? Submit a request

Comments