| 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 .wire suffix or ?format=wire
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: 10.10.0.107 Accept: application/x-wire
HTTP/1.1 200 OK
Content-Type: application/x-wire
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"}]}