current_connections

Describes current connections. For example, RADIUS connections.

Column name Description Data type
session_key Primary key.

A unique string that identifies the connection's session as unique from other sessions.

 text
session_id A numeric identifier for the connection's session. integer
username   text *
subscription The subscription that this connection will be billed to.

Reference to subscription.

 integer *
connect_time   timestamp with time zone
last_update   timestamp with time zone
bytes_in   bigint
bytes_out   bigint
seconds   integer
last_xdr Reference to xdr. bigint *
access_server Reference to access_server. integer *
access_server_session_id The identifier of the session according to the remote access_server. text *
access_server_port   integer *
access_server_port_type If connection is a RADIUS connection this value represents RADIUS NAS-Port-Type value for this connection. See RFC2865 for details. integer *
access_server_service_type If connection is a RADIUS connection this value represents RADIUS Service-Type value for this connection. See RFC2865 for details. integer *
assigned_address The IP Address assigned to this connection. text *
calling_party   text *
called_party   text *
policy_rules   text *
subservice Reference to subservice. integer *
originating_access_server_id The ID of the access server, as provided by the access server. text
originating_subscription The subscription that is part of the connection. integer *
connection_type The type of connection:
  • D—Data
  • V—Voice
  • E—Video
  • N—ISDN

Reference to connection_type.

 text *
service Reference to service. integer *