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

[Sounderrajan K]

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?

[Sounderrajan K]

Hi Atul,

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

[Dr Atul G- LNG]

Hi @Sounderrajan K 

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

[Ankur Bawiskar]

@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

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

[Ankur Bawiskar]

@Sounderrajan K 

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

you can refer to many OOTB metrics

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! 🙏

[Mckenzco]

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.