We have MITEL as our office phone system and we have default reports that come with it. I have access to the Mitel SQL database and have created a few custom reports from that database using SQL Server. Currently, I have been tasked with creating a report for the IVR Stats but I can't seem to find any table that has specific fields relating to the IVR information.
Does anyone know which tables in the Mitel Database can be used to pull up the IVR stats?
I'm looking to create a report which gives data like the number of times the system hung up, the user hung up, number of times they were transferred to the agent, any payments made through the IVR system, etc.
Can anyone please help? Thanks in advance.