Exporting Patch Data for Windows Assets
You can export detailed patch data from the Patches and Assets tabs. You can download job progress details from the Job Progress option on the Jobs tab. You must have an active Patch License to be able to export the data.
You can also view the list of reports generated and their statuses.
Exporting the patch data allows to import the data to a preferred analytic
tool, such as Tableau.
For example, you can analyze the data and calculate compliance ratio to
make sound decisions or you can use the patch data to identify patches
that were missed based on the severity of the critical assets.
You can now overlay the Patch data with other business data to set a new context for analysis. Exporting allows you to integrate data from different systems and view it on a single pane of glass.
Note the following important points:
- At a given time, you can access only 5 latest reports per user.
- The generated report files are retained for 7 days. After that the report data is deleted.
- You can use filters or search functionality to select the data that you want to export.
- You can download the reports in the CSV format in a Gzip file. The reports are available to download in the universal CSV format separated by commas and enclosed in double quotes. Due to repetitive text items in the CSV file, we have provided a compressed version in a Gzip file for a quick and efficient access.
- We recommend that you use 7zip or any other zipping tool to unzip the report file.
- Currently, we support only the fixed columns shown on the UI that are exported in the report.
- The report file size is limited to 1 GB after the data is compressed.
- Any references to data or time in the report should be considered in the UTC time stamps.
What data is included?
The CSV file contains the data visible on the UI plus data for a few more columns which are not visible on the UI. Following are the columns that are not visible on the UI but are included in the CSV file:
| Patches tab | - ASSET ID - ASSET NAME - OPERATING SYSTEM - ASSET STATUS |
| Assets tab | - PATCH ID - PATCH TITLE - PUBLISHED DATE - ARCHITECTURE - CATEGORY - BULLETIN - KB - QID - CVE - SEVERITY |
| Jobs Progress tab | - PATCH ID - PATCH TITLE - PUBLISHED DATE - ARCHITECTURE - CATEGORY - BULLETIN - KB - QID - CVE - SEVERITY - REASON - REASON CODE - OS STATUS - EXIT CODE - HTTP STATUS |
How to Export Patch Data?
To export patch data, go to the Patches
or Assets tab and click 
:
The Report Download Request Status page lists all the reports that are
ready to download or are being generated. Once the reports are generated,
click to download the report
and then simply unzip the file to view the data.
You can also export the data from the Job Progress tab. To download
the individual job details. go to Jobs > Quick Actions > View Progress
> .
