Create Orchestrator Cleanup Objects

Help Orchestrator
1

I need to archive and delete logs before updating orchestrator.
I have two scripts CreateOrchestratorCleanupObjects.sql, RunOrchestratorCleanup.ps1
In what sequence do I need to run them to delete logs not older than 45 days ? And what do I need to change in the script to do this ? I need to save all queue and queue elements at the same time

2

@Arettu63

You need show the scripts…depending on that there can be suggestions

Cheers

3

these are standard scripts from the official site

4

@Arettu63

if you scrll a little you would find this

The image shows a table with three columns detailing the parameter "daysOld," which allows retention of a specified number of days' worth of data using the dateTimeColumn, with a minimum setting of 2 days. (Captioned by AI)
The image shows a table with three columns detailing the parameter "daysOld," which allows retention of a specified number of days' worth of data using the dateTimeColumn, with a minimum setting of 2 days. (Captioned by AI)1063×265 25.9 KB

change to 45 as needed

cheers

5

There is a powershell script run on the same page, here is an example:
.\RunOrchestratorCleanup
-SourceConnectionString “Data Source=.;Initial Catalog=UiPath;User ID=sa;Password="
-DestinationConnectionString "Data Source=.;Initial Catalog=;User ID=sa;Password=”
-CleanupConfigXml ‘

’

I’m not quite sure how to fill in the first two lines correctly.
Data Source=. Is this where the connection string is supposed to go?
Initial Catalog=UiPath. here you need to specify sql database ?
User ID=sa. Here we specify the user or his id and how to find this id ?
If you have an example, please send it to me.

6

@Arettu63

Thats basically the connection string…and you can get the string directly from your team as well…or you can use this site to get the connection string…but what you gave above is what it means

Cheers

7

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