Hi, thanks for the response everyone. But i'm still facing some problems. The biggest issue i think is the way things are treated within otrs. For example, the application otrs manager produces almost what i am searching for. When you run a report with it, it's great. But when i run it for 1 day, today for example, i notice the same things as when experimenting with the queries that are posted in reply to this topic.
When you work on a ticket, created yesterday, or last week, and account time for it, you just don't see it in your report. This is, from my point of view, due to the fact that that the time is reported based on create time and not change time. Am i correct in this assumption ? Does anyone have a workaround for this, for example an option to change this behavior in otrs-admin , or something else like a php script that produces some reports ? I'm really desperate for a good solution for this, it would make otrs 100% for us. thanks in advance, greets Mayk ----- "Marco Vannini" <[email protected]> wrote: > If you use otrs manager you could see either what sql it use and you > could take and change and use by hand ;) > > MV > > > > > 2009/2/11 Mayk Backus <[email protected]>: > > Hi All, > > > > Does anyone know of something on how to produce a time report of for > example > > today, or a specific day ? > > The reason for this is that our company sends bills for given > services. In > > the ticket we note the time we spend on a ticket, and it would be > great of i > > could produce some sort of output on what tickets have received time > units > > that day , by whom , how many time units , etc . > > I'm looking at OTRS Manager, it has something like this in the > reports it > > generates, but i notice sometimes it doesn't display a ticket what i > know of > > that has received time that day. So i doubt the reliability of it. > > > > Any news welcome. Perhaps someone has a php script that does these > outputs, > > of has created a stats report or maybe something complete > different. > > > > Hope to hear from you. > > > > kind regards, > > > > Mayk > > > > > > > > _______________________________________________ > > 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 > > > _______________________________________________ > 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 _______________________________________________ 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
