Status-change log

Discussion in '3CX Phone System - General' started by Nikoolaj, Mar 7, 2018.

Thread Status:
Not open for further replies.
  1. Nikoolaj

    Joined:
    Nov 7, 2014
    Messages:
    2
    Likes Received:
    1
    Hello,

    I'm looking for som sort of logging, on extensions change of status (away, dnd). But I cannot seem to find anything in either 3CX eventlog or activitylog, I've been doing a little bit of searching in the database_single through pgAdmin, but this is like finding a need in a haystack.

    Is this possible in any way, to determine status changes with timestamps?

    Best regards
     
  2. vizualpro

    Joined:
    Jul 9, 2016
    Messages:
    81
    Likes Received:
    13
    I'd love to see what you come up with here. Maybe @voiptoys can help?
     
  3. voiptoys

    voiptoys Member

    Joined:
    Feb 13, 2013
    Messages:
    493
    Likes Received:
    81
    Take a look in callcent_ag_queuestatus. This will show you when an agent logged in / out of queues. There isn't a log that I'm aware of that lists other statuses. I do have an agent status application about 80% complete that will allow you to create an unlimited number of statuses and based on the custom status you choose, it will perform the actions you specify for each status (like logging out of a queue). We log all these status changes. The intent is to also build a wallboard that displays each agent's current status, as well as summary information showing how much time, and how often, an agent has been in each status. This project is on hold, however, while we work on porting our applications to Linux.

    I do caution you Nikoolaj about using PGAdmin on a production server. The simple act of just clicking on a table places locks on the records within the table and obviously could crash a running system. As you have undoubtedly heard, 3CX does not support directly accessing the data in the PostgreSQL database, for this very reason. Perhaps a safer approach would be to use our Exporter tool to get the data in SQL, then you can play with the data (in SQL) without impacting your production system.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 voiptoys, Mar 7, 2018
    Last edited: Mar 7, 2018
    vizualpro likes this.
Thread Status:
Not open for further replies.