SolarWinds Information Service v3.0 Schema Documentation

Index

DPA.BlockingChain

Base type: System.ExtensionEntity

Summary: The entity represents trees of blocker-blockee relationship as in the "Blockers" tab in the UI

Properties

Name Type Notes
DatabaseId System.Int32 Reference to Orion.DPA.DatabaseInstance.Id.
GlobalDatabaseId System.Int32 Unique ID of database instance in Orion
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.
SessionId System.String Session Id.
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.
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).
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.
DisplayName System.String
Description System.String
InstanceType System.Type
Uri System.String
InstanceSiteId System.Int32 Default='0'.