Viewing closed Tickets forAdmin

Moderator: crythias

Locked
Harikumar
Znuny newbie
Posts: 43
Joined: 17 Aug 2011, 08:00
Znuny Version: 3.0.9
Real Name: harikumar
Company: ii2

Viewing closed Tickets forAdmin

Post by Harikumar »

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
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Viewing closed Tickets forAdmin

Post by jojo »

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
Harikumar
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

Post by Harikumar »

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
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Viewing closed Tickets forAdmin

Post by jojo »

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
Harikumar
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

Post by Harikumar »

Jojo,

Would you please tell me in detail .

Thankyou
Hari
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Viewing closed Tickets forAdmin

Post by jojo »

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
Locked