Names of tables of postgresql

[toniavaya]

Hello, I want to get the calls and times of queue, the agents are connected and the all calls for topic.
Someone know what table of database I need? I created a external program and I need to get information from avaya contact center.
Thanks

 

[janni78]

I don't understand what you actually trying to do, but if you want statistics there's the TR database.

"Trying is the first step to failure..." - Homer

 

[toniavaya]

I want to export from database of contact center the information of queue, agents connected and the calls for topic. I don't see in TR database any information of users

 

[janni78]

Do you want real-time data or historical?

"Trying is the first step to failure..." - Homer

 

[toniavaya]

I want real-time of connected agents, the queue of calls of all topics and historical of total calls answered of all topics.

 

[janni78]

If you want real-time data you could just use the Web Wallboard.
If you wanna get the data into some other system you would need to integrate through Web Services.

Only historical is stored in the database.

Theoretically you can see when agents login/logout/break and call data from the TR database but it wouldn't be good to use that for real-time presentation.

"Trying is the first step to failure..." - Homer

 

[toniavaya]

I have the licence of wallboard, I enter to

https://192.168.5.243:28443/WallboardBroker/EnterWallboard.html

but I need to show another information of other services at the same screen, and the wallboard only can show avaya information. I want to connect avaya information to a program similar to

https://grafana.com/

The wallboard can't show information of other sources.
What is Web Services? I can export avaya information from this? Thanks a lot

edit:I get the agents status from TR database
I only need now the list of calls out/in and the queue of calls.

 

[toniavaya]

I see in wallboard, the information i need to export is: totNNewShift, totNOutCCShift and NQueued.
There are a any form to export this information or read from external program?
Thanks

 

[janni78]

You need to build an application that connects to the Web Services and supplies that information for the the other presentation application.

"Trying is the first step to failure..." - Homer