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  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

15 REPLIES 15

Hi Atul,

 

Yeah I tried that already.But No luck.Its not updating the breach time based on Due date in task.

Hi @Sounderrajan K 

But you didn’t mention anything about the due date condition.

*************************************************************************************************************
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************

@Sounderrajan K 

Thanks for confirming that my script worked for you.

I believe I answered your original question

To answer your subsequent question

-> when Duration Type = Breach on Due Date (it disables Pause Condition) and this is OOTB behavior due to OOTB UI policy

AnkurBawiskar_0-1767783140507.png

 

 

💡 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  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@Sounderrajan K 

Hope you are doing good.

Did my reply answer your question?

💡 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  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

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  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader