Automation Suite
2023.10
false
Audit Logs Queries - Automation Suite 2023.10
Banner background image
logo
Automation Suite on Linux Installation Guide
Last updated Feb 13, 2024

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>)
  • Prerequisites
  • Getting Audit Logs Queries
  • Deleting Audit Logs
Support and Services icon
Get The Help You Need
UiPath Academy icon
Learning RPA - Automation Courses
UiPath Forum icon
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.