I using a business intelligence tool to run reports from OTRS. I have access to the different tables, but there are two things I have not been able to do
1. Figure out how OTRS calculates solution time (how long it takes to close a ticket), accounting only for 'working hours'
2. Find the calendar table(s)
Can anyone help?
Finding Calendar Table
Moderator: crythias
-
reneeb
- Znuny guru
- Posts: 5018
- Joined: 13 Mar 2011, 09:54
- Znuny Version: 6.0.x
- Real Name: Renée Bäcker
- Company: Perl-Services.de
- Contact:
Re: Finding Calendar Table
The calendars are configured via SysConfig... Admin -> SysConfig -> Framework -> Core::Time::Calendar[1-9]
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Re: Finding Calendar Table
as they are in sysconfig, there is no database table with this data
"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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com