How to Find unique job names from Orchestrator that ran in last 60 days

[mail2jikku (Joseph)]

Hello,
I am trying to find the list of processes that ran from orchestrator (Unique) in the last 60 days.
Running a sql query from the database on the jobs table does not return the job names, and wanted to figure out the best way to get that.
Thanks,

[Anil_G (Anil Gorthi)]

@mail2jikku

You can use orchestrator api…

Check the swagger - <orchestratorURL>/swagger/index.html

Get jobs api is what you can use.and select only job mame and from the response take a distinct

Cheers

[vrdabberu (Varunraj Dabberu)]

Hi @mail2jikku

Check out this thread

How to retrive three months data from orchestrator

If you cannot achieve your requirement through API calls, and if you have SQL skills, you can query your Orchestrator database. Some examples: Disclaimer: UiPath is not responsible for running the below queries in your Orchestrator database. Run them at your own risk. https://uipath-survey.secure.force.com/CaseView/articles/Knowledge/How-to-get-a-report-for-added-queue-items-that-are-processed-completed-for-every-job-run-using-a-SQL-query https://uipath-survey.secure.force.com/CaseView/artic…

Orchestrator API's: Get the latest job ran on a machine

Hi @Mohamed_Ouahbi , Thanks for reaching out to UiPath comminity. You can make a GET request to the Orchestrator API’s /odata/Jobs endpoint with appropriate filters to find the last job for a specific machine. Get API Key: Before making API requests, you need to obtain an API key from your Orchestrator instance. You can create an API key in Orchestrator under the “Settings” > “API Access” section. Make a GET Request: In UiPath, you can use the “HTTP Request” activity to make the API requ…

Regards

[Robinnavinraj_S]

Hi @mail2jikku
By default there no distinct option is available on the UiPath Orchestrator, Instead try this methodology
Step 1 : Get the UiPath Folders using - odata/Folders API (Get Folders endpoint)
Step 2 : Loop all the folders from the response of Get Folders API
Step 3 : Inside the Loop use get Jobs activity to get all the jobs from that folder - it will give the enumerable variable
Step 4 : Finally, from the output get jobs activity, we can apply LINQ query to get the Unique Jobs. (Linq querry - jobs.Select(Function (x) x.ProcessName).Distinct.ToArray()) (jobs is the output variable from the getjobs activity )

(Note: if you want to get it for a specific timeline use the filter option, while accessing the api ex : CreationTime ge {StartOfDayDateTime})

Hope the solution solves your query

Regards,
Robinnavinraj S