How to know all the bot utilization across all process in uipath orchestrator

Help Orchestrator
,
1

Bot timings; like when to when bot occupied

2

Hi @vidhya.viddu538,

You can use this query in UiPath with Run Query or Execute Query activity.

Or you can use it on Orchestrator SQL too.

This query will give you the process stardDate, endDate and Duration of the process. It is daily report, you can change the day amount from BETWEEN DATEADD part. -1 is the day amoun. If you want weekly, you can do it 7.

–Daily UnAttended Robot Usage
SELECT jsd.RobotId,jsd.name,jsd.StartTime, jsd.EndTime, DATEDIFF(MINUTE, jsd.StartTime , jsd.EndTime) AS MinuteDiff, DATEDIFF(SECOND, jsd.StartTime , jsd.EndTime) AS SecondDiff
FROM(SELECT j.ReleaseId, ro.Name, j.RuntimeType, j.StartTime, j.EndTime, j.robotid
FROM Jobs j, Releases re, Robots ro
WHERE j.RuntimeType = ‘2’
and j.ReleaseId = re.Id and j.robotid = ro.Id
and j.StartTime BETWEEN DATEADD(DAY,-1,GETDATE()) AND GETDATE()) jsd
GROUP BY jsd.RobotId,jsd.name,jsd.StartTime,jsd.EndTime
Order By jsd.RobotId asc, jsd.StartTime asc

Regards.
Ömer

3

Hi Omer,

How to connect Orchestrator Database, I mean what will be connection string.

Could you please help me on this.

Regards,
Vidhya

4

Hi @vidhya.viddu538,

If your orchestrator is on-premise, you need to know your SQL Server Informations. With ServerName, username and password, you get connect your database.

Regards.
Ömer