Extract database data

JIAM · 01:08 AM

Hello,

Since Support Suite has no reporting options I would like to do my own reports in Excel. I just need to extract the whole database or a view.

Is there a way to do this with a leased version?

Thank you

JIAM

craigbrass · 24-04-2008, 09:50 AM

The database isn't "encoded" or anything like that so it is possible to directly query the database. Take a look at Billing and reporting (SQL queries inside!) for a bit of guidance.

JIAM · 24-04-2008, 04:57 PM

That would be perfect...but I have a leased license. Would I still be able to query the database? Where can I do that?

Thanks!

JIAM

craigbrass · 24-04-2008, 05:21 PM

Yes. Leased licences still have access to the database.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problems with retrieving data from SQL database (minute to hours conversion)	chris.elenius	Developers & Code	1	06-12-2007 10:33 PM
how to generate a new auto-increment primary key in Data Transformation Service	winnie	SupportSuite, eSupport and LiveResponse	0	17-10-2007 03:32 AM
Update LoginShare data in SupportSuite?	reDDevil	How do I?	2	03-09-2007 06:24 AM
Teamwork - Data Transformation Service for 3rd Party Database	webcast_guy	Wont Implement / Already Implemented	1	09-08-2007 07:57 PM
connection problem	inteltechs	InstaAlert	5	27-04-2006 01:23 AM

JIAM Offline New Member Posts: 2 Join Date: Apr 2008	Extract database data - 24-04-2008, 01:07 AM Hello, Since Support Suite has no reporting options I would like to do my own reports in Excel. I just need to extract the whole database or a view. Is there a way to do this with a leased version? Thank you JIAM Last edited by JIAM; 24-04-2008 at 01:08 AM. Reason: Changed wording

craigbrass Online Senior Member Posts: 5,712 Join Date: Jun 2005 Location: Cumbria, UK	24-04-2008, 09:50 AM The database isn't "encoded" or anything like that so it is possible to directly query the database. Take a look at Billing and reporting (SQL queries inside!) for a bit of guidance. Craig Brass - Kayako Forum Squatter (Note: I am NOT a staff member) Icon Headquarters - Its Elixir - Web2Messenger

JIAM Offline New Member Posts: 2 Join Date: Apr 2008	24-04-2008, 04:57 PM That would be perfect...but I have a leased license. Would I still be able to query the database? Where can I do that? Thanks! JIAM

craigbrass Online Senior Member Posts: 5,712 Join Date: Jun 2005 Location: Cumbria, UK	24-04-2008, 05:21 PM Yes. Leased licences still have access to the database. Craig Brass - Kayako Forum Squatter (Note: I am NOT a staff member) Icon Headquarters - Its Elixir - Web2Messenger