Shoretel SQL query in Excel

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.

You will probably need a mySql connector for excel + addin, have a look at these two articles, first to setup the connector and connect to the database, second how to query. You will also need to know the database credentials & db servername

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

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?

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 :)

Featured Post

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster.
To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB.
To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…