Get robot name

[Yazan_Otaibi]

hi all
i need to retrieve robot name as in the pic from get jobs activity !

[arjunshenoy]

Hi @Yazan_Otaibi

you can retrieve the machine name from the environment variable, like below

MachineName = Environment.MachineName //Returns the machine name

How to get details like jobId, robotId, windows username

Hi I created a logger using write text file and now need to insert details like jobId, robotId (if applicable), windows username into the log. How do I retrieve these values from workflow to insert.

Hope this helps,
Best Regards.

[Yazan_Otaibi]

hi @arjunshenoy

no i want robot name

• im working on a seq to retrieve the name of robot for all jobs, not in the same workflow that run the job so its will be difrent

[nikhil.girish]

Hi @Yazan_Otaibi

There are no direct functions available to get robot name , you have to rely on API for that

Check this post

Get name of the Robot (the name given to it in Orchestrator)

To get the robot name from the orchestrator, try using this API: Example - https://platform.uipath.com/odata/Sessions?$top=10&$filter=State eq ‘Available’ (gives information such as name, machinename, id, env’s etc… for first 10 robots which are available) More information here: https://docs.uipath.com/orchestrator/reference#robots-requests

Hope this helps

[Yazan_Otaibi]

Jobs Data Retrieval With Robot Name Using SQL Query

How to retrieve all Jobs data from UiPath Orchestrator DB using SQL Query ? Jobs data, retrieval with Robot name: SELECT B.Name as Robot, J.Id as JobID, CONVERT(varchar(200),R.Name) + CASE WHEN CHARINDEX('ServerList',CONVERT(varchar(300),J.InputArguments)) > 0 THEN '-'+LEFT(SUBSTRING(CONVERT(varchar(300),J.InputArguments),16,999),LEN(SUBSTRING(CONVERT(varchar(300),J.InputArguments),16,999)) - 2) ELSE '' END as ProcessName, DATEADD(hh,DATEDIFF(hh,GETUTCDATE(),GETDATE()),J.StartT…

solution.