Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

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
17:02, 30 Jan 2017

Tags

Classifications

Public