Required role: | SysAdmin |
GET | /dbadmin/servers/databases/sessions | ||
---|---|---|---|
GET | /dbadmin/servers/{ServerId}/databases/sessions |
Name | Parameter | Data Type | Required | Description |
---|---|---|---|---|
ServerId | path | string | No | |
DbName | query | string | No |
Name | Parameter | Data Type | Required | Description |
---|---|---|---|---|
ResponseStatus | form | ResponseStatus | No | |
Result | form | List<DbServerSession> | No |
Name | Parameter | Data Type | Required | Description |
---|---|---|---|---|
ProcessId | form | int | No | |
User | form | string | No | |
Host | form | string | No | |
Database | form | string | No | |
Application | form | string | No | |
ContextInfo | form | string | No | |
Command | form | string | No | |
BlockedBy | form | int | No | |
Blocking | form | int | No | |
Cpu | form | int | No | |
IsSystemProcess | form | int | No | |
LastBatch | form | DateTime | No | |
LoginTime | form | DateTime | No | |
MemoryUsage | form | int | No | |
NetAddress | form | string | No | |
NetLibrary | form | string | No | |
OpenTransactions | form | int | No | |
PhysicalIo | form | long | No | |
Status | form | string | No | |
WaitResource | form | string | No | |
WaitTime | form | long | No | |
WaitType | form | string | No |
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
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"}]}