openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/MSS_SELECT_MSQSNAP:
    post:
      tags:
      - STUS
      summary: MS SQL Server read database table MSQSNAP
      operationId: /rfc/MSS_SELECT_MSQSNAP
      requestBody:
        content:
          application/json:
            schema:
              properties:
                CON_NAME:
                  type: string
                  default: DEFAULT
                  maxLength: 30
                  description: Logical name for a database connection
                SCHEMA:
                  type: string
                  default: ' '
                  maxLength: 128
                  description: Schema name
                MSQSNP:
                  type: array
                  items:
                    type: object
                    properties:
                      RECORDDATE:
                        type: string
                        format: date
                        description: Date
                      RECORDTIME:
                        type: string
                        maxLength: 6
                        description: Time
                      ELAPSEDSEC:
                        type: integer
                        format: int32
                        description: MS SQL Server number of seconds elapsed since DB startup
                      HOSTNAME:
                        type: string
                        maxLength: 30
                        description: Hostname of the application server logged into SQL Server
                      SQLVERSION:
                        type: string
                        maxLength: 50
                        description: Version of the database management system.
                      SQLBUILDNM:
                        type: integer
                        format: int32
                        description: SQL Server build number (corresponding to a Service Pack).
                      PRODLEVEL:
                        type: string
                        maxLength: 12
                        description: Date the executable sqlservr.exe was created.
                      SQLSTARTTM:
                        type: string
                        maxLength: 20
                        description: Date and time of last SQL Server start.
                      SQLEE:
                        type: string
                        maxLength: 1
                        description: 'SQL Server edition: ''X'' = Enterprise Ed., ''C'' Cluster in use'
                      NTVER:
                        type: string
                        maxLength: 1
                        description: 'OS edition: A=Advanced Server, S=Server, D=Datacenter.'
                      PARAMDIFF:
                        type: string
                        maxLength: 1
                        description: Single-Character Flag
                      DISKPERF:
                        type: string
                        maxLength: 1
                        description: Single-Character Flag
                      ISCLUSTER:
                        type: string
                        maxLength: 1
                        description: Is SQL Server clustered 'Y' or 'N'
                      IS3GB:
                        type: string
                        maxLength: 1
                        description: Is SQL Server on machine with /3GB switch on 'Y' or 'N'
                      ISPAE:
                        type: string
                        maxLength: 1
                        description: Is SQL Server on machine with PAE 'Y' or 'N'
                      ISAWE:
                        type: string
                        maxLength: 1
                        description: Is SQL Server  AWE enabled Y' or 'N'
                      CHIP:
                        type: string
                        maxLength: 20
                        description: Processor type being used on the host running SQL Server.
                      WINVER:
                        type: string
                        maxLength: 80
                        description: Operating system version running on SQL Server host.
                      NUMCPUS:
                        type: integer
                        format: int32
                        description: Number of CPUs on the host which runs SQL Server.
                      SQLCPUS:
                        type: integer
                        format: int32
                        description: Maximum number of CPUs SQL Server is configured to use.
                      MASK:
                        type: string
                        maxLength: 8
                        description: Bitmask representing the CPUs available to Windows.
                      PHYMEM:
                        type: integer
                        format: int32
                        description: Amount of RAM on the server running SQL Server
                      TRACEFLAGS:
                        type: string
                        maxLength: 255
                        description: Trace flags which are currently set for SQL Server.
                      MEMSETTING:
                        type: string
                        maxLength: 10
                        description: Specifies how SQL Server memory parameters have been set
                      AGTLOGLOC:
                        type: string
                        maxLength: 255
                        description: UNC path to a file used by SQL Server
                      ERRLOGLOC:
                        type: string
                        maxLength: 255
                        description: UNC path to a file used by SQL Server
                      CONNECTMEM:
                        type: integer
                        format: int64
                        description: Amount of dynamic memory the server is using for connections
                      WRKPROCMEM:
                        type: integer
                        format: int64
                        description: Amount of memory granted to executing processes in KB
                      LOCKMEMORY:
                        type: integer
                        format: int64
                        description: Amount of dynamic memory used for locks in KB
                      MAXWSPMEM:
                        type: integer
                        format: int64
                        description: Maximum amount of memory available for executing SQL process
                      OPTQRYMEM:
                        type: integer
                        format: int64
                        description: Amount of memory SQL Server is using for query optimization
                      SQLCACMEM:
                        type: integer
                        format: int64
                        description: Amount of memory being used for dynamic SQL cache in KB
                      TARSRVMEM:
                        type: integer
                        format: int64
                        description: Amount of memory SQL Server is willing to consume in KB
                      TTLSRVMEM:
                        type: integer
                        format: int64
                        description: Amount of memory SQL Server is currently using in KB.
                      USERCONCTS:
                        type: integer
                        format: int64
                        description: Number of user connections to the SQL Server system
                      CACHEHIT:
                        type: integer
                        format: int64
                        description: Percentage of pages found in the buffer cache
                      DATACACHSZ:
                        type: integer
                        format: int64
                        description: Size in KB of the data cache, including unused space
                      CACHESIZE:
                        type: integer
                        format: int64
                        description: Size in KB of the procedure cache, including unused space.
                      BUFFCOMMIT:
                        type: integer
                        format: int64
                        description: Number of committed pages in cache.
                      FREEBUFFER:
                        type: integer
                        format: int64
                        description: Number of free pages available in cache.
                      STLPAGECNT:
                        type: integer
                        format: int64
                        description: Number of buffer pages taken for other memory requirements
                      FULLSCANS:
                        type: integer
                        format: int64
                        description: Number of unrestricted base table or index scans
                      INDEXSRCH:
                        type: integer
                        format: int64
                        description: Number of index searches
                      EXTALLOCS:
                        type: integer
                        format: int64
                        description: Number of extents allocated to database objects
                      EXTDEALLS:
                        type: integer
                        format: int64
                        description: Number of extents deallocated in a database
                      PAGEALLOCS:
                        type: integer
                        format: int64
                        description: Number of pages allocated to database objects
                      PAGEDEALLS:
                        type: integer
                        format: int64
                        description: Number of pages deallocated in a database
                      PAGESPLITS:
                        type: integer
                        format: int64
                        description: Number of index page splits in a database
                      PROBESCANS:
                        type: integer
                        format: int64
                        description: Number of probe scans in a database
                      RANGESCANS:
                        type: integer
                        format: int64
                        description: Number of range scans through indexes
                      WORKFILES:
                        type: integer
                        format: int64
                        description: Number of work files created
                      WORKTABLES:
                        type: integer
                        format: int64
                        description: Number of work tables created
                      LAZYWRITES:
                        type: integer
                        format: int64
                        description: Number of pages written by the lazy writer to disk.
                      PAGEREADS:
                        type: integer
                        format: int64
                        description: Number of physical page reads
                      PAGEWRITES:
                        type: integer
                        format: int64
                        description: Number of physical page writes
                      REQBUFFPG:
                        type: integer
                        format: int64
                        description: Number of requests to find a page in the buffer pool.
                      READAHEAD:
                        type: integer
                        format: int64
                        description: Number of pages read in anticipation of use.
                      AUTOPARAM:
                        type: integer
                        format: int64
                        description: Number of auto-parameterization attempts
                      SQLBATCHS:
                        type: integer
                        format: int64
                        description: Number of SQL batch requests received by server.
                      SQLCOMPILE:
                        type: integer
                        format: int64
                        description: Number of SQL compilations
                      AVGLTCHWT:
                        type: integer
                        format: int64
                        description: Average wait time in ms for latch requests that waited.
                      LATCHWAITS:
                        type: integer
                        format: int64
                        description: Number of latch requests that had to wait before granted.
                      DB_SIZE:
                        type: integer
                        format: int64
                        description: Database size in MB
                      DB_ALLOC:
                        type: integer
                        format: int64
                        description: Allocated space in database in MB
                      LOG_SIZE:
                        type: integer
                        format: int64
                        description: Log size in MB
                      LOG_ALLOC:
                        type: integer
                        format: int64
                        description: Allocated space in log in MB
                      RESERVED:
                        type: integer
                        format: int64
                        description: Reserved size in KB
                      NUMTABS:
                        type: integer
                        format: int32
                        description: Number of user tables
                      TABDATA:
                        type: integer
                        format: int64
                        description: Data size in KB
                      NUMINDS:
                        type: integer
                        format: int32
                        description: Number of indexes of user tables
                      INDDATA:
                        type: integer
                        format: int64
                        description: Index size in KB
                      UNUSED:
                        type: integer
                        format: int64
                        description: Unused size in KB
                      NUMPROCS:
                        type: integer
                        format: int32
                        description: Number of stored procedures created in DBI
                      SQLUPTIME:
                        type: integer
                        format: int32
                        description: Number of seconds SQL Server has been running.
                      CPUBUSY:
                        type: integer
                        format: int32
                        description: Number of seconds CPUs have been busy (sum for all CPUs) .
                      CPUIDLE:
                        type: integer
                        format: int32
                        description: Number of seconds CPUs have been idle (sum for all CPUs) .
                      IOBUSY:
                        type: integer
                        format: int32
                        description: Number of seconds SQL Server tasks were busy with IO.
                      PCTCPU:
                        type: integer
                        format: int32
                        description: Percent of time the CPUs have been busy.
                      PCTIDLE:
                        type: integer
                        format: int32
                        description: Percent of time CPUs have been idle.
                      PCTIO:
                        type: integer
                        format: int32
                        description: Percent of time SQL Server tasks have beeen busy whit IO.
                      PACKRECD:
                        type: integer
                        format: int32
                        description: Number of network packets received.
                      PACKSENT:
                        type: integer
                        format: int32
                        description: Number of network packets sent out by SQL Server.
                      CONNECTS:
                        type: integer
                        format: int32
                        description: Number of attempted connections to SQL Server.
                      PACKERRORS:
                        type: integer
                        format: int32
                        description: Number of network packets with error since SQL Server start.
                      TOTALREAD:
                        type: integer
                        format: int32
                        description: Number of disk reads done by SQL Server (physical reads).
                      TOTALWRITE:
                        type: integer
                        format: int32
                        description: Number of physical disk writes done by SQL Server.
                      TOTALERROR:
                        type: integer
                        format: int32
                        description: Number of disk read or write errors since SQL Server started
                      CACHETYPE:
                        type: string
                        maxLength: 40
                        description: Type of object in SQL Server procedure cache.
                      HITRATIO:
                        type: integer
                        format: int64
                        description: Procedure cache hit ratio as percentage.
                      OBJECTCNT:
                        type: integer
                        format: int64
                        description: Number of objects stored in the procedure cache.
                      OBJPAGES:
                        type: integer
                        format: int64
                        description: Number of pages used by this object type in the cache.
                      USECOUNTS:
                        type: integer
                        format: int64
                        description: Number of times an object of this type has been used.
                      R3USERS:
                        type: integer
                        format: int32
                        description: Number of connections to SAP database from SAP application.
                      OTHERUSER:
                        type: integer
                        format: int32
                        description: Number of non-SAP processes connected to SAP database.
                      UNIUSER:
                        type: integer
                        format: int32
                        description: Number of different users connected to SAP database
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  MSQSNP:
                    type: array
                    items:
                      type: object
                      properties:
                        RECORDDATE:
                          type: string
                          format: date
                          description: Date
                        RECORDTIME:
                          type: string
                          maxLength: 6
                          description: Time
                        ELAPSEDSEC:
                          type: integer
                          format: int32
                          description: MS SQL Server number of seconds elapsed since DB startup
                        HOSTNAME:
                          type: string
                          maxLength: 30
                          description: Hostname of the application server logged into SQL Server
                        SQLVERSION:
                          type: string
                          maxLength: 50
                          description: Version of the database management system.
                        SQLBUILDNM:
                          type: integer
                          format: int32
                          description: SQL Server build number (corresponding to a Service Pack).
                        PRODLEVEL:
                          type: string
                          maxLength: 12
                          description: Date the executable sqlservr.exe was created.
                        SQLSTARTTM:
                          type: string
                          maxLength: 20
                          description: Date and time of last SQL Server start.
                        SQLEE:
                          type: string
                          maxLength: 1
                          description: 'SQL Server edition: ''X'' = Enterprise Ed., ''C'' Cluster in use'
                        NTVER:
                          type: string
                          maxLength: 1
                          description: 'OS edition: A=Advanced Server, S=Server, D=Datacenter.'
                        PARAMDIFF:
                          type: string
                          maxLength: 1
                          description: Single-Character Flag
                        DISKPERF:
                          type: string
                          maxLength: 1
                          description: Single-Character Flag
                        ISCLUSTER:
                          type: string
                          maxLength: 1
                          description: Is SQL Server clustered 'Y' or 'N'
                        IS3GB:
                          type: string
                          maxLength: 1
                          description: Is SQL Server on machine with /3GB switch on 'Y' or 'N'
                        ISPAE:
                          type: string
                          maxLength: 1
                          description: Is SQL Server on machine with PAE 'Y' or 'N'
                        ISAWE:
                          type: string
                          maxLength: 1
                          description: Is SQL Server  AWE enabled Y' or 'N'
                        CHIP:
                          type: string
                          maxLength: 20
                          description: Processor type being used on the host running SQL Server.
                        WINVER:
                          type: string
                          maxLength: 80
                          description: Operating system version running on SQL Server host.
                        NUMCPUS:
                          type: integer
                          format: int32
                          description: Number of CPUs on the host which runs SQL Server.
                        SQLCPUS:
                          type: integer
                          format: int32
                          description: Maximum number of CPUs SQL Server is configured to use.
                        MASK:
                          type: string
                          maxLength: 8
                          description: Bitmask representing the CPUs available to Windows.
                        PHYMEM:
                          type: integer
                          format: int32
                          description: Amount of RAM on the server running SQL Server
                        TRACEFLAGS:
                          type: string
                          maxLength: 255
                          description: Trace flags which are currently set for SQL Server.
                        MEMSETTING:
                          type: string
                          maxLength: 10
                          description: Specifies how SQL Server memory parameters have been set
                        AGTLOGLOC:
                          type: string
                          maxLength: 255
                          description: UNC path to a file used by SQL Server
                        ERRLOGLOC:
                          type: string
                          maxLength: 255
                          description: UNC path to a file used by SQL Server
                        CONNECTMEM:
                          type: integer
                          format: int64
                          description: Amount of dynamic memory the server is using for connections
                        WRKPROCMEM:
                          type: integer
                          format: int64
                          description: Amount of memory granted to executing processes in KB
                        LOCKMEMORY:
                          type: integer
                          format: int64
                          description: Amount of dynamic memory used for locks in KB
                        MAXWSPMEM:
                          type: integer
                          format: int64
                          description: Maximum amount of memory available for executing SQL process
                        OPTQRYMEM:
                          type: integer
                          format: int64
                          description: Amount of memory SQL Server is using for query optimization
                        SQLCACMEM:
                          type: integer
                          format: int64
                          description: Amount of memory being used for dynamic SQL cache in KB
                        TARSRVMEM:
                          type: integer
                          format: int64
                          description: Amount of memory SQL Server is willing to consume in KB
                        TTLSRVMEM:
                          type: integer
                          format: int64
                          description: Amount of memory SQL Server is currently using in KB.
                        USERCONCTS:
                          type: integer
                          format: int64
                          description: Number of user connections to the SQL Server system
                        CACHEHIT:
                          type: integer
                          format: int64
                          description: Percentage of pages found in the buffer cache
                        DATACACHSZ:
                          type: integer
                          format: int64
                          description: Size in KB of the data cache, including unused space
                        CACHESIZE:
                          type: integer
                          format: int64
                          description: Size in KB of the procedure cache, including unused space.
                        BUFFCOMMIT:
                          type: integer
                          format: int64
                          description: Number of committed pages in cache.
                        FREEBUFFER:
                          type: integer
                          format: int64
                          description: Number of free pages available in cache.
                        STLPAGECNT:
                          type: integer
                          format: int64
                          description: Number of buffer pages taken for other memory requirements
                        FULLSCANS:
                          type: integer
                          format: int64
                          description: Number of unrestricted base table or index scans
                        INDEXSRCH:
                          type: integer
                          format: int64
                          description: Number of index searches
                        EXTALLOCS:
                          type: integer
                          format: int64
                          description: Number of extents allocated to database objects
                        EXTDEALLS:
                          type: integer
                          format: int64
                          description: Number of extents deallocated in a database
                        PAGEALLOCS:
                          type: integer
                          format: int64
                          description: Number of pages allocated to database objects
                        PAGEDEALLS:
                          type: integer
                          format: int64
                          description: Number of pages deallocated in a database
                        PAGESPLITS:
                          type: integer
                          format: int64
                          description: Number of index page splits in a database
                        PROBESCANS:
                          type: integer
                          format: int64
                          description: Number of probe scans in a database
                        RANGESCANS:
                          type: integer
                          format: int64
                          description: Number of range scans through indexes
                        WORKFILES:
                          type: integer
                          format: int64
                          description: Number of work files created
                        WORKTABLES:
                          type: integer
                          format: int64
                          description: Number of work tables created
                        LAZYWRITES:
                          type: integer
                          format: int64
                          description: Number of pages written by the lazy writer to disk.
                        PAGEREADS:
                          type: integer
                          format: int64
                          description: Number of physical page reads
                        PAGEWRITES:
                          type: integer
                          format: int64
                          description: Number of physical page writes
                        REQBUFFPG:
                          type: integer
                          format: int64
                          description: Number of requests to find a page in the buffer pool.
                        READAHEAD:
                          type: integer
                          format: int64
                          description: Number of pages read in anticipation of use.
                        AUTOPARAM:
                          type: integer
                          format: int64
                          description: Number of auto-parameterization attempts
                        SQLBATCHS:
                          type: integer
                          format: int64
                          description: Number of SQL batch requests received by server.
                        SQLCOMPILE:
                          type: integer
                          format: int64
                          description: Number of SQL compilations
                        AVGLTCHWT:
                          type: integer
                          format: int64
                          description: Average wait time in ms for latch requests that waited.
                        LATCHWAITS:
                          type: integer
                          format: int64
                          description: Number of latch requests that had to wait before granted.
                        DB_SIZE:
                          type: integer
                          format: int64
                          description: Database size in MB
                        DB_ALLOC:
                          type: integer
                          format: int64
                          description: Allocated space in database in MB
                        LOG_SIZE:
                          type: integer
                          format: int64
                          description: Log size in MB
                        LOG_ALLOC:
                          type: integer
                          format: int64
                          description: Allocated space in log in MB
                        RESERVED:
                          type: integer
                          format: int64
                          description: Reserved size in KB
                        NUMTABS:
                          type: integer
                          format: int32
                          description: Number of user tables
                        TABDATA:
                          type: integer
                          format: int64
                          description: Data size in KB
                        NUMINDS:
                          type: integer
                          format: int32
                          description: Number of indexes of user tables
                        INDDATA:
                          type: integer
                          format: int64
                          description: Index size in KB
                        UNUSED:
                          type: integer
                          format: int64
                          description: Unused size in KB
                        NUMPROCS:
                          type: integer
                          format: int32
                          description: Number of stored procedures created in DBI
                        SQLUPTIME:
                          type: integer
                          format: int32
                          description: Number of seconds SQL Server has been running.
                        CPUBUSY:
                          type: integer
                          format: int32
                          description: Number of seconds CPUs have been busy (sum for all CPUs) .
                        CPUIDLE:
                          type: integer
                          format: int32
                          description: Number of seconds CPUs have been idle (sum for all CPUs) .
                        IOBUSY:
                          type: integer
                          format: int32
                          description: Number of seconds SQL Server tasks were busy with IO.
                        PCTCPU:
                          type: integer
                          format: int32
                          description: Percent of time the CPUs have been busy.
                        PCTIDLE:
                          type: integer
                          format: int32
                          description: Percent of time CPUs have been idle.
                        PCTIO:
                          type: integer
                          format: int32
                          description: Percent of time SQL Server tasks have beeen busy whit IO.
                        PACKRECD:
                          type: integer
                          format: int32
                          description: Number of network packets received.
                        PACKSENT:
                          type: integer
                          format: int32
                          description: Number of network packets sent out by SQL Server.
                        CONNECTS:
                          type: integer
                          format: int32
                          description: Number of attempted connections to SQL Server.
                        PACKERRORS:
                          type: integer
                          format: int32
                          description: Number of network packets with error since SQL Server start.
                        TOTALREAD:
                          type: integer
                          format: int32
                          description: Number of disk reads done by SQL Server (physical reads).
                        TOTALWRITE:
                          type: integer
                          format: int32
                          description: Number of physical disk writes done by SQL Server.
                        TOTALERROR:
                          type: integer
                          format: int32
                          description: Number of disk read or write errors since SQL Server started
                        CACHETYPE:
                          type: string
                          maxLength: 40
                          description: Type of object in SQL Server procedure cache.
                        HITRATIO:
                          type: integer
                          format: int64
                          description: Procedure cache hit ratio as percentage.
                        OBJECTCNT:
                          type: integer
                          format: int64
                          description: Number of objects stored in the procedure cache.
                        OBJPAGES:
                          type: integer
                          format: int64
                          description: Number of pages used by this object type in the cache.
                        USECOUNTS:
                          type: integer
                          format: int64
                          description: Number of times an object of this type has been used.
                        R3USERS:
                          type: integer
                          format: int32
                          description: Number of connections to SAP database from SAP application.
                        OTHERUSER:
                          type: integer
                          format: int32
                          description: Number of non-SAP processes connected to SAP database.
                        UNIUSER:
                          type: integer
                          format: int32
                          description: Number of different users connected to SAP database
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
