Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

 

 

 

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