Sql Queries.

[Gymratz]

Good Morning!
I would like to be able to connect to the SQL database that runs ShoreTel but I am not sure how to connect to it!
I am used to working with SQL Server 2003/2005, and not MySQL. Any instructions on tools I can use to connect and what default information should be used to log into it?

I would like to look around the system and find out what custom reports I can write (a very simple list of users/ext/did's for instance would be nice, for example).

Thanks,

[Gnakas]

Hi -

You can go here:

MySQL :: MySQL GUI Tools Downloads

to get the Admin tools.

If you are just palnning on administering the database nothing more will be needed. However, if you plan on running reports against the CDR database. You may need to download the ODBC connector for your O/S here:

MySQL :: MySQL Connector/ODBC 5.1 Downloads

Hope that helps.

Grant

[mutilities]

I use SQLyog Community Edition to connect to all of my Mysql Servers. http://www.webyog.com.