Report: For each ticket see minutes from open to locked and minutes from open to closed

Moderator: crythias

Post Reply
needmorecoffee
Znuny newbie
Posts: 4
Joined: 25 Jan 2024, 17:46
Znuny Version: 6.5.2
Real Name: Emanuele Coraia
Company: Infogest srl

Report: For each ticket see minutes from open to locked and minutes from open to closed

Post by needmorecoffee »

Hello everyone.

I'm tried to build a report in which you can have theese kind of stats:

ID Ticket - Owner\Responsabile - Customer - Minutes lapsed between ticket opened and locked - Minutes lapsed between ticket opened and closed - Minutes lapsed from ticked locked and closed

Is that possible?
alexus
Znuny wizard
Posts: 380
Joined: 20 Sep 2010, 16:54
Znuny Version: OTRS 6 CE
Real Name: Alexey Yusov
Company: Radiant System Group s.r.o
Location: Prague
Contact:

Re: Report: For each ticket see minutes from open to locked and minutes from open to closed

Post by alexus »

Hello,

It's not possible with standard reporting tool. We develop customized static reports if we need go get some specific data
Alexey Yusov

Production: OTRS CE ITSM 6.0.28 on CentOS 7 + Apache 2.4 + MariaDB 10.4.13 + Radiant Customer Portal

Radiant System OTRS Intergrator
RS4OTRS marketplace
Stay tuned on our Facebook
((OTRS)) Community Edition - what next?
jojo
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Report: For each ticket see minutes from open to locked and minutes from open to closed

Post by jojo »

as create time, last close time and lock time can be reported it is just some simple Excel functionality to achieve that.
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Post Reply