Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register 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