Workgroup / Agent Reporting

[DFrench73]

Anybody know where / which table(s) holds the "Selected Agents" for a Workgroup. We use Top Down for routing and Management would like a report created (Crystal) for displaying the flow for each Workgroup.

Thanks..

[Palitto Consulting]

Agent status should be in either the Users table or the WorkgroupAgents table. The association of users to workgroups is in the WorkgroupAgents table.

[DFrench73]

OK Then....

Lets ask the question this way...

Via Crystal or SQL Query (using st_cdrreport and root). I do not see a Agent or WorkGroupAgents table. Are these kept in a different schema /db?

[Palitto Consulting]

These are in ShoreTel's configuration database, which is not intended to be accessible to outside users. This information is not made available directly in CDR.

[DFrench73]

Not Intended or Not Accessable.

Is there a way I can access this data?

[Palitto Consulting]

On ShoreTel 8 and over, this is in a mysql database named shoreware. Before 8 it is in an Access database in the Shoreline Data folder.

You can reach the mysql database by logging in as root/shorewaredba from the machine itself.

[DFrench73]

We are still on 7, found the folder... thank you..

[catatonique]

Mr French,
My company is developing a Call Accounting system that connects to the Shoretel SQL database and reports workgroup and individual call activity, as well as dropped calls. This application is a native win32 Dot Net binary that runs on Windows XP. I need some beta testers right now.

PM me to get on the beta test wagon!