Exporting a Query-based View
Save some or all of the data that was retrieved by the query for a view in a text (.txt) file or comma separated value (.csv) file for further manipulation in another software application.
When you open or refresh a workspace, the queries assigned to the table and chart views are sent to the Marvel Enterprise Monitoring Server, which returns the requested data from the managed systems. Any filters applied to views reduce what displays, such as only the relevant four columns of a seven-column table or only the processes that are using the most memory.
When you export a query-based view, you can save everything returned by the query before any filters are applied. This includes every column queried or only those you select; every row returned or, if there are multiple pages, only the rows from the displayed page. Also, if you save the data to an existing file, you can choose to append the data or to overwrite the previous version. Take these steps to save the data you select from the view to a .txt or .csv file:
- Open the workspace with the query-based view whose results you want to save.
-
Because the current data display is exported, click
Refresh if you want the latest results.
-
If this is a table, pie chart or bar chart view with multiple pages and you
want to save a particular page rather than all rows, click
or
at the ends of the vertical scroll bar (or type the number in the Page text box) until it displays. A page is 100 rows by default. You can change the view's page size by clicking
and changing the View-level Page Size value in the Query tab.
-
Right-click inside the query-based view and click
Export.
- In the Export to Disk window, select the location for the exported data, select a file type, and type a file name.
-
To export the rows that are visible in the view space and all the columns shown
in the Assigned list, click OK; or, to specify otherwise, do any
of the following:
- If the file you are saving already exists, you can choose to overwrite the file with the current data selection, append the data to the file, or cancel.