openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/MSS_GET_SESCONREQ:
    post:
      tags:
      - SFMSS_PERF
      summary: retrieve the connections,session,request data for active requests
      operationId: /rfc/MSS_GET_SESCONREQ
      requestBody:
        content:
          application/json:
            schema:
              properties:
                ACT_REQS_ONLY:
                  type: string
                  default: N
                  maxLength: 1
                  description: Single-Character Flag
                CON_NAME:
                  type: string
                  default: DEFAULT
                  maxLength: 30
                  description: Logical name of a database connection
                ENG_CONS_INCLUDED:
                  type: string
                  default: N
                  maxLength: 1
                  description: Single-Character Flag
                ONE_HOST:
                  type: string
                  default: N
                  maxLength: 128
                  description: Hostname of the application server logged into SQL Server.
                ONE_LOGIN:
                  type: string
                  default: N
                  maxLength: 128
                  description: Name of sp_configure parameter
                ONE_WP:
                  type: string
                  default: N
                  maxLength: 256
                  description: Name of the application program which owns the connection.
                SAP_SPIDS_ONLY:
                  type: string
                  default: N
                  maxLength: 1
                  description: Single-Character Flag
                SCHEMA:
                  type: string
                  default: ' '
                  maxLength: 128
                  description: Target schema
                REQSTATS:
                  type: array
                  items:
                    type: object
                    properties:
                      SESSIONID:
                        type: integer
                        format: int32
                        description: Session ID for SQL Server
                      LOGINTIME:
                        type: string
                        maxLength: 24
                        description: The time at which client process logged into SQL Server.
                      HOSTNAME:
                        type: string
                        maxLength: 128
                        description: Hostname of the application server logged into SQL Server.
                      PROGNAME:
                        type: string
                        maxLength: 256
                        description: Name of the application program which owns the connection.
                      HOSTPID:
                        type: integer
                        format: int32
                        description: Process ID on app. server
                      CLIENTINFVER:
                        type: integer
                        format: int32
                        description: MSS Session client interface name
                      CLIENTINFNAME:
                        type: string
                        maxLength: 64
                        description: MSS Session client interface name
                      LOGINNAME:
                        type: string
                        maxLength: 128
                        description: The user name used to log into the SQL Server database
                      NTDOMAIN:
                        type: string
                        maxLength: 256
                        description: NT domain for the client connected to SQL Server.
                      NTUNAME:
                        type: string
                        maxLength: 256
                        description: Windows NT user name for the process connected to SQL Server
                      CPUTIME:
                        type: integer
                        format: int32
                        description: CPU time for a SQL session (ms)
                      MEMUSAGE:
                        type: integer
                        format: int32
                        description: The pages allocated by the SQL process in procedure cache.
                      TTLSCHEDTIME:
                        type: integer
                        format: int32
                        description: SQL Server session scheduled time
                      TTLELAPSEDTIME:
                        type: integer
                        format: int32
                        description: SQL Server session elapsed time
                      SESS_NUMREADS:
                        type: integer
                        format: int64
                        description: number of reads performed in a session
                      SESS_NUMWRITES:
                        type: integer
                        format: int64
                        description: Number of writes performed in a session
                      SESS_NUMLOGICALREADS:
                        type: integer
                        format: int64
                        description: number of reads performed by a session
                      TRXISOLEVEL:
                        type: string
                        maxLength: 12
                        description: MSS Transaction Isolation level
                      CONNECTIONID:
                        type: string
                        maxLength: 36
                        description: SQL Server connection id
                      PARENT_CONNID:
                        type: string
                        maxLength: 36
                        description: SQL Server parent connection id
                      CONN_SESSIONID:
                        type: integer
                        format: int32
                        description: Session ID running on connection
                      CONNECT_TIME:
                        type: string
                        maxLength: 24
                        description: Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS
                      NET_TRANSPORT:
                        type: string
                        maxLength: 80
                        description: The network transport type used by the connection
                      PROTOCOL_TYPE:
                        type: string
                        maxLength: 80
                        description: The network transport protocol used by the connection
                      CONN_NUMREADS:
                        type: integer
                        format: int32
                        description: SQL Server connection number of reads over the connection
                      CONN_NUMWRITES:
                        type: integer
                        format: int32
                        description: SQL Server conneciton number of writes over the connection
                      LAST_READ:
                        type: string
                        maxLength: 24
                        description: Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS
                      LAST_WRITE:
                        type: string
                        maxLength: 24
                        description: Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS
                      NET_PACKET_SIZE:
                        type: integer
                        format: int32
                        description: SQL Server packet size
                      CLIENT_NET_ADDR:
                        type: string
                        maxLength: 40
                        description: Connection network address
                      REQ_SESSIONID:
                        type: integer
                        format: int32
                        description: Session ID associated with the request being processed
                      REQUESTID:
                        type: integer
                        format: int32
                        description: SQL Server Request ID
                      START_TIME:
                        type: string
                        maxLength: 24
                        description: Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS
                      STATUS:
                        type: string
                        maxLength: 60
                        description: SQL Server process status; ie sleeping, running etc.
                      COMMAND:
                        type: string
                        maxLength: 32
                        description: Command currently being executed by the given process id
                      SQLHANDLE:
                        type: string
                        maxLength: 128
                        description: handle pointing to sql statment  or procedure
                      STMT_START_OFFSET:
                        type: integer
                        format: int32
                        description: SQL Server int4
                      STMT_END_OFFSET:
                        type: integer
                        format: int32
                        description: SQL Server int4
                      PLAN_HANDLE:
                        type: string
                        maxLength: 128
                        description: handle pointing to plan used in execution of sql stmt/proc
                      DBNAME:
                        type: string
                        maxLength: 128
                        description: Database name
                      USERNAME:
                        type: string
                        maxLength: 128
                        description: The user name used to log into the SQL Server database
                      REQ_CONNECTIONID:
                        type: string
                        maxLength: 36
                        description: SQL Server connection id
                      BLOCKING_SESSION_ID:
                        type: integer
                        format: int32
                        description: Blocking session ID for SQL Server
                      WAIT_TIME:
                        type: integer
                        format: int32
                        description: Current wait time of the process in milliseconds
                      LAST_WAIT_TYPE:
                        type: string
                        maxLength: 64
                        description: The locked resource process is waiting for (object ID).
                      WAIT_RESOURCE:
                        type: string
                        maxLength: 255
                        description: Name of the locked resource the process is waiting for.
                      OPEN_TRAN_CNT:
                        type: integer
                        format: int32
                        description: Number of open transactions for the SQL Server process
                      OPEN_RESULTSET_CNT:
                        type: integer
                        format: int32
                        description: Number of open result sets  for the SQL Server process
                      TRANSACTION_ID:
                        type: integer
                        format: int64
                        description: Transaction identifier request executes under
                      PERCENT_COMPLETE:
                        type: integer
                        format: int64
                        description: Percentage complete
                      EST_COMPLETION_TIME:
                        type: integer
                        format: int64
                        description: Estimated Completion time of SQL Request
                      REQ_CPUTIME:
                        type: integer
                        format: int32
                        description: CPU time for a request
                      REQ_TTLTIME:
                        type: integer
                        format: int32
                        description: Total elapsed time utilized by a request
                      SCHED_ID:
                        type: integer
                        format: int32
                        description: ID of the scheduler used for the request
                      REQ_NUMREADS:
                        type: integer
                        format: int64
                        description: number of reads performed by the request
                      REQ_NUMWRITES:
                        type: integer
                        format: int64
                        description: number of writes performed in a request
                      REQ_NUMLOGICALREADS:
                        type: integer
                        format: int64
                        description: number of reads performed by a request
                      REQ_ROWCOUNT:
                        type: integer
                        format: int64
                        description: SQL Server count of rows returned
                      SQLTEXT:
                        type: string
                        maxLength: 50
                        description: First 50 characters of a SQL Server statement
                      OBJECT_NAME:
                        type: string
                        maxLength: 30
                        description: MS SQL Server object name
                      ABAP_NAME:
                        type: string
                        maxLength: 40
                        description: Name of the ABAP report
                      ABAP_LOC:
                        type: integer
                        format: int32
                        description: Offset of a Processing Control Block
                      SAP_USER:
                        type: string
                        maxLength: 12
                        description: The user name in the SAP system.
                      CPU_TTL:
                        type: integer
                        format: int32
                        description: MS SQL Server cumulative cpu time
                      READS_TTL:
                        type: integer
                        format: int64
                        description: Total number of reads performed by a session and request
                      WRTS_TTL:
                        type: integer
                        format: int64
                        description: Total number of writes performed
                      LOGRDS_TTL:
                        type: integer
                        format: int64
                        description: Total number of reads performed
                      WPNAME:
                        type: string
                        maxLength: 2
                        description: ID of the R3 work process
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  REQSTATS:
                    type: array
                    items:
                      type: object
                      properties:
                        SESSIONID:
                          type: integer
                          format: int32
                          description: Session ID for SQL Server
                        LOGINTIME:
                          type: string
                          maxLength: 24
                          description: The time at which client process logged into SQL Server.
                        HOSTNAME:
                          type: string
                          maxLength: 128
                          description: Hostname of the application server logged into SQL Server.
                        PROGNAME:
                          type: string
                          maxLength: 256
                          description: Name of the application program which owns the connection.
                        HOSTPID:
                          type: integer
                          format: int32
                          description: Process ID on app. server
                        CLIENTINFVER:
                          type: integer
                          format: int32
                          description: MSS Session client interface name
                        CLIENTINFNAME:
                          type: string
                          maxLength: 64
                          description: MSS Session client interface name
                        LOGINNAME:
                          type: string
                          maxLength: 128
                          description: The user name used to log into the SQL Server database
                        NTDOMAIN:
                          type: string
                          maxLength: 256
                          description: NT domain for the client connected to SQL Server.
                        NTUNAME:
                          type: string
                          maxLength: 256
                          description: Windows NT user name for the process connected to SQL Server
                        CPUTIME:
                          type: integer
                          format: int32
                          description: CPU time for a SQL session (ms)
                        MEMUSAGE:
                          type: integer
                          format: int32
                          description: The pages allocated by the SQL process in procedure cache.
                        TTLSCHEDTIME:
                          type: integer
                          format: int32
                          description: SQL Server session scheduled time
                        TTLELAPSEDTIME:
                          type: integer
                          format: int32
                          description: SQL Server session elapsed time
                        SESS_NUMREADS:
                          type: integer
                          format: int64
                          description: number of reads performed in a session
                        SESS_NUMWRITES:
                          type: integer
                          format: int64
                          description: Number of writes performed in a session
                        SESS_NUMLOGICALREADS:
                          type: integer
                          format: int64
                          description: number of reads performed by a session
                        TRXISOLEVEL:
                          type: string
                          maxLength: 12
                          description: MSS Transaction Isolation level
                        CONNECTIONID:
                          type: string
                          maxLength: 36
                          description: SQL Server connection id
                        PARENT_CONNID:
                          type: string
                          maxLength: 36
                          description: SQL Server parent connection id
                        CONN_SESSIONID:
                          type: integer
                          format: int32
                          description: Session ID running on connection
                        CONNECT_TIME:
                          type: string
                          maxLength: 24
                          description: Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS
                        NET_TRANSPORT:
                          type: string
                          maxLength: 80
                          description: The network transport type used by the connection
                        PROTOCOL_TYPE:
                          type: string
                          maxLength: 80
                          description: The network transport protocol used by the connection
                        CONN_NUMREADS:
                          type: integer
                          format: int32
                          description: SQL Server connection number of reads over the connection
                        CONN_NUMWRITES:
                          type: integer
                          format: int32
                          description: SQL Server conneciton number of writes over the connection
                        LAST_READ:
                          type: string
                          maxLength: 24
                          description: Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS
                        LAST_WRITE:
                          type: string
                          maxLength: 24
                          description: Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS
                        NET_PACKET_SIZE:
                          type: integer
                          format: int32
                          description: SQL Server packet size
                        CLIENT_NET_ADDR:
                          type: string
                          maxLength: 40
                          description: Connection network address
                        REQ_SESSIONID:
                          type: integer
                          format: int32
                          description: Session ID associated with the request being processed
                        REQUESTID:
                          type: integer
                          format: int32
                          description: SQL Server Request ID
                        START_TIME:
                          type: string
                          maxLength: 24
                          description: Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS
                        STATUS:
                          type: string
                          maxLength: 60
                          description: SQL Server process status; ie sleeping, running etc.
                        COMMAND:
                          type: string
                          maxLength: 32
                          description: Command currently being executed by the given process id
                        SQLHANDLE:
                          type: string
                          maxLength: 128
                          description: handle pointing to sql statment  or procedure
                        STMT_START_OFFSET:
                          type: integer
                          format: int32
                          description: SQL Server int4
                        STMT_END_OFFSET:
                          type: integer
                          format: int32
                          description: SQL Server int4
                        PLAN_HANDLE:
                          type: string
                          maxLength: 128
                          description: handle pointing to plan used in execution of sql stmt/proc
                        DBNAME:
                          type: string
                          maxLength: 128
                          description: Database name
                        USERNAME:
                          type: string
                          maxLength: 128
                          description: The user name used to log into the SQL Server database
                        REQ_CONNECTIONID:
                          type: string
                          maxLength: 36
                          description: SQL Server connection id
                        BLOCKING_SESSION_ID:
                          type: integer
                          format: int32
                          description: Blocking session ID for SQL Server
                        WAIT_TIME:
                          type: integer
                          format: int32
                          description: Current wait time of the process in milliseconds
                        LAST_WAIT_TYPE:
                          type: string
                          maxLength: 64
                          description: The locked resource process is waiting for (object ID).
                        WAIT_RESOURCE:
                          type: string
                          maxLength: 255
                          description: Name of the locked resource the process is waiting for.
                        OPEN_TRAN_CNT:
                          type: integer
                          format: int32
                          description: Number of open transactions for the SQL Server process
                        OPEN_RESULTSET_CNT:
                          type: integer
                          format: int32
                          description: Number of open result sets  for the SQL Server process
                        TRANSACTION_ID:
                          type: integer
                          format: int64
                          description: Transaction identifier request executes under
                        PERCENT_COMPLETE:
                          type: integer
                          format: int64
                          description: Percentage complete
                        EST_COMPLETION_TIME:
                          type: integer
                          format: int64
                          description: Estimated Completion time of SQL Request
                        REQ_CPUTIME:
                          type: integer
                          format: int32
                          description: CPU time for a request
                        REQ_TTLTIME:
                          type: integer
                          format: int32
                          description: Total elapsed time utilized by a request
                        SCHED_ID:
                          type: integer
                          format: int32
                          description: ID of the scheduler used for the request
                        REQ_NUMREADS:
                          type: integer
                          format: int64
                          description: number of reads performed by the request
                        REQ_NUMWRITES:
                          type: integer
                          format: int64
                          description: number of writes performed in a request
                        REQ_NUMLOGICALREADS:
                          type: integer
                          format: int64
                          description: number of reads performed by a request
                        REQ_ROWCOUNT:
                          type: integer
                          format: int64
                          description: SQL Server count of rows returned
                        SQLTEXT:
                          type: string
                          maxLength: 50
                          description: First 50 characters of a SQL Server statement
                        OBJECT_NAME:
                          type: string
                          maxLength: 30
                          description: MS SQL Server object name
                        ABAP_NAME:
                          type: string
                          maxLength: 40
                          description: Name of the ABAP report
                        ABAP_LOC:
                          type: integer
                          format: int32
                          description: Offset of a Processing Control Block
                        SAP_USER:
                          type: string
                          maxLength: 12
                          description: The user name in the SAP system.
                        CPU_TTL:
                          type: integer
                          format: int32
                          description: MS SQL Server cumulative cpu time
                        READS_TTL:
                          type: integer
                          format: int64
                          description: Total number of reads performed by a session and request
                        WRTS_TTL:
                          type: integer
                          format: int64
                          description: Total number of writes performed
                        LOGRDS_TTL:
                          type: integer
                          format: int64
                          description: Total number of reads performed
                        WPNAME:
                          type: string
                          maxLength: 2
                          description: ID of the R3 work process
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
