Get Robot utilization/Execuion logs in on permises orchestrator

Help Orchestrator
,
1

Hi Team,
We would need to get the bot utilization report for last 3 months by considering all the running processes in On-premises orchestrator . Kindly help us to know how we can download the report for only last 3 months from the orchestrator.
We tried to export the logs but its huge and we are not able to pull the data for only 3 months.
Do we need to go with Orchestrator database? If so kindly explain the steps and the query o be executed in database.

Thanks in advance.

2

@Shrividya_A1

Make sure you have the necessary permissions to access the Orchestrator database. You might need assistance from your database administrator for this step.
Orchestrator typically uses a SQL Server database. You’ll need access to this database to run SQL queries.

-Connect to the Database
-Write SQL Query

Sample query that retrieves job execution data for the last 3 months:

Example:

SELECT
    JobId,
    StartTime,
    EndTime,
    RobotId,
    ProcessKey
FROM
    Table Name
WHERE
    StartTime >= DATEADD(MONTH, -3, GETDATE())

-Execute the SQL query and export the data to a format of your choice, such as a CSV file.

1 Like
3

Hi @Dilli_Reddy

Thanks for your kind response.
May i know the table Name in the above mentioned query to execute? We just tried with the “logs” Table to pull the Job details.

4

@Shrividya_A1

Table Name - Jobs

SELECT
    JobId,
    StartTime,
    EndTime,
    RobotId,
    ProcessKey
FROM
    Jobs
WHERE
    StartTime >= DATEADD(MONTH, -3, GETDATE())
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.