Welcome to

Welcome to!

This site was created as a place to share stories, tips, and troubleshooting help with ShoreTel/Mitel systems. ShoreTel/Mitel is obviously the MOST exciting VoiP platform on the market right now, and we realized there was no centralized place to discuss this platform, but now there is. Please feel free to join and share your experiences.

Please Note: This site IS NOT owned, funded, or managed by ShoreTel/Mitel, Inc. although you may find ShoreTel/Mitel employees sharing there experiences and expertise. If you would like more information on ShoreTel/Mitel systems, contact BTX at [email protected]

As always please support the advertisers that help support our site.

Thank You,
See more
See less
  • Filter
  • Time
  • Show
Clear All
new posts

  • Workgroup / Agent Reporting

    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.


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


    • #3
      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?


      • #4
        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.


        • #5
          Not Intended or Not Accessable.

          Is there a way I can access this data?


          • #6
            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.


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


              • #8
                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!