Viewpoint Sessions REST APIs | Data Objects | Teradata Viewpoint - 17.10 - Data Objects - Teradata Data Lab - Teradata Viewpoint

Teradata® Viewpoint and Teradata® Data Lab API Reference Guide

Product
Teradata Data Lab
Teradata Viewpoint
Release Number
17.10
Release Date
October 2021
Content Type
Programming Reference
Publication ID
B035-2215-101K
Language
English (United States)
List of sessions
{
   "content":[
      {
         "session_id":1711614,
         "computed_state":"IDLE",
         "time_in_state":181932,
         "elapsed_time":0
         "requst_redrive_spool_space":null,
         "request_hot_amp_spool":null,
         "request_spool_skew":null,
         "temp_space":0,
         "request_amp_cpu":null,
         "request_amp_io":null,
         "pji":null,
         "unnecessary_io":0,
         "cpu_use":0,
         "impact_cpu":null,
         "cpu_skew":null,
         "disk_skew":null,
         "workload_name":"WD-Default",
         "workload_method":3,
         "cpu_decay_level":0,
         "classification_mode":0,
         "virtual_partition_name":"Standard",
         "io_decay_level":0,
         "user_name":"VIEWPOINT",
         "user_account":"DBC",
         "partition_name":"DBC/SQL",
         "request_count":970025,
         "logon_source":"(TCP/IP) c6e1 10.25.112.24 SDT35124.LABS.TERADATA.COM;SDT35124COP1.LABS.TE CID=45C34336 DCS JDBC16.20.00.12;1.8.0_221 01 LSS"
         "request_start_time": null,
      "host_id": 1,
      "delta_cpu": 0,
      "delta_io": 0,
      "req_cpu_skew": null,
      "req_io_skew": null,
      "req_amp_spool": 0,
      "blocked_time": 0,
      "proxy_user": null,
      "query_band": null,
      "session_explain":[
      {
          "stepNum": 3,
          "estRowCount":    0,
          "actRowCount":    0,
          "estElapTime":    0,
          "actElapTime":    0,
          "stepText":    "Step details"
      },
      ... more records ...
   ],
   "data": {
         "per_page":100,
         "page":1,
         "total_pages":3,
         "total_elements":260,
         "number_of_elements":100,
         "first_page":true,
         "last_page":false,
   },  
   "links":[
      {
         "rel":"next",
         "href":"http://ViewpointHost/api/public/systems/123/sessions?timestamp=2018-04-09T16:48:59Z&state=Idle&perPage=100&page=2"
      },
      {
         "rel":"first",
         "href":"http://ViewpointHost/api/public/systems/123/sessions?timestamp=2018-04-09T16:48:59Z&state=Idle&perPage=100&page=1"
      },
      {
         "rel":"last",
         "href":"http://ViewpointHost/api/public/systems/123/sessions?timestamp=2018-04-09T16:48:59Z&state=Idle&perPage=100&page=3"
      },
      {
         "rel":"self",
         "href":"http://ViewpointHost/api/public/systems/123/sessions?timestamp=2018-04-09T16:48:59Z&state=Idle&perPage=100&page=1"
      }
   ]
}