Ticket Rule to Write Time of 1st Action
Hi,
We would like to create a report for the service desk to show the average time it takes each owner to action a ticket assigned to them as status 'New'.
To do this, I want to setup a ticket rule which writes the date and time to a custom field labeled 'Time of 1st Action' and the user that actioned the ticket to a custom field labeled '1st Actioned By' when the status changes from 'New' to anything other than 'New' and there is currently no entry in the 'Time of 1st Action' field.
Once we have this data recorded, we can create an SQL Report to work out how long each ticket took to be actioned initially by comparing the time created and time of 1st action fields, and therefore create this report.
How would I go about creating this ticket rule, I am not too familiar with SQL unfortunately.
Thanks Guys
-Dave
We would like to create a report for the service desk to show the average time it takes each owner to action a ticket assigned to them as status 'New'.
To do this, I want to setup a ticket rule which writes the date and time to a custom field labeled 'Time of 1st Action' and the user that actioned the ticket to a custom field labeled '1st Actioned By' when the status changes from 'New' to anything other than 'New' and there is currently no entry in the 'Time of 1st Action' field.
Once we have this data recorded, we can create an SQL Report to work out how long each ticket took to be actioned initially by comparing the time created and time of 1st action fields, and therefore create this report.
How would I go about creating this ticket rule, I am not too familiar with SQL unfortunately.
Thanks Guys
-Dave
0 Comments
[ + ] Show comments
Answers (4)
Please log in to answer
Posted by:
GillySpy
12 years ago
To look at a change in something refer to this faq:
http://www.kace.com/support/kb/index.php?action=artikel&cat=8&id=1046&artlang=en
You will also want to look at yoru custom field being empty. e.g.
Your update will modify the custom field with the current timestamp. e.g
http://www.kace.com/support/kb/index.php?action=artikel&cat=8&id=1046&artlang=en
You will also want to look at yoru custom field being empty. e.g.
select blah
from blah
where blah
and CUSTOM_FIELD_VALUE1='Your update will modify the custom field with the current timestamp. e.g
UPDATE blah
SET CUSTOM_FIELD_VALUE1=NOW()
WHERE blah
Posted by:
davids
12 years ago
Hi GillySpy,
I've got it working perfectly. I want to also write into a custom field the name of the user that did the action (current logged in user).
How can I specify that?
Regards
-Dave
I've got it working perfectly. I want to also write into a custom field the name of the user that did the action (current logged in user).
How can I specify that?
Regards
-Dave
Posted by:
GillySpy
12 years ago
The user that did the action is also the user tied to HD_TICKET_CHANGE.USER_ID
I call this the "updater" as they could be any of the owner, submitter, approver or another user.
I call this the "updater" as they could be any of the owner, submitter, approver or another user.
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.