We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

Need to add a measurement of time all tasks and request that starts and ends with pending vendor

Sounderrajan K
Tera Contributor

Need to determine a method to add a measurement of time all SCTASKs and enhancement request that starts and ends when State is set to Pending Vendor, then moved out of Pending Vendor state.

We may need to add a hidden SLA to measure this, or determine another way.

Is there any best practices to implement this functionality?

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron

@Sounderrajan K 

you can use Metrics to capture the time spent in "Pending Vendor" state

you can refer to many OOTB metrics

AnkurBawiskar_0-1767627128356.png

OR

Another way is to use SLA

Table - sc_task

Start Condition: State [IS] Pending Vendor

Stop Condition: State [IS NOT ONE OF] Pending Vendor 

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

15 REPLIES 15

Mckenzco
Tera Contributor

We export the data using API to PowerBi and then use measures in Power Bi to report on this. Might be something worth looking at. This way we can compare it to other stuff as and when we need it. So future proofs your work.