Re: [otrs] Details about OTRS Database

Thanks a lot. I found this one useful . http://wiki.otterhub.org/index.php?title=Report_generators Thanking You Darshak Modi Elitecore-IN 919909008245 On 25-03-2013 PM 04:06, Steven Carr wrote:

You can find the database schema diagram in the code...

https://github.com/OTRS/otrs/blob/master/doc/OTRSDatabaseDiagram.png

I don't know of any repository of SQL snippets that will get specific data out of the database for you so you're probably on your own with that (you could turn on SQL query logging so you can see the various queries OTRS makes to the database which would give you a starting point).

Steve

On 25 March 2013 10:03, Darshak Modi wrote:

...

Dear All,

I want to use external report tool using OTRS DB.

Is there any document describing Database details and how to use for reporting?

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

---

OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs