Submit a ticketCall us

WebinarUpcoming Webinar: Know What’s Changed – with NEW Server Configuration Monitor

Change management in IT is critical. But, even with a good change management process, changes are too often not correctly tracked, if at all. The configuration of your servers and applications is a key factor in their performance, availability, and security. Many incidents can be tracked back to an authorized (and sometimes unauthorized) configuration change, whether to a system file, configuration file, or Windows® Registry entry. Join SolarWinds VP of product management Brandon Shopp to discover how the new SolarWinds® Server Configuration Monitor is designed to help you.

Register now.

Home > Success Center > Server & Application Monitor (SAM) > SAM - Knowledgebase Articles > Report for component licenses by SAM

Report for component licenses by SAM

Table of contents

Updated January 31, 2017

Overview

This is a customer SQL query that can be done thru Web Based Report or thru Orion Report Writer.

Environment

All SAM versions

Steps

 

SAM License Usage by Group

select
case when t.name = 'Windows Scheduled Tasks' then 5
when t.name like 'AppInsight for%' then 50
else count(c.id) end as 'LICENSES USED',
case when a.unmanaged = 1 then 'UnManaged'
else 'Managed' end as 'APPLICATION MANAGED?',
g.name as 'GROUP NAME',
a.name as 'APPLICATION MONITOR',
t.name as 'TEMPLATE'
from apm_component c
join apm_application a on a.id = c.applicationid
join apm_applicationtemplate t on t.id=a.templateid
join nodes n on n.nodeid = a.nodeid
join containermembersnapshots s on s.entityid = n.nodeid
join containers g on g.containerid = s.containerid
where s.entitytype = 'Orion.Nodes'
and (c.isdisabled is null or c.isdisabled = 0)
group by a.unmanaged, g.name, a.name, t.name
order by 'licenses used' desc

 

SAM License Usage by Node:

select
case when t.name = 'Windows Scheduled Tasks' then 5
when t.name like 'AppInsight for%' then 50
else count(c.id) end as 'LICENSES USED',
case when a.unmanaged = 1 then 'UnManaged'
else 'Managed' end as 'APPLICATION MANAGED?',
n.caption as 'NODE',
a.name as 'APPLICATION MONITOR',
t.name as 'TEMPLATE'
from apm_component c
join apm_application a on a.id = c.applicationid
join nodes n on n.nodeid = a.nodeid
join apm_applicationtemplate t on t.id=a.templateid
where (c.isdisabled is null or c.isdisabled = 0)
group by a.unmanaged, n.caption, a.name, t.name
order by 'licenses used' desc

 

 

Last modified

Tags

Classifications

Public