9.6.3. Exporting query results

Table and chart views show the results of the assigned query, plus any filters you have applied. You can use the export feature to save the results as a text file, either TXT or Comma Separated Values (CSV), for use in other programs.

When saving the results, you can select additional columns from the query, even if they were filtered out of the view, or fewer columns. Furthermore, you can save all the rows that were returned or, if there are multiple pages, just those on the current page.

Use the following steps to export your query results:

1.Expand the following Navigator items by clicking on the plus (+) sign by each subsequent item until you get to the Windows(R) OS.

a.Enterprise

b.Windows System

c.<system you are monitoring>

d.Windows OS

2.Click System.

3.Open the workspace with the table or chart view whose query results you want to save.

4.Right-click inside the table or chart view and select Export from the popup menu.

5.In the Export window, select the location for the exported data, the file type, and enter a file name.

6.To export all rows of the columns shown (Assigned column), click OK; or if you have a query that is more than one page in length, do any of the following:

a.For the displayed page instead of all rows, click Current page.

b.To add a column to those being exported, select from Available Columns and click the left arrow; to exclude a column, select from the Assigned list and click the right arrow.

c.To change the order, select a column and click the up arrow or down arrow.

7.Click OK to close the window.

Use Ctrl+click to select multiple columns or Shift+click to select all columns from the first one selected to this point.