Orchestrator logs are available for How much time Orchestrator

Hi Team,

The Orchestrator logs are available for How much time Orchestrator ? Is there any time duration and after that logs will get deleted autimatically ?

Regards,
Shirish

1 Like

Hi
Its all based on the setting we have made in the orchestrator
kindly have a look on this on how to manage the logs in orchestrator


Cheers @Shirish

1 Like

I dont see any particular time period in days for logs will be available there. Please tell us the exact time for which logs will be available.

@Palaniyappan

Where we can do the setting in Orchestrator ?

1 Like

@Shirish
The Logs page in Orchestrator reads from the Logs table in the Orchestrator SQL database. As long as the logs are in the database they’ll be available in Orchestrator. You should regularly delete older Logs from this database depending on how much space you have in your system. For example, we delete Logs older than two months to keep the table size down.

3 Likes

we dont have any particular timing on how long the logs be available,
but we can manage them from orchestrator and the one i shared are the one that describes, like managing in the sense we can delete the logs after certain amount of time say for 45 days, as uipath even recommend deleting log messages that are older than 45 days. The example query below deletes old messages with level Info, older than 45 days. Optionally, include the TenantId, or comment out the line and level = 2 to delete all the logged messages, regardless of their level.

It can be executed manually or scheduled in an SQL Server Job in the database provided to you while installing orchestrator(enterprise edition)

SQL
Copy
DELETE FROM [UiPath].[dbo].[Logs]
/*
0 = Verbose, 1 = Trace, 2 = Info,
3 = Warn, 4 = Error, 5 = Fatal
/
where 1=1
and level = 2
– and TenantId = 1 – default tenant
and DateDiff(day, TimeStamp, GetDate()) > 45
DELETE FROM [UiPath].[dbo].[Logs]
/

0 = Verbose, 1 = Trace, 2 = Info,
3 = Warn, 4 = Error, 5 = Fatal
*/
where 1=1
and level = 2
– and TenantId = 1 – default tenant
and DateDiff(day, TimeStamp, GetDate()) > 45

for more info on this

and for this
Where we can do the setting in Orchestrator ?
we wont be able to manage them directly from the orchestrator but with the database

hope this would help you
Cheers @Shirish

Thank You!! Suppose if we have exclude any columns , writing them into logs then how we can acheive the same.?

1 Like

Kindly come again once with that elaborately a bit more buddy
Sorry I didn’t get that
Cheers @Shirish