Re: [otrs] OTRS reports or stats

Alexander Scholler Wed, 17 May 2006 23:13:13 -0700

Hi,

Abdelrahman schrieb:

ALEX, THANKS!


I had to add somethings to ticket.pm but it worked like a charm.....

Although i wasn't satisfied by the graph generated

Is there a way to generate a bar graph instead of the broken line..


See ~/Kernel/Module/SystemStats.pm

You can use Graph(|Line|Bars|Pie) as graphic types.


Also,

I have another question,

it there a way to map my ldap groups to the customer groups in otrs and
generate a report that is grouped by customer group


I don't have know how on customer groups.
You use groupOfUniqueNames or posixGroups on LDAP?

Perhaps you can map CustomerID to a specific LDAP-value - but this wouldbe a N:1-relationship.



regards
abdelrahman


Bye, Alex

On Tue, 2006-05-16 at 10:39 +0200, Alexander Scholler wrote:
Hi,

Abdelrahman schrieb:
Hi all,
I am enjoying OTRS, it is the best open source help desk i found untilnow, the problem is that i need to OTRS to produce reports more thanthose i found in the stats module?!I thought about using a thirdparty product to produce the reports but myboss won't agree about that because he needs a complete solution,therefore, he will need to produce the reports from the stats module.
So you know the SQL-statements producing the stats you want.
Did any one design any custom reports?!
1) Make a copy of AccountedTime.pm, clear this files (delete all youdon't need) and
2) e.g. replace the sub Run with this on

sub Run {
     my $Self = shift;
     my %Param = @_;
     $Param{Month} = sprintf("%02d", $Param{Month});
     my $Title = "$Param{Name} $Param{Year}-$Param{Month}";
     my @HeadData = ('CustomerID', 'Tickets', 'Articles', 'Time');
     my @Data = ();
     # get accounted time
     my $Days = Days_in_Month($Param{Year},$Param{Month});
     my @Tickets = ();

     my $SQL = <<ENDE;
SELECT
  customer_id AS Amt,
  COUNT(id) AS Tickets,
SUM((SELECT COUNT(id) FROM article WHERE ticket_id = t.id)) ASAktivitaeten,CAST(SUM((SELECT SUM(time_unit) FROM time_accounting WHERE ticket_id =t.id)) AS UNSIGNED) AS Stunden
FROM ticket t
WHERE create_time >= '$Param{Year}-$Param{Month}-01 00:00:01'
AND create_time <= '$Param{Year}-$Param{Month}-$Days 23:59:59'
GROUP BY customer_id;
ENDE

     $Self->{DBObject}->Prepare(SQL => $SQL);
     while (my @Row = $Self->{DBObject}->FetchrowArray()) {
         push (@Data, [EMAIL PROTECTED]);
     }

     return ([$Title],[EMAIL PROTECTED], @Data);
}

3) correct the package name at the top of the file.

4) insert into ~/Kernel/Config/Files/Ticket.xml
<ConfigItem Name="SystemStatsMap###Ticket::StatsOwn1" Required="0"Valid="1"><Description Lang="en">support done per customer#(customer_id)</Description><Description Lang="de">geleisteter Support pro Kunden#(customer_id)</Description>
         <Group>Ticket</Group>
         <SubGroup>Core::Stats</SubGroup>
         <Setting>
             <Hash>
                 <Item Key="Name">Support pro Kunden#</Item>
<ItemKey="Module">Kernel::System::Stats::Support_per_Customer_id</Item><Item Key="Desc">Support der insgesamt fuer Ticketsgeleistet wurde, die innerhalb des Zeitraumes -erstellt- wurden,gruppiert nach Kunden#</I
tem>
                 <Item Key="SumCol">1</Item>
                 <Item Key="UseResultCache">0</Item>
                 <Item Key="Output">
                     <Array>
                         <Item>Print</Item>
                         <Item>CSV</Item>
                     </Array>
                 </Item>
                 <Item Key="OutputDefault">Print</Item>
             </Hash>
         </Setting>
     </ConfigItem>
I didn't find anything in the developer documentation and i didn'tunderstand a thing from the *.pm in system\stats\ on the serverHELP
abdelrahman
Bye, Alex
_______________________________________________
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
Support oder Consulting für Ihr OTRS System?
=> http://www.otrs.de/
_______________________________________________
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
Support oder Consulting f�r Ihr OTRS System?
=> http://www.otrs.de/


_______________________________________________
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
Support oder Consulting f�r Ihr OTRS System?
=> http://www.otrs.de/

Re: [otrs] OTRS reports or stats

Reply via email to