ApexERPHost

<back to all web services

GetDbServerBlockingSessions

Requires Authentication
Required role:SysAdmin
The following routes are available for this service:
GET/dbadmin/servers/databases/sessions/blocked
GET/dbadmin/servers/{ServerId}/databases/sessions/blocked
GetDbServerBlockingSessions Parameters:
NameParameterData TypeRequiredDescription
ServerIdpathstringNo
DbNamequerystringNo
GetDbServerBlockingSessionsResponse Parameters:
NameParameterData TypeRequiredDescription
ResponseStatusformResponseStatusNo
ResultformList<DbServerSession>No
DbServerSession Parameters:
NameParameterData TypeRequiredDescription
ProcessIdformintNo
UserformstringNo
HostformstringNo
DatabaseformstringNo
ApplicationformstringNo
ContextInfoformstringNo
CommandformstringNo
BlockedByformintNo
BlockingformintNo
CpuformintNo
IsSystemProcessformintNo
LastBatchformDateTimeNo
LoginTimeformDateTimeNo
MemoryUsageformintNo
NetAddressformstringNo
NetLibraryformstringNo
OpenTransactionsformintNo
PhysicalIoformlongNo
StatusformstringNo
WaitResourceformstringNo
WaitTimeformlongNo
WaitTypeformstringNo

To override the Content-type in your clients, use the HTTP Accept Header, append the .xml suffix or ?format=xml

HTTP + XML

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

GET /dbadmin/servers/databases/sessions/blocked HTTP/1.1 
Host: apex.nikoratrade.ge 
Accept: application/xml
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<GetDbServerBlockingSessionsResponse xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Apex.Services.DbAdmin">
  <ResponseStatus xmlns:d2p1="http://schemas.servicestack.net/types">
    <d2p1:ErrorCode>String</d2p1:ErrorCode>
    <d2p1:Message>String</d2p1:Message>
    <d2p1:StackTrace>String</d2p1:StackTrace>
    <d2p1:Errors>
      <d2p1:ResponseError>
        <d2p1:ErrorCode>String</d2p1:ErrorCode>
        <d2p1:FieldName>String</d2p1:FieldName>
        <d2p1:Message>String</d2p1:Message>
        <d2p1:Meta xmlns:d5p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
          <d5p1:KeyValueOfstringstring>
            <d5p1:Key>String</d5p1:Key>
            <d5p1:Value>String</d5p1:Value>
          </d5p1:KeyValueOfstringstring>
        </d2p1:Meta>
      </d2p1:ResponseError>
    </d2p1:Errors>
    <d2p1:Meta xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
      <d3p1:KeyValueOfstringstring>
        <d3p1:Key>String</d3p1:Key>
        <d3p1:Value>String</d3p1:Value>
      </d3p1:KeyValueOfstringstring>
    </d2p1:Meta>
  </ResponseStatus>
  <Result>
    <DbServerSession>
      <ProcessId>0</ProcessId>
      <User>String</User>
      <Host>String</Host>
      <Database>String</Database>
      <Application>String</Application>
      <ContextInfo>String</ContextInfo>
      <Command>String</Command>
      <BlockedBy>0</BlockedBy>
      <Blocking>0</Blocking>
      <Cpu>0</Cpu>
      <IsSystemProcess>0</IsSystemProcess>
      <LastBatch>0001-01-01T00:00:00</LastBatch>
      <LoginTime>0001-01-01T00:00:00</LoginTime>
      <MemoryUsage>0</MemoryUsage>
      <NetAddress>String</NetAddress>
      <NetLibrary>String</NetLibrary>
      <OpenTransactions>0</OpenTransactions>
      <PhysicalIo>0</PhysicalIo>
      <Status>String</Status>
      <WaitResource>String</WaitResource>
      <WaitTime>0</WaitTime>
      <WaitType>String</WaitType>
    </DbServerSession>
  </Result>
</GetDbServerBlockingSessionsResponse>