Znuny Open Source Ticketsystem

crythias, thanks for the query, it was very helful. I'm using postgresql and had to change it, algo I changed the query a bit so thar I could get owner, state, ticket_id, service, sla and time_acconting. The time_accounting is a sum function (so I get only one result per ticket and a sum of all time...

Thanks for the replies, does anyone know any material thar could help me create a new simple module in OTRS?

Hello All, I'm searching for a way to use OTRS on my company but I need a "billing module". What I need is a way to sum all acounted time on a ticket in OTRS and for each queue there is a diferent value for the time. For an example, in my queue Security I have a value of 50 per hour, but i...