1212pro
asked on
Shoretel SQL query in Excel
ALL,
I need to connect to my shoretel database to extract data that is not in the canned reports namely the call notes field. I'm a complete novice at SQL and need instructions on connecting to the SQL database through Excel so I can dump and sort the data.
Shoretel version 12.2
Communicator version 17+
Excel 2010
Thank you
I need to connect to my shoretel database to extract data that is not in the canned reports namely the call notes field. I'm a complete novice at SQL and need instructions on connecting to the SQL database through Excel so I can dump and sort the data.
Shoretel version 12.2
Communicator version 17+
Excel 2010
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Damn, beat me to it plusone3055 :)
sowie I need the points.. been a slow start this month ;)
Pfft points, who needs them :D
I vote all points to +1 :)
I vote all points to +1 :)
<-- wife, daughter, two puppies, cant afford the monthly fee hence why i need the points lol
ASKER
Hello everyone,
Thank you for the quick response. I was able to connect to the database with your help and wanted to add some additional info that will help other people with this issue.
SERVER=<The ShoreTel Director server IP address>
DATABASE=shorewarecdr
USER=st_cdrreport
PASSWORD=passwordcdrreport
PORT=4309 (Omit this to use default port if your ShoreTel version is prior to 10.2)
(If using the archive DB, substitute server and database of the archive) - See more at: http://blog.shoretel.com/2012/12/shoretel-professional-services-custom-reports/#sthash.wZs1X8LW.dpuf
Now that I'm connected in the MySQL browser how would I make a report or query ? I see the field I need information from SELECT c.`CallNote` FROM shorewarecdr.`call` c; Do I need to pick different fields like start and end times? Do I need to use Keys to link tables as in Crystal Reports?
Thank you
Thank you for the quick response. I was able to connect to the database with your help and wanted to add some additional info that will help other people with this issue.
SERVER=<The ShoreTel Director server IP address>
DATABASE=shorewarecdr
USER=st_cdrreport
PASSWORD=passwordcdrreport
PORT=4309 (Omit this to use default port if your ShoreTel version is prior to 10.2)
(If using the archive DB, substitute server and database of the archive) - See more at: http://blog.shoretel.com/2012/12/shoretel-professional-services-custom-reports/#sthash.wZs1X8LW.dpuf
Now that I'm connected in the MySQL browser how would I make a report or query ? I see the field I need information from SELECT c.`CallNote` FROM shorewarecdr.`call` c; Do I need to pick different fields like start and end times? Do I need to use Keys to link tables as in Crystal Reports?
Thank you
It all depends on what information you need.. We will be glad to help with that. please provide an example sheet and the data that you would like to get :)
also it is customary to award points for the original question asked, then ask another question. that way those that answered the first question are not denied points becuase someone answers something additional you asked but not the original thread that started the question :)
also it is customary to award points for the original question asked, then ask another question. that way those that answered the first question are not denied points becuase someone answers something additional you asked but not the original thread that started the question :)
if you can give us some sample data and what data/form your looking for we can get to work on that.. start another question and we can handle that for you :)
for excel 2010