DPA.BlockingChain
SolarWinds Information Service 2019.2.5200 Schema Documentation
The entity represents trees of blocker-blockee relationship as in the "Blockers" tab in the UI
Inheritance
Access control
| Operations | Right |
|---|---|
| read | everyone |
Properties
| Name | Type | Summary | Access Control |
|---|---|---|---|
| DatabaseId | System.Int32 | Reference to Orion.DPA.DatabaseInstance.Id. | everyone |
| GlobalDatabaseId | System.Int32 | Unique ID of database instance in Orion | everyone |
| ChainNumber | System.Int32 | Identifies rows belonging to the same blocker-blockee tree. This value is generated with each request, so it is not guaranteed that the same blocker/blockee tree will have the same ChainNumber in two SWQL results. | everyone |
| SessionId | System.String | Session Id. | everyone |
| BlockedBySession | System.String | SessionId of the session that blocked this session. Is NULL if this session is the root blocker of the blocker-blockee tree identified by RootSessionId. | everyone |
| WaitTimeSecs | System.Double | Number of seconds the session spent waiting in the particular blocking chain because it was (transitively) blocked by the root session. This value is 0 for the root session (it is not blocked by itself). | everyone |
| Time | System.DateTime | Beginning and end of the interval for which we want to know the blockers and blockees (operators <, <=, > and >= can be used in WHERE clauses on this field). End defaults to now. | everyone |