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.

About this task

When you open or refresh a workspace, the queries assigned to the table and chart views are sent to theCloud Pak System Software 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:

Procedure

  1. Open the workspace with the query-based view whose results you want to save.
  2. Because the current data display is exported, click refreshRefresh if you want the latest results.
  3. 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 Next page or Previous page 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 Edit propertiesProperties editor - workspace and changing the View-level Page Size value in the Query tab.
  4. Right-click inside the query-based view and click export data Export.
  5. In the Export to Disk window, select the location for the exported data, select a file type, and type a file name.
  6. 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 tasks:
    • For the all pages returned by the query, click Radio button selectedAll rows.
    • To exclude a column from those being exported, select from the Assigned list and click right arrow; to include a column, select it from the Available Columns list and click left arrow. Use Ctrl+click to select multiple columns or Shift+click to select all columns from the first one selected to this one.
    • To change the order, select a column and click up or down.
    If this is a new, unsaved table or chart view, Radio button selected Visible rows is selected for you.
  7. 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.