Data Extracts

A Data Extract allows you to access data such as historical patching activity and audit logs in a download file. This describes how you can view, generate, and download data extracts from the Automox console.

Viewing Data Extracts

You can view previously created data extracts from the Data Extracts page.

  1. From the Reports page, click View for Data Extracts.

  2. If any data extracts are available, you can click to download them. If no extracts are available, you can generate a new extract.

  3. The Data Extracts table consists of the following columns:

Column nameDescription
Data RequestedExact time and date when the extract was generated.
Date RangeStart and end dates of the requested extract.
Extract ExpirationTime and date the extract will no longer be available for download. After this date, the Status shows as expired. Note: Extracts are available for 24 hours.
StatusThis can show the following statuses:
  • Queued
  • Running
  • Complete
  • Failed
  • Canceled
  • Expired


Note: The table can be sorted by Date Requested or Status.

Note: If you see a failed state, contact Automox Support. Provide the Data Extract ID so that we can help diagnose what went wrong.

Generating Data Extracts

You can generate an extract that provides details about patch activity for a defined time period.

  1. From the Reports page, click View for Data Extracts.

  2. Click Generate New.

  3. Enter the start date and end date for the extract you want to generate. You can generate an extract that is a maximum of 90 days. This represents the 90-day time frame leading up to the day before the extract is issued. For example, on 2020-12-01 the default time-frame start should be 2020-09-02 and it should end with 2020-11-30.

  4. Click Generate.
    Note: This process can take several minutes.

  5. You can view the process and status of the new extract on the Data Extracts page.

Downloading Data Extracts

You can download and save data extracts that you have created. 

Note: Extracts are only available to be downloaded for 24 hours after being created.

  1. From the Reports page, click View for Data Extracts.

  2. On the Data Extracts page, find the extract you want to view and click Download.

  3. The extract (CSV) includes the following information for the time frame requested:

Data TypeField NameDescription
Device informationDevice NameName of device (typically hostname)

Device Custom NameName assigned to the device by the customer.

Agent VersionVersion of the Automox agent installed on the device

GroupName of the group this device is assigned to

Device IgnoredThis indicates if a software package is ignored for a device (from the Device Details)

Group IgnoredThis indicates if a software package is ignored globally from the Software page
Patch InformationPatch NameName of the software update (patch)

Patch VersionVersion number of the software update

Patch Knowledge BaseKnowledge base identifier associated with the update
Mutual Device/Patch InformationOperating System FamilyOS family (Windows, Mac, or Linux)

Operating System NameOS name of the installed system

Operating System VersionInstalled OS version

Managed PatchThis shows if the update is managed by Automox
Event DataEvent TimestampTimestamp of the event

Event Type (patch action)"Patch available" or "Patch installed"

Patch Available TimestampTimestamp that informs when patch became available for installation

Patch Installed TimestampTimestamp that informs when patch was installed on the device

Exposure TimeAmount of time the device was not updated with the available patch
Vulnerability DataPatch SeveritySeverity (if any) of vulnerability associated with the patch (for example: critical, high, medium, low)

CVEsCVEs (if any) associated with the patch