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 .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 HTTP/1.1 
Host: apex.nikoratrade.ge 
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
		}
	]
}