Orchestrator
latest
false
Exporting grids in the background - Automation Cloud latest
logo
Orchestrator User Guide
Last updated Nov 30, 2023

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. All the filters applied to the grid are persisted in the export copy. 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
  • 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.

Note:

To download exports to your device, you need to add the storage domains to your allowlist. More info here.

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.

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.

Read more about Alerts.

logo
Get The Help You Need
logo
Learning RPA - Automation Courses
logo
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2023 UiPath. All rights reserved.