On Thu, Apr 30, 2009 at 6:44 PM, Alberto Villanueva <[email protected]> wrote: > Hi!
[snip] > > I don't know if it's easier than. I need to do several queries in > MySQL because the different reports tools for RT don't run all > queries my Client wants to. So if I get all queries, I'll speak > to my boss for developing a perl script to do them :-) Then stop asking meaningless questions and show us example of what you want to get and which variables do you have (queue name, CF name or id, or something else). Most users don't know DB layout, others who know wouldn't bother to describe everything to you. Pick a report you want to get, describe and may be somebody will write you a SQL query. Also, you can get examples of queries out of RT, enable statements logging, search using query builder and look into logs. Use Charts and look into logs. > >> >> Regards; >> Roy > > Best regards, > > ALBERTO VILLANUEVA DEL VAL > Consultor > ____________________________________________ > Altran Technologies > ParqueEmpresarial Las Mercedes, Edificio 1 > C/ Campezo, 1. 28022 Madrid > Tel: + 34 91 744 46 00 - Ext: 2205 > Fax: + 34 91 415 24 57 > www.altran.es > > > -- Best regards, Ruslan. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
