Antoine_Sauteron_1266

Step to Remove Specific Execution in ARA

Discussion created by Antoine_Sauteron_1266 on Nov 20, 2017
Latest reply on Nov 20, 2017 by AmarGupta609070
We need a solution to remove :

A - Specific Executions from ARA. e..g. ARA process run id : 2057279, 2065202
B - All executions for a specific Application.


A - The parameter you are looking for is "--id"

example :
DB-cleanup --id "2057279,2065202"


B - You can use the parameters below :
  • "--applications" : name of the application(s)
  • "--olderthan" : set to "0" to remove all executions (--olderthan 0 = older than today).
  • "--keepatleast" : set to "0" to remove all executions - no minimum number of executions to be kept.
example :
DB-cleanup --applications "MyAppNumber1, MyAppNumber2" --olderthan "0" --keepatleast "0"



Foot note:

1 - you can get the list of parameters with the DB-cleanup -help command.
DB-cleanup -help
INFO : Parsing options from application config file
INFO : Parameters from configuration file:
INFO :     olderThan =
INFO :     keepAtLeast =
INFO :     applications =
INFO :     workflows =
INFO :     archivedOnly =
INFO :     force = false
INFO :     verbose = max
INFO :     fi =
INFO :     id =
DBCleanup 8.0.0.0
Copyright © Automic Software GmbH

  --connectionString    Connection string to the ARA database.

  --olderThan           Only executions having an end-date older than the
                        specified number of days are considered. Default is 90.

  --keepAtLeast         Defines how many executions must remain per workflow
                        independent from their end date. Default value is 5.

  --applications        Comma-separated list of application names. If set, only
                        executions of the specified applications are considered.

  --workflows           Comma-separated list of workflow names. For application
                        workflows this parameters has to be set in conjunction
                        with the applications parameter. If the applications
                        parameter is not set, only general workflows are
                        considered.

  --archivedOnly        Flag whether only archived executions should be
                        deleted. Default value is False.

  --force               Flag whether the utility should also delete executions
                        that belong to a current installation. Default value is
                        False

  --verbose             Level of textual output to screen or log file. Possible
                        values: min, med, and max. Default is min.

  --fi                  Optionally mirror screen output to a log file. Messages
                        will have timestamp appended before it.

  --id                  Comma-separated id of executions to be deleted. At
                        most, you can specify 100 executions id using this
                        switch.

  --ignorestatus

  --help                Display this help screen.

2 - You can hardcode settings in "DB-Cleanup.exe.config" with <add key> tags.

example:
<add key "applications" value="MyApp1,MyApp2">


Best regards,
Antoine

Outcomes