ApexERPHost

<back to all web services

GetDbServerSessions

Requires Authentication
Required role:SysAdmin
The following routes are available for this service:
GET/dbadmin/servers/databases/sessions
GET/dbadmin/servers/{ServerId}/databases/sessions
GetDbServerSessions Parameters:
NameParameterData TypeRequiredDescription
ServerIdpathstringNo
DbNamequerystringNo
GetDbServerSessionsResponse 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 .json suffix or ?format=json

To embed the response in a jsonp callback, append ?callback=myCallback

HTTP + JSON

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

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

{"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}},"Result":[{"ProcessId":0,"User":"String","Host":"String","Database":"String","Application":"String","ContextInfo":"String","Command":"String","BlockedBy":0,"Blocking":0,"Cpu":0,"IsSystemProcess":0,"LastBatch":"\/Date(-62135596800000-0000)\/","LoginTime":"\/Date(-62135596800000-0000)\/","MemoryUsage":0,"NetAddress":"String","NetLibrary":"String","OpenTransactions":0,"PhysicalIo":0,"Status":"String","WaitResource":"String","WaitTime":0,"WaitType":"String"}]}