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
------------------------------
Original Message:
Sent: 09-23-2021 15:51
From: Ighor Toth
Subject: Anyone ever built SQL to select info from Pulse realtime DB?
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
------------------------------