Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Scripting_function


Panel
titleDescription

Returns a dataset of information about each configured database connection. Each row represents a single connection.

Client permissions restrictions


Panel
titleSyntax

system.db.getConnections()

  • Parameters

Nothing

  • Returns

Dataset - A dataset, where each row represents a database connection. The dataset contains the following:

Column NameDescription
NameReturns the name of this datasource.
DescriptionReturns the description for this datasource.
DBTypeReturns the database connection type. Example types include PostgreSQL, MSSQL, and Oracle.
StatusReturns the status of this datasource based on its last tested condition. Typical values include Valid, Faulted, and Reconnecting.
ProblemReturns a string describing the current problem, if the status is not good.
ExtStatusReturns the "best" status of this datasource or of any failover datasources. 
Throughput

Returns number of queries per second, including Insert and Select queries. Throughput will be -1 if idle.

ActiveConnectionsReturns the current number of connections in use.
MaxConnectionsReturns the maximum number of connections the underlying pool is configured to use.
ValidationQueryReturns a SQL query that will be used to validate the status of this datasource. This query should always return at least 1 row.
  • Scope

Gateway, Vision Client, Perspective Session

Panel
titleCode Examples

There are no code examples for this function.

Panel
titleKeywords

system db getConnections, db.getConnections