Querying Service Desk DB through Excel

Hi there,

I need to query the service desk DB from Excel so that to retrieve the data and create some custom charts.

I copied and pasted the query of the report to the SQL query in excel. But I get the error that says:

You have an error in your SQL syntax, check the manual that corresponds to your MySQL server version for the right syntax to use near '(wo.CREATEDTIME) FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WOR' at line 1

According to the local support for Service Desk, I have to replace the functions with those that are same in MySQL. I am not sure which one to change and how to look for the replacement.

Actually, the whole idea behind this is to have a Sharepoint Server query the ServiceDesk DB and generate report and post it on kind of a dashboard. This should happen automatically and on a daily basis.

I would appreciate any help here.

Regards