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 | timestamp | The time the server accepts the connection owning the subscription. |