Hi All,
Today I will cover what is the usage of this table in ServiceNow
Table Name: "task_time_worked"
1. What does this table stores?
Answer: This table stores the information on how much time spent by each user in viewing the task-based record. It stores the task number#, time worked, comments and user information.
2. When can we use this table?
Answer: If anyone want to see time spent by each user on that ticket. It gives you information that how much time each user viewed that ticket.
It only works on Task dependent tables.
3. How should we utilize this feature?
Answer: You have to configure task extended table record like incident and add the field "Time Worked" on the form view
4. What time does this field calculate?
Answer: This field once added on form calculates how long a record has been viewed.
5. Can a user pause the timer who is working on the ticket?
Answer: Yes, user can pause the timer by clicking on pause button on the right hand of the field.
6. What is the benefit of having this feature enabled?
Answer: It gives you the information on who has viewed the ticket and for how long. Also you can get the reporting on this table to see which agent has spent time on which ticket and for how long.
Also, important point to note this timer keep on running when the record is open on any tab. In order to pause it or stop it either you have to manually pause it from the button as mentioned above or close the tab.
Reporting:
7: How does this functionality work?
Answer: Timer starts ticking when the record is viewed, and it inserts the record in task_time_worked table when you hit the save button, so it triggers the action and insert the record.
Stay connected for more technical information on this.
Hope this helps you.
Regards,
Shamma
