Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

SAM Licenses by Group and Node

SAM License Usage by App and Group:

SELECT c.Name AS [GROUP NAME],a.Name AS [APPLICATION NAME],CASE    WHEN a.CustomApplicationType = 'ABXA' THEN '50'    WHEN a.CustomApplicationType = 'ABSA' THEN '50'    WHEN a.CustomApplicationType = 'ABIA' THEN '30'    WHEN a.CustomApplicationType = 'ABTA' THEN '5'    ELSE COUNT(a.Components.ComponentID)END AS [LICENSES],CASE     WHEN a.Unmanaged = 1 THEN 'YES'    ELSE 'NO'END AS [UNMANAGED?]FROM Orion.APM.Application aJOIN Orion.Container c ON c.MemberSnapshots.EntityID = a.NodeID WHERE a.Components.Status <> 27 --Not DisabledAND c.MemberSnapshots.EntityType = 'Orion.Nodes'GROUP BY c.Name, a.Name, a.CustomApplicationType, a.UnmanagedORDER BY c.Name, a.Name, [LICENSES] DESC

SAM License Usage by Node:

SELECT a.Name AS [APPLICATION NAME],a.Node.Caption AS [DEVICE NAME],CASE    WHEN a.CustomApplicationType = 'ABXA' THEN '50'    WHEN a.CustomApplicationType = 'ABSA' THEN '50'    WHEN a.CustomApplicationType = 'ABIA' THEN '30'    WHEN a.CustomApplicationType = 'ABTA' THEN '5'    ELSE COUNT(a.Components.ComponentID)END AS [LICENSES],CASE     WHEN a.Unmanaged = 1 THEN 'YES'    ELSE 'NO'END AS [UNMANAGED?]FROM Orion.APM.Application aWHERE a.Components.Status <> 27 --Not DisabledGROUP BY a.Node.Caption, a.Name, a.CustomApplicationType, a.UnmanagedORDER BY a.Name, [LICENSES] DESC

Find more posts tagged with

sam_licensing

Accepted answers

All comments

dnerdahl

Database scheme has changed. This query does not properly exclude components that are assigned but disabled.

zackm

thanks for the notice, updated to use SWQL and avoid any future schema changes

martian_monster

Thank you the SAM by node is exactly what I needed.

cloud_ops

I get this error when I run both querys

Msg 208, Level 16, State 1, Line 1

Invalid object name 'Orion.APM.Application'.