ApexERPHost

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:
Name	Parameter	Data Type	Required	Description
ServerId	path	string	No
DbName	query	string	No

**GetDbServerBlockingSessionsResponse** Parameters:
Name	Parameter	Data Type	Required	Description
ResponseStatus	form	ResponseStatus	No
Result	form	List<DbServerSession>	No

**DbServerSession** Parameters:
Name	Parameter	Data Type	Required
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 .jsv suffix or ?format=jsv

HTTP + JSV

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: 10.10.0.107 
Accept: text/jsv

HTTP/1.1 200 OK
Content-Type: text/jsv
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: 0001-01-01,
			LoginTime: 0001-01-01,
			MemoryUsage: 0,
			NetAddress: String,
			NetLibrary: String,
			OpenTransactions: 0,
			PhysicalIo: 0,
			Status: String,
			WaitResource: String,
			WaitTime: 0,
			WaitType: String
		}
	]
}