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 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.

I'm pretty sure that it is possible to generate similar reports using SQL queries. I don't know if the OTRS database schema is documented[...]

see http://ftp.otrs.org/pub/otrs/misc/otrs-2.1-database.png