report sam nodes

hello every body,

please in the company where I work i am looking for report on all SAM nodes, that is to say, I want a list of the equipment which consumes the SAM license in detail

best regards

Find more posts tagged with

sam

list

report

Accepted answers

All comments

Seashore

Thought that would be an easy one to answer. Thought first that all nodes polled with WMI took a license but that it not the whole truth. Then checked if polled with wmi + agent would be close to truth. Close but not exactly.

Also, it depends on what other modules you have:

The term "managed node" can be interpreted differently, depending on if you're using other Orion Platform modules with SAM:

In a SAM-only environment, a managed node is any entity from which SAM extracts data directly via supported polling methods (for example, WMI), Orion agents, or API pollers. Nodes monitored by Asset Inventory and/or Hardware Health are also considered managed nodes in a SAM-only environment.
If your environment includes SAM and other Orion Platform modules, the SAM node count has the potential to be additive to other modules that use node licensing, such as SolarWinds NPM. In a multi-module scenario, only nodes being monitored by SAM application monitors or API pollers are classified as managed nodes for SAM. Nodes monitored by Asset Inventory and/or Hardware Health do not impact licensing.

So first, witch one of above scenarios do you have? SAM only or several modules? Expect that you have SAM Node based licenses.

brahimovic

hi, thank you.

i have NMP, NCM, SAM, NTA

i have the list of all NCM nodes, but not yet the all SAM nodes

Seashore

This query seem to add up. How does it look on your side? Does the number of nodes returned match what orion license page say? Use this as base for your report.

SELECT 
    N.Caption
    ,N.IP_Address
    ,N.MachineType
FROM Orion.Nodes AS N
WHERE 
    N.NodeID IN (Select DISTINCT Nodeid FROM Orion.APM.Application)
    OR N.NodeID IN (SELECT DISTINCT RelatedEntityId FROM Orion.APIPoller.ApiPoller WHERE RelatedEntityType='Orion.Nodes')

brahimovic

yes, the licence SAM say to us that we had used more than 700, and this querry give us only 23 nodes

we try to understand why is more than 700 ,

neomatrix1217

On the Orion demo online you can export this report into your environment

christopher.t.jones123

@neomatrix1217 good find. I'm definitely grabbing that report. Thanks for sharing the find.

brahimovic

thank you, but not about component licensing

jpaluch

Not sure if this will help but you can get List of SAM components and their Ancestor/Parent by running this querry:

SELECT Name, AncestorDisplayNames, Disabled
FROM Orion.APM.Component
WHERE Disabled = 'False'

Seashore

Evening fun, SQL queries..... :-)

Composed a query that counts the component cost and take into account the specific cost for the appinsight templates. For some reason I don't get exactly the same number as the license page. But it's pretty close. Might be ok.

Import below as a report and see if it looks ok.

[View:/cfs-file/__key/communityserver-discussions-components-files/19/SAM_2B00_Component_2B00_based_2B00_licenses.xml:640:480]

If you only want the SQL query it looks like this:

SELECT Caption, SUM(Cost) AS Licenses FROM(
SELECT
	N.Caption
	,Count(C.ID) AS Cost
FROM Nodesdata  as N
INNER JOIN APM_Application AS A ON N.NodeID=A.NodeID AND A.Unmanaged=0
INNER JOIN APM_Component AS C ON A.ID=C.ApplicationID AND ISNULL(C.IsDisabled,0)=0
WHERE
	A.TemplateID NOT IN (273,308,430,587)
GROUP BY N.Caption

UNION ALL

SELECT
	N.Caption
	,SUM(CASE
		WHEN A.TemplateID=273 THEN 50 -- AppInsight For SQL
		WHEN A.TemplateID=308 THEN 50 -- AppInsight For Exchange
		WHEN A.TemplateID=430 THEN 30 -- AppInsight For IIS
		WHEN A.TemplateID=587 THEN 50 -- AppInsight For AD
	END) AS Cost
FROM Nodesdata  as N
INNER JOIN APM_Application AS A ON N.NodeID=A.NodeID AND A.Unmanaged=0
WHERE
	A.TemplateID IN (273,308,430,587)
GROUP BY N.Caption
) as Z
GROUP BY Z.Caption