Exporting grids in the background

Overview

Orchestrator objects are displayed on their dedicated page, in a grid with various columns that are helpful to describe the status of that object.

You can export these grids to get a batch of data you can later use to create dashboards or reports. The exporting operation takes place in the background, meaning you can continue to interact with Orchestrator without having to wait for the export to finish, as a notification informs you when the download is ready.

The download format is .csv, which makes it data-analysis compliant, and you can access it from the My Reports page.

Orchestrator objects available for export

You can export the grids of the following Orchestrator objects:

• At tenant level
  • Audit logs
  • Test Automation Audit logs
• At folder level
  • Queue transactions
  • Logs
  • Jobs

The exported report

Clicking the Export button creates a copy of the grid in the My reports page. A pop-up informs you when the export starts and when or if it completes.

Once the export is complete, you receive an alert letting you know that the data has been exported. The report is downloaded automatically in the background, to your browser's default download location, if you have the View on Alerts permission. However, you can also visit the My reports page and download the report at your own convenience.

The My reports page only displays the exports you created in the last 168 hours (7 days x 24 hours). Exports older than 168 hours are permanently deleted. For example, an export created on the 1st at 00:00 is available until the 7th at 23:59.

To see your exports, click the My reports icon on the top navigation bar.

You can see the following properties of an export:

• Export type - refers to the Orchestrator object
• Created on - the relative timestamp of when you created the export
• Created on (absolute) - the exact timestamp of when you created the export. Absolute timestamps are rendered in the tenant time zone. For triggers, the next run time is rendered in the trigger time zone which may differ from the tenant time zone.
• Available until - the date when the export is to be removed from the list. Reports are removed at 00:00 on the specified date.

  This is only displayed once the report has been exported.

• Size - the size of the export. This is only displayed once the report has been exported.

• Status - the status of the export operation:

  • New - the export is in progress.
  • Completed - the export finished.

  • Failed - the export failed. This may be generated by SQL timeout, or low storage. You need to manually retry the export.

    The computing time to resolve the export is maximum 15 minutes. After this time, the export fails. Before retrying the export, apply additional filters to your data.

    Important:

    To prevent the failure of exports with a large amount of data:

    • You must use the API endpoints for the corresponding Orchestrator object. For example, use /odata/AuditLogs/UiPath.Server.Configuration.OData.Export to export Audit logs.

    • The volume of generated exports both in terms of frequency and amount of data retrieved, can affect the performance of your tenant. If performance is affected, we might throttle or block such requests to ensure your automations are not affected by this behaviour.

    • Apply filters to reduce the amount of exported data.

To download the data to your device, click the Download button for the desired report. This operation uses the default download location on your device. The report is downloaded as an archive, which contains the .csv file of the grid filtered data.

The .zip and the .csv files are named using the following the naming conventions:

