openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/GET_PROCESSINFO_MSS:
    post:
      tags:
      - SFMSS_PERF
      summary: get data from sysprocesses
      operationId: /rfc/GET_PROCESSINFO_MSS
      requestBody:
        content:
          application/json:
            schema:
              properties:
                CON_NAME:
                  type: string
                  default: DEFAULT
                  maxLength: 30
                  description: Logical name for a database connection
                EX_STATUS:
                  type: string
                  maxLength: 60
                  description: SQL Server process status; ie sleeping, running etc.
                IN_STATUS:
                  type: string
                  maxLength: 60
                  description: SQL Server process status; ie sleeping, running etc.
                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: Schema name
                ONE_WP:
                  type: string
                  default: N
                  maxLength: 256
                  description: Name of the application program which owns the connection.
                RES_LOCKS:
                  type: string
                  maxLength: 1
                  description: Single-character flag
                SAP_SPIDS:
                  type: string
                  maxLength: 1
                  description: Database name
                SCHEMA:
                  type: string
                  default: ' '
                  maxLength: 128
                  description: Schema name
                PROCINFO:
                  type: array
                  items:
                    type: object
                    properties:
                      SPID:
                        type: integer
                        format: int32
                        description: SQL Server process ID
                      KPID:
                        type: integer
                        format: int32
                        description: Windows operating system thread ID of SQL process
                      BLOCKED:
                        type: integer
                        format: int32
                        description: The SPID of the process blocking this SQL process.
                      WAITTYPE:
                        type: integer
                        format: int32
                        description: The wait type of the waiting process.
                      WAITTIME:
                        type: integer
                        format: int32
                        description: Current wait time of the process in milliseconds
                      SQLWAITRES:
                        type: string
                        maxLength: 32
                        description: The last wait event the process had to wait for..
                      SAPWAIT:
                        type: string
                        maxLength: 255
                        description: Name of the locked resource the process is waiting for.
                      SQLWAIT:
                        type: string
                        maxLength: 64
                        description: The locked resource process is waiting for (object ID).
                      DBNAME:
                        type: string
                        maxLength: 128
                        description: Database name
                      CPU:
                        type: integer
                        format: int32
                        description: MS SQL Server total cumulative CPU time for a SQL process
                      PHYSIO:
                        type: integer
                        format: int64
                        description: The  total cumulative disk reads and writes for the process.
                      MEMUSAGE:
                        type: integer
                        format: int32
                        description: The pages allocated by the SQL process in procedure cache.
                      LOGINTIME:
                        type: string
                        maxLength: 24
                        description: The time at which client process logged into SQL Server.
                      LSTBATTIME:
                        type: string
                        maxLength: 24
                        description: Last time a stor. proc. or EXEC was executed on SQL process.
                      ECID:
                        type: integer
                        format: int32
                        description: Execution context ID used to uniquely identify subthreads
                      OPENTRAN:
                        type: integer
                        format: int32
                        description: Number of open transactions for the SQL Server process
                      STATUS:
                        type: string
                        maxLength: 60
                        description: SQL Server process status; ie sleeping, running etc.
                      LOGINNAME:
                        type: string
                        maxLength: 128
                        description: The user name used to log into the SQL Server database
                      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.
                      HOSTPROS:
                        type: string
                        maxLength: 16
                        description: The application program's process id on the given host
                      EXECCMD:
                        type: string
                        maxLength: 32
                        description: Command currently being executed by the given process id
                      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
                      NETADD:
                        type: string
                        maxLength: 12
                        description: Unique ID of the network interface of client (MAC address).
                      NETLIB:
                        type: string
                        maxLength: 12
                        description: The network library the client is using.
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  PROCINFO:
                    type: array
                    items:
                      type: object
                      properties:
                        SPID:
                          type: integer
                          format: int32
                          description: SQL Server process ID
                        KPID:
                          type: integer
                          format: int32
                          description: Windows operating system thread ID of SQL process
                        BLOCKED:
                          type: integer
                          format: int32
                          description: The SPID of the process blocking this SQL process.
                        WAITTYPE:
                          type: integer
                          format: int32
                          description: The wait type of the waiting process.
                        WAITTIME:
                          type: integer
                          format: int32
                          description: Current wait time of the process in milliseconds
                        SQLWAITRES:
                          type: string
                          maxLength: 32
                          description: The last wait event the process had to wait for..
                        SAPWAIT:
                          type: string
                          maxLength: 255
                          description: Name of the locked resource the process is waiting for.
                        SQLWAIT:
                          type: string
                          maxLength: 64
                          description: The locked resource process is waiting for (object ID).
                        DBNAME:
                          type: string
                          maxLength: 128
                          description: Database name
                        CPU:
                          type: integer
                          format: int32
                          description: MS SQL Server total cumulative CPU time for a SQL process
                        PHYSIO:
                          type: integer
                          format: int64
                          description: The  total cumulative disk reads and writes for the process.
                        MEMUSAGE:
                          type: integer
                          format: int32
                          description: The pages allocated by the SQL process in procedure cache.
                        LOGINTIME:
                          type: string
                          maxLength: 24
                          description: The time at which client process logged into SQL Server.
                        LSTBATTIME:
                          type: string
                          maxLength: 24
                          description: Last time a stor. proc. or EXEC was executed on SQL process.
                        ECID:
                          type: integer
                          format: int32
                          description: Execution context ID used to uniquely identify subthreads
                        OPENTRAN:
                          type: integer
                          format: int32
                          description: Number of open transactions for the SQL Server process
                        STATUS:
                          type: string
                          maxLength: 60
                          description: SQL Server process status; ie sleeping, running etc.
                        LOGINNAME:
                          type: string
                          maxLength: 128
                          description: The user name used to log into the SQL Server database
                        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.
                        HOSTPROS:
                          type: string
                          maxLength: 16
                          description: The application program's process id on the given host
                        EXECCMD:
                          type: string
                          maxLength: 32
                          description: Command currently being executed by the given process id
                        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
                        NETADD:
                          type: string
                          maxLength: 12
                          description: Unique ID of the network interface of client (MAC address).
                        NETLIB:
                          type: string
                          maxLength: 12
                          description: The network library the client is using.
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
