K1000 CREATED vs TIME_OPENED fields
Can anyone tell me what is the difference between the CREATED and the TIME_OPENED fields on Kace K1000
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
chucksteel
7 years ago
The TIME_OPENED, TIME_CLOSED, and TIME_STALLED columns are related to ticket status states. A status can have a state of either stalled, opened or closed. The default New status has a state of Stalled, so when a ticket is initially created it will be in a stalled state and the TIME_STALLED column will be set to that time (which should match the CREATED timestamp). Once the ticket's status is set to an Opened state the TIME_OPENED column will be set.
So, the difference between the CREATED and TIME_OPENED columns will show you how long it took from the time a ticket was created until it was changed to a status with the Opened state.
These columns are updated whenever the status changes between states, however, so the difference between CREATED and TIME_OPENED is not necessarily how long it took for the first status change to occur. For instance, if a ticket is stalled at 8:00am, then opened at 8:30am, then stalled at 8:35am, then opened at 9:00am, the TIME_OPENED column will reflect the 9:00am change and the TIME_STALLED column will reflect the 8:35am change.
Does that answer your question?
Comments:
-
Thanks Chuck - Druis 7 years ago
-
Chuck, i'm trying to create a report that gives me tickets w/ an opened status of > 30 days and the system is not cooperating. what am i doing wrong? - Mo - mmarchese@cookcountytreasurer.com 7 years ago
-
Not sure. I suggest you create a new question and include your current query. - chucksteel 7 years ago
