Applications Systems

Run a report about licensed component monitors in SAM

Use an SQL query in SolarWinds Platform Reports, Database Manager, or SQL Management Studio to map licensed component monitors in SAM, if you're using a component-based SAM license.

First published date

11/15/2018 3:32 AM

Last published date

7/1/2025 5:12 PM

Overview

This is a custom SQL query that can be used in SolarWinds Platform Reports, Database Manager, or SQL Management Studio to determine how many component monitors are consuming licenses in SAM.

Note: This article applies to component-based SAM licensing. Node-based licensing is now available. See the SAM license model for details.

When determining how many component monitors are active in your environment, remember that AppInsight applications cannot be partially unlicensed because the way they collect data differs significantly from traditional application monitor templates.

  • AppInsight for Active Directory uses 50 component monitor licenses per monitored domain controller
  • AppInsight for Exchange uses 50 component monitor licenses per monitored Exchange server.
  • AppInsight for IIS uses 30 component licenses per monitored IIS server.
  • AppInsight for SQL uses 50 component licenses per monitored instance.

The Windows Scheduled Task Monitor uses 5 component licenses per node.

Note the following details about freeing up licenses:

  • Unmanaging an application will stop polling, but will not free up licenses.
  • Disabling components monitors will free up licenses

Product section

Server Application Monitor

Resolution

Use this query to determine SAM component-based license usage by node:

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.



SELECT r.NodeID, r.[Node Name], r.[Application Name], r.Template AS [Template Name],
CASE WHEN r.Template = 'Windows Scheduled Tasks' then 5
WHEN r.Template LIKE 'AppInsight for IIS' then 30
WHEN r.Template LIKE 'AppInsight for%' then 50
ELSE count (r.[ComponentID])
END AS [Licenses Used]

FROM
(
SELECT ac.ApplicationID, ac.ID AS [ComponentID], n.Caption AS [Node Name], aa.NodeID, aa.Name AS [Application Name], aat.Name [Template], ac.Name AS [Component Name],
CASE WHEN ac.IsDisabled IS NULL THEN act.IsDisabled
ELSE ac.IsDisabled
END [IsDisabled]
FROM APM_Component AS ac
JOIN APM_Application AS aa ON aa.ID = ac.ApplicationID
JOIN Nodes AS n ON n.NodeID = aa.NodeID
JOIN APM_ComponentTemplate AS act ON ac.TemplateID = act.ID
JOIN APM_ApplicationTemplate AS aat ON aa.TemplateID = aat.ID
) r
WHERE r.IsDisabled = 0
GROUP BY r.Template, r.[Node Name], r.[Application Name], r.NodeID

Sample output:


Here is what you'll see in the SolarWinds Platform Web Console:

"Managed Assigned Application"