openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/MSQ_PERFHIST_DOWNLOAD:
    post:
      tags:
      - STUL
      summary: SQL Server Performance History
      operationId: /rfc/MSQ_PERFHIST_DOWNLOAD
      requestBody:
        content:
          application/json:
            schema:
              properties:
                AREA:
                  type: string
                  default: MACY
                  maxLength: 16
                  description: Specifies data to collect
                DAYS:
                  type: integer
                  format: int32
                  default: 7
                  description: Number of days to collect
                ACCESSMTHS:
                  type: array
                  items:
                    type: object
                    properties:
                      FULLSCANS:
                        type: integer
                        format: int32
                        description: Number of unrestricted base table or index scans
                      INDEXSRCH:
                        type: integer
                        format: int32
                        description: Number of index searches.
                      EXTALLOCS:
                        type: integer
                        format: int32
                        description: Number of extents allocated to database objects
                      EXTDEALLS:
                        type: integer
                        format: int32
                        description: Number of extents deallocated in a database
                      PAGEALLOCS:
                        type: integer
                        format: int32
                        description: Number of pages allocated to database objects
                      PAGEDEALLS:
                        type: integer
                        format: int32
                        description: Number of pages deallocated in a database
                      PAGESPLITS:
                        type: integer
                        format: int32
                        description: Number of index page splits in a database
                      PROBESCANS:
                        type: integer
                        format: int32
                        description: Number of probe scans in a database
                      RANGESCANS:
                        type: integer
                        format: int32
                        description: Number of range scans through indexes
                      WORKFILES:
                        type: integer
                        format: int32
                        description: Number of work files created
                      WORKTABLES:
                        type: integer
                        format: int32
                        description: Number of work tables created
                      LAZYWRITES:
                        type: integer
                        format: int32
                        description: Number of buffers written by the lazy writer
                      PAGEREADS:
                        type: integer
                        format: int32
                        description: Number of physical page reads
                      PAGEWRITES:
                        type: integer
                        format: int32
                        description: Number of physical page writes
                      REQBUFFPG:
                        type: integer
                        format: int32
                        description: Number of requests for buffer pages.
                      READAHEAD:
                        type: integer
                        format: int32
                        description: Number of requests to prefetch pages.
                      AUTOPARAM:
                        type: integer
                        format: int32
                        description: Number of auto-parameterization attempts
                      SQLBATCHS:
                        type: integer
                        format: int32
                        description: Number of Transact-SQL batches received.
                      SQLCOMPILE:
                        type: integer
                        format: int32
                        description: Number of SQL compilations.
                      AVGLTCHWT:
                        type: integer
                        format: int32
                        description: Average latch wait time in ms for latch requests that wait
                      LATCHWAITS:
                        type: integer
                        format: int32
                        description: Number of latch requests per second that weren't satified
                CACHEINFO:
                  type: array
                  items:
                    type: object
                    properties:
                      CACHETYPE:
                        type: string
                        maxLength: 30
                        description: Type of cache object analyzed
                      HITRATIO:
                        type: integer
                        format: int32
                        description: Percentage of pages found in cache
                      OBJECTCNT:
                        type: integer
                        format: int32
                        description: Number of objects found in the cache.
                      OBJPAGES:
                        type: integer
                        format: int32
                        description: Number of pages used by this object type found in the cache.
                      USECOUNTS:
                        type: integer
                        format: int32
                        description: Number of times an object of this type has been used.
                DBDATAGENERAL:
                  type: array
                  items:
                    type: object
                    properties:
                      DBNAME:
                        type: string
                        maxLength: 255
                        description: MS SQL server Database name
                      CRDATE:
                        type: string
                        maxLength: 12
                        description: Date the SQLSever database was created
                      CMPTLEVEL:
                        type: integer
                        format: int32
                        description: SQLServer release level that the DB is compatible to
                      AUTOSTCRE:
                        type: string
                        maxLength: 1
                        description: Missing statistics auto. built for query during optimization
                      AUTOSTUPD:
                        type: string
                        maxLength: 1
                        description: Out of date Statistics built for query during optimization
                      AUTOCLOSE:
                        type: string
                        maxLength: 1
                        description: The database will close down when the last user logs out
                      BULKCOPY:
                        type: string
                        maxLength: 1
                        description: SELECT INTO and fast bulk copies are allowed
                      TRUCLOG:
                        type: string
                        maxLength: 1
                        description: The db is checkpointed when log is 70% full
                      TORNPGDET:
                        type: string
                        maxLength: 1
                        description: Incomplete pages can be detected
                      LOADING:
                        type: string
                        maxLength: 1
                        description: The database is in a loading state
                      PRERECVY:
                        type: string
                        maxLength: 1
                        description: The database is in a prerecovering state
                      RECOVERY:
                        type: string
                        maxLength: 1
                        description: The database is in a recovering state
                      NOTRECVR:
                        type: string
                        maxLength: 1
                        description: The database is not recovering
                      DBOFFLINE:
                        type: string
                        maxLength: 1
                        description: The database is offline
                      READONLY:
                        type: string
                        maxLength: 1
                        description: The database is read only
                      DBOONLY:
                        type: string
                        maxLength: 1
                        description: Only the database owner can access the database
                      SINGLEUSER:
                        type: string
                        maxLength: 1
                        description: The database is in single user mode
                      EMERGYMD:
                        type: string
                        maxLength: 1
                        description: Database is in emergency mode
                      AUTOSHRINK:
                        type: string
                        maxLength: 1
                        description: When 25% or more of the file is unused, file is auto. shrunk
                      CLNSHTDWN:
                        type: string
                        maxLength: 1
                        description: Database was cleanly shutdown
                      ANSINULDEF:
                        type: string
                        maxLength: 1
                        description: Allows the user to control the database default nullability
                      CCNULL:
                        type: string
                        maxLength: 1
                        description: Null operands result in a Null if concatenated
                      RECTRIGGER:
                        type: string
                        maxLength: 1
                        description: Enables recursive firing of triggers
                      DEFLOCCUR:
                        type: string
                        maxLength: 1
                        description: Cursor declarations default to LOCAL
                      QUOTEDID:
                        type: string
                        maxLength: 1
                        description: '" can be used to surround delimited identifiers'
                      CCONCOMMIT:
                        type: string
                        maxLength: 1
                        description: Any cursors open are closed on commit or roll back
                      ANSINULLS:
                        type: string
                        maxLength: 1
                        description: Any comparisons to a null value evaluate to NULL
                      ANSIWARN:
                        type: string
                        maxLength: 1
                        description: Null values in aggregate fcns, or divide by 0, cause warning
                      FULLTXTEN:
                        type: string
                        maxLength: 1
                        description: Initailizes fulltext indexing or removes all full-text catlg
                      DBSUSPECT:
                        type: string
                        maxLength: 1
                        description: Database is marked as suspect
                      DBSHUTDOWN:
                        type: string
                        maxLength: 1
                        description: Database encountered a problem during startup
                      DBSTANDBY:
                        type: string
                        maxLength: 1
                        description: Database is functioning as a standby server
                      DBSIZE:
                        type: integer
                        format: int32
                        description: MS SQL server database size
                      DBFREE:
                        type: integer
                        format: int32
                        description: MSQ server database free size
                      DBUSED:
                        type: integer
                        format: int32
                        description: MSQ server database used size
                      LOGSIZE:
                        type: integer
                        format: int32
                        description: MS SQL server - size of the log file
                      LOGFREE:
                        type: integer
                        format: int32
                        description: MS SQL server -  free log size
                      LOGUSED:
                        type: integer
                        format: int32
                        description: MS SQL server -  used log size
                      DBNUMSAP:
                        type: integer
                        format: int32
                        description: Number of SAP processes connected to the database
                      DBNUMOTHER:
                        type: integer
                        format: int32
                        description: Number of non-SAP processes connected to the database
                      DBNDIFFUSE:
                        type: integer
                        format: int32
                        description: Number of different users connected to the database
                DYNAMICSERVER:
                  type: array
                  items:
                    type: object
                    properties:
                      SQLUPTIME:
                        type: integer
                        format: int32
                        description: Number of seconds sqlserver has been running
                      CPUBUSY:
                        type: integer
                        format: int32
                        description: Number of seconds the cpus have been busy.
                      CPUIDLE:
                        type: integer
                        format: int32
                        description: Number of seconds sqlservr has been idle
                      IOBUSY:
                        type: integer
                        format: int32
                        description: Number of seconds io busy on sqlserver tasks
                      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 io busy on sqlserver tasks
                      PACKRECD:
                        type: integer
                        format: int32
                        description: Number of input packets received
                      PACKSENT:
                        type: integer
                        format: int32
                        description: Number of packets sent on the network by SQL Server
                      CONNECTS:
                        type: integer
                        format: int32
                        description: Number of attempted connections
                      PACKERRORS:
                        type: integer
                        format: int32
                        description: Number of packets in error since sqlserver started
                      TOTALREAD:
                        type: integer
                        format: int32
                        description: Number of disk reads done by SQL Server
                      TOTALWRITE:
                        type: integer
                        format: int32
                        description: Number of disk writes sqlserver has performed
                      TOTALERROR:
                        type: integer
                        format: int32
                        description: Number of disk read/write errors since sqlserver was started
                MEMUSAGE:
                  type: array
                  items:
                    type: object
                    properties:
                      CONNECTMEM:
                        type: integer
                        format: int32
                        description: Amount of dynamic memory the server is using for connections
                      WRKPROCMEM:
                        type: integer
                        format: int32
                        description: Amount of memory granted to executing processes in KB
                      LOCKMEMORY:
                        type: integer
                        format: int32
                        description: Amount of dynamic memory used for locks in KB
                      MAXWSPMEM:
                        type: integer
                        format: int32
                        description: Maximum amount of memory available for executing SQL process
                      OPTQRYMEM:
                        type: integer
                        format: int32
                        description: Amount of memory SQL Server is using for query optimization
                      SQLCACMEM:
                        type: integer
                        format: int32
                        description: Amount of memory being used for dynamic SQL cache in KB
                      TARSRVMEM:
                        type: integer
                        format: int32
                        description: Amount of memory SQL Server is willing to consume in KB
                      TTLSRVMEM:
                        type: integer
                        format: int32
                        description: Amount of memory SQL Server is currently using in KB
                      USERCONCTS:
                        type: integer
                        format: int32
                        description: Number of user connections to the SQL Server system
                      CACHEHIT:
                        type: integer
                        format: int32
                        description: Percentage of pages found in the buffer cache
                      DATACACHSZ:
                        type: integer
                        format: int32
                        description: Size in KB of the data cache, including unused space
                      CACHESIZE:
                        type: integer
                        format: int32
                        description: Size in KB of the procedure cache, including unused space.
                      BUFFCOMMIT:
                        type: integer
                        format: int32
                        description: Number of buffer pages committed.
                      FREEBUFFER:
                        type: integer
                        format: int32
                        description: Number of free buffers available.
                      STLPAGECNT:
                        type: integer
                        format: int32
                        description: Number of buffer pages stolen for other memory requirements
                PERFHISTREC:
                  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: ''
                STATICSERVER:
                  type: array
                  items:
                    type: object
                    properties:
                      HOSTNAME:
                        type: string
                        maxLength: 128
                        description: MS SQL server - name of the workstation or server.
                      SQLVERSION:
                        type: string
                        maxLength: 50
                        description: MSQ SQL server - version
                      SQLBUILDNM:
                        type: integer
                        format: int32
                        description: MS SQL server - database version
                      SQLBUILDDT:
                        type: string
                        maxLength: 12
                        description: the date sqlserver.exe was created
                      SQLSTARTTM:
                        type: string
                        maxLength: 20
                        description: MS SQL server - time of last sql server startup
                      SQLEE:
                        type: string
                        maxLength: 1
                        description: X if the enterprise edition of sql server is being used
                      NTEE:
                        type: string
                        maxLength: 1
                        description: X if the enterprise edition of NT is being used
                      DOMAINCTLR:
                        type: string
                        maxLength: 1
                        description: X if the server running SQLServer is a Domain Controller
                      PARAMDIFF:
                        type: string
                        maxLength: 1
                        description: X if a diff. exists between the set and run values of SQL
                      DISKPERF:
                        type: string
                        maxLength: 1
                        description: '''X'' if diskperf -y has been set for db server'
                      CHIP:
                        type: string
                        maxLength: 20
                        description: The processor type being used on the server running SQL
                      WINVER:
                        type: string
                        maxLength: 80
                        description: NT version being run on the host running SQL Server
                      NUMCPUS:
                        type: integer
                        format: int32
                        description: the number of CPUS on the server which runs SQL Server
                      SQLCPUS:
                        type: integer
                        format: int32
                        description: The number of cpus SQL Server is allowed to run on
                      MASK:
                        type: string
                        maxLength: 8
                        description: Bitmask which shows processors usable by NT
                      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 set for the SQLServer executable
                      MEMSETTING:
                        type: string
                        maxLength: 10
                        description: Relates how SQL Server memory parameters have been set
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  ACCESSMTHS:
                    type: array
                    items:
                      type: object
                      properties:
                        FULLSCANS:
                          type: integer
                          format: int32
                          description: Number of unrestricted base table or index scans
                        INDEXSRCH:
                          type: integer
                          format: int32
                          description: Number of index searches.
                        EXTALLOCS:
                          type: integer
                          format: int32
                          description: Number of extents allocated to database objects
                        EXTDEALLS:
                          type: integer
                          format: int32
                          description: Number of extents deallocated in a database
                        PAGEALLOCS:
                          type: integer
                          format: int32
                          description: Number of pages allocated to database objects
                        PAGEDEALLS:
                          type: integer
                          format: int32
                          description: Number of pages deallocated in a database
                        PAGESPLITS:
                          type: integer
                          format: int32
                          description: Number of index page splits in a database
                        PROBESCANS:
                          type: integer
                          format: int32
                          description: Number of probe scans in a database
                        RANGESCANS:
                          type: integer
                          format: int32
                          description: Number of range scans through indexes
                        WORKFILES:
                          type: integer
                          format: int32
                          description: Number of work files created
                        WORKTABLES:
                          type: integer
                          format: int32
                          description: Number of work tables created
                        LAZYWRITES:
                          type: integer
                          format: int32
                          description: Number of buffers written by the lazy writer
                        PAGEREADS:
                          type: integer
                          format: int32
                          description: Number of physical page reads
                        PAGEWRITES:
                          type: integer
                          format: int32
                          description: Number of physical page writes
                        REQBUFFPG:
                          type: integer
                          format: int32
                          description: Number of requests for buffer pages.
                        READAHEAD:
                          type: integer
                          format: int32
                          description: Number of requests to prefetch pages.
                        AUTOPARAM:
                          type: integer
                          format: int32
                          description: Number of auto-parameterization attempts
                        SQLBATCHS:
                          type: integer
                          format: int32
                          description: Number of Transact-SQL batches received.
                        SQLCOMPILE:
                          type: integer
                          format: int32
                          description: Number of SQL compilations.
                        AVGLTCHWT:
                          type: integer
                          format: int32
                          description: Average latch wait time in ms for latch requests that wait
                        LATCHWAITS:
                          type: integer
                          format: int32
                          description: Number of latch requests per second that weren't satified
                  CACHEINFO:
                    type: array
                    items:
                      type: object
                      properties:
                        CACHETYPE:
                          type: string
                          maxLength: 30
                          description: Type of cache object analyzed
                        HITRATIO:
                          type: integer
                          format: int32
                          description: Percentage of pages found in cache
                        OBJECTCNT:
                          type: integer
                          format: int32
                          description: Number of objects found in the cache.
                        OBJPAGES:
                          type: integer
                          format: int32
                          description: Number of pages used by this object type found in the cache.
                        USECOUNTS:
                          type: integer
                          format: int32
                          description: Number of times an object of this type has been used.
                  DBDATAGENERAL:
                    type: array
                    items:
                      type: object
                      properties:
                        DBNAME:
                          type: string
                          maxLength: 255
                          description: MS SQL server Database name
                        CRDATE:
                          type: string
                          maxLength: 12
                          description: Date the SQLSever database was created
                        CMPTLEVEL:
                          type: integer
                          format: int32
                          description: SQLServer release level that the DB is compatible to
                        AUTOSTCRE:
                          type: string
                          maxLength: 1
                          description: Missing statistics auto. built for query during optimization
                        AUTOSTUPD:
                          type: string
                          maxLength: 1
                          description: Out of date Statistics built for query during optimization
                        AUTOCLOSE:
                          type: string
                          maxLength: 1
                          description: The database will close down when the last user logs out
                        BULKCOPY:
                          type: string
                          maxLength: 1
                          description: SELECT INTO and fast bulk copies are allowed
                        TRUCLOG:
                          type: string
                          maxLength: 1
                          description: The db is checkpointed when log is 70% full
                        TORNPGDET:
                          type: string
                          maxLength: 1
                          description: Incomplete pages can be detected
                        LOADING:
                          type: string
                          maxLength: 1
                          description: The database is in a loading state
                        PRERECVY:
                          type: string
                          maxLength: 1
                          description: The database is in a prerecovering state
                        RECOVERY:
                          type: string
                          maxLength: 1
                          description: The database is in a recovering state
                        NOTRECVR:
                          type: string
                          maxLength: 1
                          description: The database is not recovering
                        DBOFFLINE:
                          type: string
                          maxLength: 1
                          description: The database is offline
                        READONLY:
                          type: string
                          maxLength: 1
                          description: The database is read only
                        DBOONLY:
                          type: string
                          maxLength: 1
                          description: Only the database owner can access the database
                        SINGLEUSER:
                          type: string
                          maxLength: 1
                          description: The database is in single user mode
                        EMERGYMD:
                          type: string
                          maxLength: 1
                          description: Database is in emergency mode
                        AUTOSHRINK:
                          type: string
                          maxLength: 1
                          description: When 25% or more of the file is unused, file is auto. shrunk
                        CLNSHTDWN:
                          type: string
                          maxLength: 1
                          description: Database was cleanly shutdown
                        ANSINULDEF:
                          type: string
                          maxLength: 1
                          description: Allows the user to control the database default nullability
                        CCNULL:
                          type: string
                          maxLength: 1
                          description: Null operands result in a Null if concatenated
                        RECTRIGGER:
                          type: string
                          maxLength: 1
                          description: Enables recursive firing of triggers
                        DEFLOCCUR:
                          type: string
                          maxLength: 1
                          description: Cursor declarations default to LOCAL
                        QUOTEDID:
                          type: string
                          maxLength: 1
                          description: '" can be used to surround delimited identifiers'
                        CCONCOMMIT:
                          type: string
                          maxLength: 1
                          description: Any cursors open are closed on commit or roll back
                        ANSINULLS:
                          type: string
                          maxLength: 1
                          description: Any comparisons to a null value evaluate to NULL
                        ANSIWARN:
                          type: string
                          maxLength: 1
                          description: Null values in aggregate fcns, or divide by 0, cause warning
                        FULLTXTEN:
                          type: string
                          maxLength: 1
                          description: Initailizes fulltext indexing or removes all full-text catlg
                        DBSUSPECT:
                          type: string
                          maxLength: 1
                          description: Database is marked as suspect
                        DBSHUTDOWN:
                          type: string
                          maxLength: 1
                          description: Database encountered a problem during startup
                        DBSTANDBY:
                          type: string
                          maxLength: 1
                          description: Database is functioning as a standby server
                        DBSIZE:
                          type: integer
                          format: int32
                          description: MS SQL server database size
                        DBFREE:
                          type: integer
                          format: int32
                          description: MSQ server database free size
                        DBUSED:
                          type: integer
                          format: int32
                          description: MSQ server database used size
                        LOGSIZE:
                          type: integer
                          format: int32
                          description: MS SQL server - size of the log file
                        LOGFREE:
                          type: integer
                          format: int32
                          description: MS SQL server -  free log size
                        LOGUSED:
                          type: integer
                          format: int32
                          description: MS SQL server -  used log size
                        DBNUMSAP:
                          type: integer
                          format: int32
                          description: Number of SAP processes connected to the database
                        DBNUMOTHER:
                          type: integer
                          format: int32
                          description: Number of non-SAP processes connected to the database
                        DBNDIFFUSE:
                          type: integer
                          format: int32
                          description: Number of different users connected to the database
                  DYNAMICSERVER:
                    type: array
                    items:
                      type: object
                      properties:
                        SQLUPTIME:
                          type: integer
                          format: int32
                          description: Number of seconds sqlserver has been running
                        CPUBUSY:
                          type: integer
                          format: int32
                          description: Number of seconds the cpus have been busy.
                        CPUIDLE:
                          type: integer
                          format: int32
                          description: Number of seconds sqlservr has been idle
                        IOBUSY:
                          type: integer
                          format: int32
                          description: Number of seconds io busy on sqlserver tasks
                        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 io busy on sqlserver tasks
                        PACKRECD:
                          type: integer
                          format: int32
                          description: Number of input packets received
                        PACKSENT:
                          type: integer
                          format: int32
                          description: Number of packets sent on the network by SQL Server
                        CONNECTS:
                          type: integer
                          format: int32
                          description: Number of attempted connections
                        PACKERRORS:
                          type: integer
                          format: int32
                          description: Number of packets in error since sqlserver started
                        TOTALREAD:
                          type: integer
                          format: int32
                          description: Number of disk reads done by SQL Server
                        TOTALWRITE:
                          type: integer
                          format: int32
                          description: Number of disk writes sqlserver has performed
                        TOTALERROR:
                          type: integer
                          format: int32
                          description: Number of disk read/write errors since sqlserver was started
                  MEMUSAGE:
                    type: array
                    items:
                      type: object
                      properties:
                        CONNECTMEM:
                          type: integer
                          format: int32
                          description: Amount of dynamic memory the server is using for connections
                        WRKPROCMEM:
                          type: integer
                          format: int32
                          description: Amount of memory granted to executing processes in KB
                        LOCKMEMORY:
                          type: integer
                          format: int32
                          description: Amount of dynamic memory used for locks in KB
                        MAXWSPMEM:
                          type: integer
                          format: int32
                          description: Maximum amount of memory available for executing SQL process
                        OPTQRYMEM:
                          type: integer
                          format: int32
                          description: Amount of memory SQL Server is using for query optimization
                        SQLCACMEM:
                          type: integer
                          format: int32
                          description: Amount of memory being used for dynamic SQL cache in KB
                        TARSRVMEM:
                          type: integer
                          format: int32
                          description: Amount of memory SQL Server is willing to consume in KB
                        TTLSRVMEM:
                          type: integer
                          format: int32
                          description: Amount of memory SQL Server is currently using in KB
                        USERCONCTS:
                          type: integer
                          format: int32
                          description: Number of user connections to the SQL Server system
                        CACHEHIT:
                          type: integer
                          format: int32
                          description: Percentage of pages found in the buffer cache
                        DATACACHSZ:
                          type: integer
                          format: int32
                          description: Size in KB of the data cache, including unused space
                        CACHESIZE:
                          type: integer
                          format: int32
                          description: Size in KB of the procedure cache, including unused space.
                        BUFFCOMMIT:
                          type: integer
                          format: int32
                          description: Number of buffer pages committed.
                        FREEBUFFER:
                          type: integer
                          format: int32
                          description: Number of free buffers available.
                        STLPAGECNT:
                          type: integer
                          format: int32
                          description: Number of buffer pages stolen for other memory requirements
                  PERFHISTREC:
                    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: ''
                  STATICSERVER:
                    type: array
                    items:
                      type: object
                      properties:
                        HOSTNAME:
                          type: string
                          maxLength: 128
                          description: MS SQL server - name of the workstation or server.
                        SQLVERSION:
                          type: string
                          maxLength: 50
                          description: MSQ SQL server - version
                        SQLBUILDNM:
                          type: integer
                          format: int32
                          description: MS SQL server - database version
                        SQLBUILDDT:
                          type: string
                          maxLength: 12
                          description: the date sqlserver.exe was created
                        SQLSTARTTM:
                          type: string
                          maxLength: 20
                          description: MS SQL server - time of last sql server startup
                        SQLEE:
                          type: string
                          maxLength: 1
                          description: X if the enterprise edition of sql server is being used
                        NTEE:
                          type: string
                          maxLength: 1
                          description: X if the enterprise edition of NT is being used
                        DOMAINCTLR:
                          type: string
                          maxLength: 1
                          description: X if the server running SQLServer is a Domain Controller
                        PARAMDIFF:
                          type: string
                          maxLength: 1
                          description: X if a diff. exists between the set and run values of SQL
                        DISKPERF:
                          type: string
                          maxLength: 1
                          description: '''X'' if diskperf -y has been set for db server'
                        CHIP:
                          type: string
                          maxLength: 20
                          description: The processor type being used on the server running SQL
                        WINVER:
                          type: string
                          maxLength: 80
                          description: NT version being run on the host running SQL Server
                        NUMCPUS:
                          type: integer
                          format: int32
                          description: the number of CPUS on the server which runs SQL Server
                        SQLCPUS:
                          type: integer
                          format: int32
                          description: The number of cpus SQL Server is allowed to run on
                        MASK:
                          type: string
                          maxLength: 8
                          description: Bitmask which shows processors usable by NT
                        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 set for the SQLServer executable
                        MEMSETTING:
                          type: string
                          maxLength: 10
                          description: Relates how SQL Server memory parameters have been set
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
