_ESP_Subscriptions_Ext
Contains information about all currently active subscriptions.
In some situations, there is a delay in updating this stream as new subscriptions are added or existing streams are dropped.
| Column | Type | Description |
|---|---|---|
| stream_handle | long | The handle of the stream the server subscribes to. |
| conn_handle | long | The handle of the connection the server subscribes to. |
| stream_name | string | The name of the stream. |
| stream_user | string | The user name of the owner of the stream. |
| subscriber_user | string | The login name of the user account that owns the subscription. |
| ip | string | The IP address of the client machine. |
| host | string | The symbolic host name of the client machine, if available. If not available, its value is the IP address of the client machine. |
| port | integer | The TCP port number from which the connection owning this subscription originates. |
| login_time | bigdatetime | The time the server accepts the connection owning the subscription. |