Hi,
 
Thanks for this great help!!
 
 
Is it not possible to generate similar kind of reports from sql queries ?? Offcourse , in that we have to know the tables and column information related to OTRS database...
 
Please advice
 
Regards
 
Khurram 

Mike Clayton <michael.clayton@nwphysicians.com> wrote:
Having been asked to do this by my manager, this was my solution:

pass a pre-encoded set of post variables to lynx, dump the server's
response to stdout, and pipe it all in to an html e-mail. and just run
the script from cron.
the sed command in there keeps the e-mail client from trying to print it
as soon as it loads.
in this example, StatID lets you chose which stat to run. this one is
fairly simple.

echo -en "MAIL FROM: root@localhost\nRCPT TO:
ADDRESS@DOMAIN.TLD\nDATA\nSubject: OTRS: Daily Tickets by
Creator\nContent-Type: text/html; charset=ISO-8859-1\n$(echo
"Action=Login&RequestedURL=Action%3DAgentStats%26Subaction%3DRun%26StatID%3D5%26Format%3DPrint&Lang=en&TimeOffset=360&User=OTRSUSER&Password=OTRSPASS"
| lynx -source -post_data http://172.26.8.8/otrs/index.pl | sed
s/^\/)\n.\n" | nc 127.0.0.1 25 &> /dev/null

Here is another example where start and stop dates are passed by the
script (this one was written to be run on the first of every month):

### Year to Date tickets by Site and Queue
MONTH=$(perl -e 'use Date::Calc qw(Today Add_Delta_Days); my ($y, $m,
$d) = Add_Delta_Days(Today(), -1); print "$m";')
DAY=$(perl -e 'use Date::Calc qw(Today Add_Delta_Days); my ($y, $m, $d)
= Add_Delta_Days(Today(), -1); print "$d";')
YEAR=$(perl -e 'use Date::Calc qw(Today Add_Delta_Days); my ($y, $m, $d)
= Add_Delta_Days(Today(), -1); print "$y";')
#echo -en "MAIL FROM: root@localhost\nRCPT TO:
ADDRESS@DOMAIN.TLD\nDATA\nSubject: OTRS: Year-To-Date Tickets by Site
and Queue\nContent-Type: text/html; charset=ISO-8859-1\n$(echo
"Action=Login&RequestedURL=Action%3DAgentStats%26Subaction%3DRun%26StatID%3D8%26Format%3DPrint%26UseAsRestrictionCreateTimeStartMonth%3D1%26UseAsRestrictionCreateTimeStartDay%3D1%26UseAsRestrictionCreateTimeStartYear%3D$YEAR%26UseAsRestrictionCreateTimeStopMonth%3D$MONTH%26UseAsRestrictionCreateTimeStopDay%3D$DAY%26UseAsRestrictionCreateTimeStopYear%3D$YEAR%26&Lang=en&TimeOffset=360&User=OTRSUSER&Password=OTRSPASS"
| lynx -source -post_data http://172.26.8.8/otrs/index.pl | sed
s/^\/)\n.\n" | nc 127.0.0.1 25 &> /dev/null

Hope this helps

aix tiger wrote:
> Hi
>
> I want to know that when OTRS will include reporting feature ( like
> daily or monthly reports ) which reflects performance of service desk
> for management review
>
> I beleive MIS reports from Service desk is a important requirement of
> ITIL framework and methodology so it should be included in OTRS
>
>
> Any comments or advices how can we get such kind of reports from OTRS?
>
>
> Regards
>
>
>
> ------------------------------------------------------------------------
> Bored stiff?
> Loosen up...
> Download and play hundreds of games for free
> on Yahoo!
> Games.
> ------------------------------------------------------------------------
>
> _______________________________________________
> 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 or consulting for your OTRS system?
> => http://www.otrs.com/

_______________________________________________
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 or consulting for your OTRS system?
=> http://www.otrs.com/


Get the Yahoo! toolbar and be alerted to new email wherever you're surfing.