[rt-users] Records RT - Doubt

[Kenneth Crocker]

Felipe,

We do reports a couple different ways.

1) We have the standard RT Search and download to excel, which is then
imported into an Excel template, then mailed as an attachment.
2) We also have the standard RT search used with Dashboards.
3) Then we have an alternative for users who never get onto RT. We created
DB "Views" (native SQL) used for reporting only and then use Cognos as a
reporting tool against those views. The reports that exist are available
thru "links" in our company website.

Hope this helps.

Kenn
LBNL

On Wed, May 25, 2011 at 10:15 AM, Felipe Agnelli Barbosa <no.molas at gmail.com
> wrote:

> Okay, I'll check that.
> Enjoying a little more, it is possible for SQL?,
> I was thinking of doing some SQL queries and build a Python script showing
> statistics.
>
>
> Felipe
> BR
>
>
> 2011/5/25 Ruslan Zakirov <ruz at bestpractical.com>
>
>> Hi,
>>
>> Search for tickets, open page with results, use actions at the top right
>> corner.
>>
>> On Wed, May 25, 2011 at 8:57 PM, Felipe Agnelli Barbosa
>> <no.molas at gmail.com> wrote:
>> > Hello Ruslan Zakirov,
>> >
>> > Thank you for your attention, so I wanted something more specific, how I
>> can
>> > export in CSV?
>> > And, by chance, someone already has some ready to excel?
>> > Outside CSV has some other way?
>> >
>> > Thanks again,
>> >
>> > Felipe
>> > BR
>> >
>> > 2011/5/25 Ruslan Zakirov <ruz at bestpractical.com>
>> >>
>> >> Hi,
>> >>
>> >> Take look at charts, saved searches and dashboards. If it's not
>> >> enough, people often use csv export and excel to produce reports.
>> >>
>> >> On Wed, May 25, 2011 at 8:16 PM, Felipe Agnelli Barbosa
>> >> <no.molas at gmail.com> wrote:
>> >> > Dear,
>> >> >
>> >> > Not sure this is the place, but wanted help to generate some reports
>> >> > relating to RT in a MySQL database.
>> >> >
>> >> > I wonder if they already have a tool ready for customization of
>> reports,
>> >> > or
>> >> > if I have to do this via sql queries.
>> >> >
>> >> > Thank you in advance,
>> >> >
>> >> > Felipe
>> >> > BR
>> >> >
>> >> > --
>> >> > " A dúvida é o principio da sabedoria "
>> >> >
>> >> >
>> >> >
>> >>
>> >>
>> >>
>> >> --
>> >> Best regards, Ruslan.
>> >
>> >
>> >
>> > --
>> > " A dúvida é o principio da sabedoria "
>> >
>> >
>> >
>>
>>
>>
>> --
>> Best regards, Ruslan.
>>
>
>
>
> --
> " A dúvida é o principio da sabedoria "
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110525/77b03566/attachment.htm>