
Hi All, To begin with I have just started looking into otrs from yesterday as I was informed I have to generate few management reports from otrs. When I checked with the person responsible for maintaining software, we still have version 1.2.3. I have recently joined this organization and they have asked me to prepare report like- How many new tickets per day, Backlog on peoples queues i.e how much and where, Who has the oldest tickets, Backlog ageing - how many say 0-5 days , 5-10 days etc Backend database for this install is mysql. I know it would have been nice to upgrade to current version of 2.3.4 but management is reluctant at the moment. My question is do I have to write perl script or can I query database to get the results? I'll greatly appreciate if you experts could provide some guidance or direction which will help me starting in new job in a right note..:) Thanks for your help in advance.