Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > Server & Application Monitor (SAM) > 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