Get SQL Server Connections (Data On Demand)

Community.DataOnDemand.SQL.Legacy.AgentTask.GetSqlServerConnections (Task)

Lists all open connections to the SQL instance, and the databases that are in use by those connections.

Element properties:

Member Modules:

Source Code:

<Task ID="Community.DataOnDemand.SQL.Legacy.AgentTask.GetSqlServerConnections" Accessibility="Public" Timeout="240" Enabled="true" Remotable="true" Target="MSSQL!Microsoft.SQLServer.DBEngine">

  <Category>Operations</Category>

  <ProbeAction ID="Probe" TypeID="Community.DataOnDemand.SQL.Legacy.Probe.SQLServerConnections">

    <DatabaseServer>$Target/Property[Type='MSSQL!Microsoft.SQLServer.DBEngine']/ConnectionString$</DatabaseServer>

  </ProbeAction>

</Task>