How to calculate Process Execution time using an SQL Query in the Orchestrator Database?

[system]

How to Calculate Process Execution time using an SQL Query in the Orchestrator Database?

• Execute the below query.

SELECT
    R.Name
   ,R.ProcessKey
   ,Ro.Name
   ,Ro.UserName,
         DATEDIFF(SECOND, startTime, endtime) AS Timerun
   ,[Info]
 FROM [dbo].[Jobs]  J
 Inner JOIN Releases R
 ON j.ReleaseId = R.Id
 Inner join Robots Ro
 On J.RobotId = Ro.Id  where DATEPART(YEAR, EndTime) = 2024

• Output should look like below: