Get SQL Server Connections (Data On Demand)

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

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

Element properties:

Target	Microsoft.SQLServer.2016.DBEngine
Accessibility	Public
Category	Operations
Enabled	True
Remotable	False
Timeout	240

Member Modules:

ID	Module Type	TypeId	RunAs
Probe	ProbeAction	Community.DataOnDemand.SQL.2016.Probe.SQLServerConnections	Default

Source Code:

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

  <Category>Operations</Category>

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

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

  </ProbeAction>

</Task>