The SolarWinds Platform

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 -

<span class="s5">CASE</span><span class="s0"> </span><span class="s5">WHEN</span><span class="s0"> </span><span class="s11">r</span><span class="s10">.</span><span class="s11">Template</span><span class="s0"> </span><span class="s10">=</span><span class="s0"> </span><span class="s7">&#39;Windows Scheduled Tasks&#39;</span><span class="s0"> </span><span class="s5">THEN&nbsp;</span><span class="s4">5</span><span class="s0"> </span><span class="s5">WHEN</span><span class="s0"> </span><span class="s11">r</span><span class="s10">.</span><span class="s11">Template</span><span class="s0"> </span><span class="s5">LIKE</span><span class="s0"> </span><span class="s7">&#39;AppInsight for IIS&#39;</span><span class="s0"> </span><span class="s5">THEN</span><span class="s0">&nbsp;</span><span class="s4">30</span><span class="s0"> </span><span class="s5">WHEN</span><span class="s0"> </span><span class="s11">r</span><span class="s10">.</span><span class="s11">Template</span><span class="s0"> </span><span class="s5">LIKE</span><span class="s0"> </span><span class="s7">&#39;AppInsight for%&#39;</span><span class="s0"> </span><span class="s5">THEN</span><span class="s0">&nbsp;</span><span class="s4">50</span><span class="s0"> </span><span class="s5">ELSE</span><span class="s0"> </span><span class="s20">COUNT</span><span class="s10">(</span><span class="s11">r</span><span class="s10">.[</span><span class="s11">ComponentID</span><span class="s10">])</span>

with this -

<span class="s20">COUNT</span><span class="s10">(</span><span class="s11">r</span><span class="s10">.[</span><span class="s11">ComponentID</span><span class="s10">])</span><span class="s0"> </span><span class="s5">AS</span><span class="s0"> </span><span class="s10">[</span><span class="s11">Licenses</span><span class="s0"> </span><span class="s11">Used</span><span class="s10">]</span>