Go to main content

Oracle® ZFS Storage Appliance Analytics Guide, Release OS8.8.0

Exit Print View

Updated: November 2018
 
 

Viewing a Dataset in a CSV Format (CLI)

Use the following information to view data from a dataset in a CSV format. To download a dataset to a CSV file, see Downloading a Dataset to a CSV File (BUI).

  1. Go to analytics worksheets.
    hostname:> analytics worksheets
  2. Enter show to view a list of saved worksheets.
    hostname:analytics worksheets> show
    Worksheets:
    
    WORKSHEET       OWNER   NAME
    worksheet-000   root    example_1
    worksheet-001   root    example_2
  3. Enter select and the worksheet that contains the dataset for which you want to view the data.
    hostname:analytics worksheets> select worksheet-000
  4. Enter show to view a list of datasets in the worksheet.
    hostname:analytics worksheet-000> show
    Properties:
                              uuid = 66d05260-8d26-4b69-aae5-f98391048af0
                              name = example_1
                             owner = root
                             ctime = 2016-12-8 23:55:58
                             mtime = 2016-12-8 23:56:09
    
    Datasets:
    
    DATASET      DATE        SECONDS NAME
    dataset-000  -                60 arc.accesses[L2ARC eligibility]
    dataset-001  -                60 cap.bytesused[pool]
  5. Enter select and the dataset for which you want to view the data.
    hostname:analytics worksheet-000> select dataset-000
  6. Enter csv.
    hostname:analytics worksheet-000 dataset-000> csv
    Time (UTC),Value per second
    2016-12-09 00:02:31,40599
    2016-12-09 00:02:32,20134
    2016-12-09 00:02:33,22425
    2016-12-09 00:02:34,3954
    2016-12-09 00:02:35,2185