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
Please log in to answer
Posted by: chucksteel 5 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?