Reporting on the date/time a task was assigned to a person

[Blair5]

We need a report that captures the date/time a task was assigned to a person. Is this information stored on the sc_task table? If so, which field is it? If not, what table do I use to report on this information?

Thanks.

[tyler_jones]

As far as I know, this information is not captured anywhere. However, you could create the field (in the task or sc_task) table called assigned_date, and then set it in a business rule.

[ericfisch]

You can create a Metric Definition to capture this as well. If you select the sc_task table, assigned_to field and keep the type as "Field Value Duration", evertime the task is assigned, a new entry will be added to the metrics table. You can then report against sc_task_metric to get the desired data.

[Blair5]

Could you give me a bit more information on how to do this? You say to keep the assigned to field as "Field Value Duration". I'm not following that. If you can direct me to a wiki article, that'll work, too.

Thanks

[ericfisch]

Here is a wiki article on Metric Definitions: http://wiki.service-now.com/index.php?title=Metric_Definition_Support