How can I get history data of support group change with time stamp ?

I am working on Power BI report for time taken from one support group to another. 
Could you please help me in getting data with time stamp so that I can calculate time duration taken 
by first assigned support group to override route for different assigned support group. 
Currently I am using service manager database's tables to get data.

Answers

  • Steve_WrightSteve_Wright Cireson Support Advanced IT Monkey ✭✭✭
    Hi @Rajnish_Kumar_Mishra, Can you tell us which service manager tables you are using for the query?
    Thanks,
    Steve 
  • Rajnish_Kumar_MishraRajnish_Kumar_Mishra Customer IT Monkey ✭
    @Steve_Wright , Hi Steve, I am using customized view created by me, which has various table as below.
    [MT_System$WorkItem$Incident_Log]
    MT_System$WorkItem$TroubleTicket$ActionLog_Log
    [MT_System$WorkItem$TroubleTicket$AnalystCommentLog]

Sign In or Register to comment.