Home Service Manager

Work Item Time Pending/Active

James_JohnsonJames_Johnson Customer Adept IT Monkey ✭✭

The data warehouse has a view IncidentStatusDurationFactvw which shows time an incident spent active or pending. I'm trying to rid us of the data warehouse and just build reports off of the ServiceManager db. I can't seem to find a table or view that contains this information though.

Is this something that is just created based of the entity change log or am I missing something?


Thanks,

James

Answers

  • Peter_MiklianPeter_Miklian Customer Advanced IT Monkey ✭✭✭

    I miss this information, too.

    I hope you can find that information somewhere in the DB.

    But parsing the work item history is the only way I was able to get to timestamps of work item (WI) status changes using PowerShell.

    We consider filling custom DB using Orchestrator upon WI status changes and support group/analyst assignments to have those records at hand and to be able to measure duration in each state/assignment.

Sign In or Register to comment.