get all ticket created in last 1 month

[shivendra]

hello,

iam trying to generating report of all ticket of this month created.but total no.of ticket shown in report is 230.infact on checking ticket status at admin login its show total ticket 300 then why this difference is coming.

can any guide me step to get all ticket

[jojo]

Please Show the settings of your report. Last month refers to the last closed month. So it is November at the moment

[shivendra]

ok...


how can i show u?

[shivendra]

export file include extension .xml which is not allowed in upload option.

iam pasting config below.


Stat#:
10014
Title:
Ticket closed list
Object:
Ticketlist
Description:
all
Format:
Sum rows:
No
Sum columns:
No
Cache:
No
Validity:
valid
Created:
12/24/2012 13:24:05
Created by:
Admin admin
Changed:
12/25/2012 15:53:33
Changed by:
Admin admin
X-axis
Attributes to be printed:

Number
Ticket#
Age
Title
Created
Changed
Close Time
Queue
State
Priority
Customer User
CustomerID
Service
SLA
Accounted time
EscalationDestinationIn
EscalationDestinationDate
EscalationTimeWorkingTime
EscalationTime
FirstResponse
FirstResponseInMin
FirstResponseDiffInMin
FirstResponseTimeWorkingTime
FirstResponseTimeEscalation
FirstResponseTimeNotification
FirstResponseTimeDestinationTime
FirstResponseTimeDestinationDate
FirstResponseTime
UpdateTimeEscalation
UpdateTimeNotification
UpdateTimeDestinationTime
UpdateTimeDestinationDate
UpdateTimeWorkingTime
UpdateTime
SolutionTime
SolutionInMin
SolutionDiffInMin
SolutionTimeWorkingTime
SolutionTimeEscalation
SolutionTimeNotification
SolutionTimeDestinationTime
SolutionTimeDestinationDate
SolutionTimeWorkingTime
First Lock
lock
StateType
UntilTime
UnlockTimeout
EscalationResponseTime
EscalationSolutionTime
EscalationUpdateTime
RealTillTimeNotUsed
Value Series
Order by:

Ticket#
Age
Title
Created
Changed
Close Time
Queue
State
Priority
Customer User
CustomerID
Service
SLA
Accounted time
EscalationDestinationIn
EscalationDestinationDate
EscalationTimeWorkingTime
EscalationTime
FirstResponse
FirstResponseInMin
FirstResponseDiffInMin
FirstResponseTimeWorkingTime
FirstResponseTimeEscalation
FirstResponseTimeNotification
FirstResponseTimeDestinationTime
FirstResponseTimeDestinationDate
FirstResponseTime
UpdateTimeEscalation
UpdateTimeNotification
UpdateTimeDestinationTime
UpdateTimeDestinationDate
UpdateTimeWorkingTime
UpdateTime
SolutionTime
SolutionInMin
SolutionDiffInMin
SolutionTimeWorkingTime
SolutionTimeEscalation
SolutionTimeNotification
SolutionTimeDestinationTime
SolutionTimeDestinationDate
SolutionTimeWorkingTime
First Lock
lock
StateType
UntilTime
UnlockTimeout
EscalationResponseTime
EscalationSolutionTime
EscalationUpdateTime
RealTillTimeNotUsed
Sort sequence:

ascending
Restrictions
Service:

COMP
SLA:

0 Level – Low importance – Resolutions within 6 days
1 Level – Medium Level – Resolution within 3 days
2 Level – High Level – Resolution with in business day
3 Level – Business stoppers – Resolution within 4 hours
Queue:


FILE SERVER / MAIL SERVER / PORTAL::File server
FILE SERVER / MAIL SERVER / PORTAL::Internet / Weblink
FILE SERVER / MAIL SERVER / PORTAL::Mail server
FILE SERVER / MAIL SERVER / PORTAL::Portal
HARDWARE / SOFTWARE::Anti VIrus
HARDWARE / SOFTWARE::CPU
HARDWARE / SOFTWARE::Keyboard
HARDWARE / SOFTWARE::LAN / NETWORK
HARDWARE / SOFTWARE::Laptops
HARDWARE / SOFTWARE::Monitor
HARDWARE / SOFTWARE::Mouse
HARDWARE / SOFTWARE::Printer
HARDWARE / SOFTWARE::Software installation / remove
HARDWARE / SOFTWARE::Video Conference / Projector

State:

closed successful
closed unsuccessful
merged
new
open
pending auto close+
pending auto close-
pending reminder
removed
Created State:

closed successful
closed unsuccessful
merged
new
open
pending auto close+
pending auto close-
pending reminder
removed
Lock:

lock
tmp_lock
unlock
CustomerID:

comp