Exported object type	Download file naming convention
Queue transactions	{queue-name}-items-{export-date}-{export-timestamp}-{export-id} If the queue name contains invalid characters (\ / : * ? " < > |), they are replaced with _.
Audit logs	audit-logs-{export-date}-{export-timestamp}-{export-id}
Logs	robot-logs-{export-date}-{export-timestamp}-{export-id}
Jobs	jobs-{job_folder_key}-{export-date}-{export-timestamp}-{export-id}

Where:

• {queue_name} - the name of the queue containing the exported queue items

• {job_folder_key} - the ID of the folder from which the job grid was exported

• {export_date} - the date when the export was created, in the yyyy-MM-dd format
• {export_timestamp} - the time when the export was created , in the HH-mm-ss-fff format
• {export-id} - the ID of the export

For example, an export download file for an audit logs grid could be named audit-logs-2023-01-27-12-29-40-843-24.zip.

Important:

Time columns in exported reports are expressed in the tenant's timezone.

Important considerations on API exports

• The $select, $top, $skip, $orderBy, and $count keywords in our export API are not supported, and we strongly advise that you avoid using them. Please use appropriate filters instead.
• Report entries are only sorted by Id, i.e. $orderBy=Id. Any other parameters used for the $orderBy keyword are ignored.
• Filtering through a $filter= structure only allows the fields marked as available in the table.

• Using any of the unsupported fields, as described in the following tables, returns a 400 error.

Fields supported for queue transactions API exports

The following table lists the fields that are available in the report generated by exporting queue transactions via API, and indicates whether these fields are allowed for filtering.

API field	Corresponding column in the exported report	Allows filtering
QueueDefinitionId	N/A
Status	Status
ReviewStatus	Revision
Reference	Reference
ProcessingExceptionType	Exception
DueDate	N/A
DueDateAbs	Deadline (absolute)
Priority	Priority
RobotName	Robot
DeferDate	N/A
DeferDateAbs	Postpone (absolute)
StartProcessing	N/A
StartProcessingAbs	Started (absolute)
EndProcessing	N/A
EndProcessingAbs	Ended (absolute)
SecondsInPreviousAttempts	Transaction Execution Time
AncestorId	AncestorId
AncestorUniqueKey	AncestorUniqueKey
RetryNumber	Retry No.
ManualAncestorId	Manual AncestorId
ManualAncestorUniqueKey	Manual AncestorUniqueKey
ManualRetryNumber	Manual Retry No.
UniqueKey	UniqueKey
SpecificData	Specific data
Key	Key
ReviewerName	Reviewer Name
ProcessingExceptionReason	Exception Reason
Output	Output
RobotId	N/A
ReviewerUserId	N/A
Analytics	Analytics Data
CreationTime	N/A
CreationTimeAbs	Created (absolute)

Fields supported for audit logs API exports

The following table lists the fields that are available in the report generated by exporting audit logs via API, and indicates whether these fields are allowed for filtering.

API field	Corresponding column in the exported report	Allows filtering
Parameter	N/A
DisplayName	N/A
Action	Action
Component	Component
UserId	N/A
ExecutionTime	N/A
OperationText	Operation
ExecutionTimeAbs	Time (absolute)
ServiceName	N/A
MethodName	N/A
EntityId	N/A
UserType	N/A
UserIsDeleted	N/A
ExternalClientId	N/A
UserName	User

Fields supported for robot logs API exports

The following table lists the fields that are available in the report generated by exporting robot logs via API, and indicates whether these fields are allowed for filtering.

API field	Corresponding column in the exported report	Allows filtering
JobKey	N/A
TimeStamp	Time (absolute)
Level	Level
ProcessName	Process
HostMachineName	Hostname
WindowsIdentity	Host Identity
Message	Message
RawMessage	N/A
RobotName	Robot Name
MachineId	N/A
MachineKey	N/A
RuntimeType	N/A

Fields supported for jobs API exports

API field	Corresponding column in the exported report	Allows filtering
CreationTime	N/A
SourceType	N/A
State	State
SpecificPriorityValue	Priority
HostMachineName	Hostname
LocalSystemAccount	Host Identity
MachineName	Machine
Key	Key
JobPriority	N/A
ReleaseName	Process
RobotName	Robot
MachineScope	N/A
EnvironmentName	Environment
Type	Job type
RuntimeType	Runtime type/license
StartTime	N/A
StartTimeAbs	Started (absolute)
EndTime	N/A
EndTimeAbs	Ended (absolute)
ProcessType	N/A
Source	Source
CreationTimeAbs	Created (absolute)
ServerlessJobType	N/A
StartingScheduleId	N/A
Release	N/A
Machine	N/A
Robot	N/A

Export alerts

All exports you create are logged on the Alerts page, provided you have the proper permissions. Completed exports are logged with the Info severity, while failed exports are logged with the Error severity.

By default, you receive alert emails about completed or failed exports. You can unsubscribe from these alerts by navigating to the Alert Preferences page and unselecting the Export option.