Automation Suite on Linux installation guide

Audit Logs Queries

Prerequisites

Before downloading audit logs for Apps in the Automation Suite setup, the following requirements must be met:

You must have access to the machine or virtual machine (VM) where UiPath® services are hosted.

Optionally, you need to know the following:

Organization name for which the audit logs are needed (<orgName>).
User email for whom the audit logs need to be exported or deleted (<userEmail>).
Number of days between now and the day you want to get or delete audit logs for (<numDays>).

Getting Audit Logs Queries

SELECT document FROM [UipathApps].[audit-logs] 
WHERE JSON_VALUE(document, '$.__tenantId') = '<orgName>' and 
JSON_VALUE(document, '$.userInfo.userEmail') = '<userEmail>' and 
CONVERT(datetime, JSON_VALUE(document, '$.createdAtDate')) <= (getdate() - <numDays>)
SELECT document FROM [UipathApps].[audit-logs] 
WHERE JSON_VALUE(document, '$.__tenantId') = '<orgName>' and 
JSON_VALUE(document, '$.userInfo.userEmail') = '<userEmail>' and 
CONVERT(datetime, JSON_VALUE(document, '$.createdAtDate')) <= (getdate() - <numDays>)

Deleting Audit Logs

DELETE FROM [UipathApps].[audit-logs] 
WHERE JSON_VALUE(document, '$.__tenantId') = '<orgName>' and 
JSON_VALUE(document, '$.userInfo.userEmail') = '<userEmail>' and 
CONVERT(datetime, JSON_VALUE(document, '$.createdAtDate')) <= (getdate() - <numDays>)
DELETE FROM [UipathApps].[audit-logs] 
WHERE JSON_VALUE(document, '$.__tenantId') = '<orgName>' and 
JSON_VALUE(document, '$.userInfo.userEmail') = '<userEmail>' and 
CONVERT(datetime, JSON_VALUE(document, '$.createdAtDate')) <= (getdate() - <numDays>)

On this page

Prerequisites
Getting Audit Logs Queries
Deleting Audit Logs

Was this page helpful?

PREVIOUSApps

NEXTDocument Understanding

Automation Suite on Linux installation guide

Prerequisites​

Getting Audit Logs Queries​

Deleting Audit Logs​

Was this page helpful?

Prerequisites

Getting Audit Logs Queries

Deleting Audit Logs