Genesys Engage on-premises

Discussion Thread View
  • 1.  Anyone ever built SQL to select info from Pulse realtime DB?

    Posted 09-23-2021 15:51

    Anyone ever built SQL to select info from Pulse realtime DB? I need to lookup Pulse DB to search for Agents in NotReady state for more than 4 hours.
    Regards,

    Ighor


    #Reporting/Analytics

    ------------------------------
    Ighor Toth
    ------------------------------


  • 2.  RE: Anyone ever built SQL to select info from Pulse realtime DB?

    GCAP Member
    Posted 09-24-2021 02:33
    Hi Igor, the Pulse DB Schema only contains metadata (widget definitions etc) not the statistics themselves.  The Pulse Collector will subscribe to Stat server to get these statistics based on these definitions and the saves these snapshots to file system to make them available to Pulse.

    If you wanted to use SQL, then your best bet would be to query ICON database, probably the GS_AGENT_STAT_WM table, although I cant actually confirm as we dont populate this table in our environment.

    Depending on what your intending to do with this 4 hour thing though, you may be better off using the SDKs to develop directly against Stat Server or if you have Genesys Mobile Engagement in your environment using the Stat Service API

    ------------------------------
    Jason McLennan
    Commonwealth Bank of Australia
    ------------------------------



  • 3.  RE: Anyone ever built SQL to select info from Pulse realtime DB?

    GENESYS
    Posted 10-05-2021 23:38
    Hi Igor,

    The simplest way to get this is to have stats server write this data direct into its own status database.  This would of course need to be enabled if not already configured.
    Refer to stats server option "status-table"

    Andrew

    ------------------------------
    Andrew Soroka
    Genesys - Employees
    ------------------------------



  • 4.  RE: Anyone ever built SQL to select info from Pulse realtime DB?

    GCAP Member
    Posted 10-11-2021 11:25
    Edited by Parthiban Ganesan 10-11-2021 11:26
    You could also use Pulse advanced alerts to send an email when the 4 hour threshold has been reached for NotReady.

    ICON or GIM (SM_RES_STATE_FACT) should work also if you want to schedule a query.

    Regards

    Colin