Tracking of duration/business duration for Catalog Tasks

[priya0895]

Hi, 

Need to track Catalog Task duration and business duration but this information is not currently being recorded at the task level and resides at the RITM level.  Please assist as to what needs to be done to take this forward. 

Thank You,
Priya

[Prithviraj Howa]

Hello Priya,

Please go though following link;

https://community.servicenow.com/community?id=community_question&sys_id=c21c2e39db815f842e247a9e0f96...

It will help you.

If you find that answer is specific then mark it as Correct and Helpful.

Warm Regards,

Prithviraj Howal

SNOW Developer

[johnfeist]

Hi Priya,

All tables that extend task have duration and business duration.  Both sc_req_item and sc_task extend task so the field is present in both.  The duration is measured in seconds so if you plan on using them other than to have ServiceNow display the values or access/manipulate them with ServiceNow utilities you need to keep that in mind.

Hope that helps.

:{)

Helpful and Correct tags are appreciated and help others to find information faster

[priya0895]

Hi John, 

  I wish to use duration field for reporting catalog tasks but this field appears to be empty. I do not understand as to why.
Any inputs?

Thanks
Priya

[johnfeist]

Hi Priya,

I'll have to do some digging for any OOTB mechanism that can be turned onto update those fields.  In the meantime, here's a straight forward script that should help you.

Hope that helps.

:{)

Helpful and Correct tags are appreciated and help others to find information faster