Hi Team,
Is there any way to view the number of closed tickets ?Something like ,I want to know which all tickets were closed during April1st and April 3rd week .Kindly help me ?As an Admin,it is required to keep the list of open and closed tickets.
Thanks,
Hari
Viewing closed Tickets forAdmin
Moderator: crythias
Re: Viewing closed Tickets forAdmin
you can use OTRS search or the statistik for this
"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
-
- Znuny newbie
- Posts: 43
- Joined: 17 Aug 2011, 08:00
- Znuny Version: 3.0.9
- Real Name: harikumar
- Company: ii2
Re: Viewing closed Tickets forAdmin
Hello Team,
In Statistics I can get closed tickets for last month.I want to get it for a particular week.I think it is possible to use SQl query via SQL box.but I dont know which table to use and which columns to look at?
Kindly help me and tell in details
Thanks
hari
In Statistics I can get closed tickets for last month.I want to get it for a particular week.I think it is possible to use SQl query via SQL box.but I dont know which table to use and which columns to look at?
Kindly help me and tell in details
Thanks
hari
Re: Viewing closed Tickets forAdmin
you can also create for the last 7 days
"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
-
- Znuny newbie
- Posts: 43
- Joined: 17 Aug 2011, 08:00
- Znuny Version: 3.0.9
- Real Name: harikumar
- Company: ii2
Re: Viewing closed Tickets forAdmin
Jojo,
Would you please tell me in detail .
Thankyou
Hari
Would you please tell me in detail .
Thankyou
Hari
Re: Viewing closed Tickets forAdmin
just go through the statistic wizzard
"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