Asset Duration -- "Pending Return" Substate

[Community Alums]

Hi All,

I have a requirement, need to create the Asset report and in that report need to include the "Duration" option of the Asset stayed in "Pending Return". i.e., want to know how many days a Asset is in "Pending Return substate". Can someone help me on this requirement.

[Mark Manders]

Are you already collecting that data, and if so, how?

You could use metrics if you are not yet doing this (please read this article to understand how it works for non-task extended tables: https://www.servicenow.com/community/developer-articles/metrics-on-non-task-tables/ta-p/2308846).

Then you can easily create a DB view between the metric and asset tables to report on.
You could also add the field on the asset form if it is really important. Just add a flow that triggers when the state is set to 'pending return' and calculate the field when it is returned.