The Orion Platform

Custom Queries Run a query about licensed component monitors in SAM

Run a query about licensed component monitors in SAM

The query is from the below site but re-written to work in SWQL Studio or a custom query

Run a report about licensed component monitors in SAM (solarwinds.com)

Hope its useful, I also adjust the case part and just show the column data as I want to found out the actual total not that its 50 for AppInsight, etc.

replace -

CASE WHEN r.Template = 'Windows Scheduled Tasks' THEN 5 WHEN r.Template LIKE 'AppInsight for IIS' THEN 30 WHEN r.Template LIKE 'AppInsight for%' THEN 50 ELSE COUNT(r.[ComponentID])

with this -

COUNT(r.[ComponentID]) AS [Licenses Used]

dodo123

Top Comments

bobmarley 11 months ago +1

The query mentioned is a SQL query.

If you follow these instructions but choose SQL instead of SWQL your report will work.

thwack.solarwinds.com/.../how-to-create-a-report-from-a-swql-query

bobmarley 11 months ago

The query mentioned is a SQL query.

If you follow these instructions but choose SQL instead of SWQL your report will work.

thwack.solarwinds.com/.../how-to-create-a-report-from-a-swql-query
- Cancel
- Up +1 Down
- Reply
- More
- Cancel

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK^® online community. More than 190,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.