- 20 Aug 2023
- 3 Minutes to read
- Print
- DarkLight
- PDF
Exporting Asset Data to CSV
- Updated on 20 Aug 2023
- 3 Minutes to read
- Print
- DarkLight
- PDF
You can export the query results table data and its view (displayed columns), from any asset page to a CSV file.
You can either export all of the query results on an asset inventory page, or export selected rows.
To export query results and view to a CSV file:
In the relevant Asset inventory page,
a. To export all data: click Export CSV on the right side of the page just above the table.
b. To export only selected rows, select the rows you want to export.
c. Click Export CSV on the right side of the page just above the table.The Export Data dialog opens.
When you have selected assets, the system shows the number of assets selected to export.
2. Specify the following:
* File name (optional, default: automatic name from date) - Set a name for the CSV file. A default name appears for the CSV file, with the format axonius-data_< date >T< time >UTC.csv. For example: axonius-data_2020-04-13T07-18-41UTC.csv. You can click and type to change the name.
* Split by asset entities (required, default: false) - Select to create a CSV file where each entity on an asset is shown as a separate row. This separates each asset as the 'expand' option in the application. It separates each asset by its entity. For example, you will be able to know which values were fetched from each adapter connection.
* If supplied, each value on an asset is shown as a separate row.
* If not supplied all values on an asset are in the same cell on the CSV file.
* Split by field values (optional, default empty) - Choose field value - For complex fields and lists you can create a CSV file where the values of complex fields and lists are represented as separate rows in the file. From the drop-down box select the value that you want to display in the file, 'Tags' for instance. Only fields that have been discovered are available. For example, if you export by Installed Software, you will be able to see each installed Software name and its version.
* Don't split complex objects into columns (optional, default: false) - When selected, complex objects appear in a single column in JSON format. By default, each field in a complex object is split into a separate column in the CSV file.
Exclude parent complex objects columns - Select to hide the parent field of complex fields in exported files.
Delimiter to use for multi-value fields (optional, default: Export CSV delimiter to use for multi-value fields field under the System Settings section in the GUI Settings) - Specify a delimiter to separate between values within the same field of an exported CSV file.
- If supplied, values within the same field will be separated by the specified delimiter once the CSV file has been generated.
- If not supplied, values within the same field will be separated by the value defined in the Export CSV delimiter to use for multi-value fields field under the UI Settings section in the System Settings. The default value is "\n" (new line).
Maximum rows (optional, default: 1048500) - Specify the maximum number of rows to be included in the CSV file. When you enter a value the generated CSV file includes the top x rows, based on the specified values. This option can be useful to export only the top results and to improve the CSV file generation time, otherwise the generated CSV file includes the default maximum rows, set as 1048500.
Click Export. The Export CSV shows a spinning icon to the left of the button while the file is being generated.
The CSV file is automatically downloaded.