Would like to graph this and possible plot on dashboard. I have one for CPU/Memory and have non graph for Elements, but looking to have them on same graph. Save me some time if someone already has this.
Zak
Do you just mean something like this?
If not, it would actually be best if you could provide a doodle of what you are thinking about if if you want it as a dashboard, a report, or something else (like widgets on a Node Details page). Screenshots would be best if you can.
[View:/cfs-file/__key/communityserver-discussions-components-files/46/High_2B00_Node_2B00_Utilization_2B00_Report.xml:320:240]
Yes, that is close. I have this but want to add Element count per server also to same graph.
Yeah - can't have more than 2 things per chart with report-based charting. You could have a second chart (or table) that shows the element count (not sure what exactly you mean here), but my gut tells me that would have to be custom SWQL.
That is what I am trying to do, from what I can find only Custom SQL for elements but was seeing if someone has away of plotting on same graph. I will see what I can do an maybe 2nd chart if only way. Thanks for looking!
That's the beauty of the web-based report writer, you can keep adding report objects to it. What exactly do you mean by "element count"? Maybe I can add it to the previous report.
I made this, but was hoping to get Orion to graph this. Elements, meant number of elements Poller is monitoring.
This is from the Engines table? There's no historical data to show there, so it wouldn't be a graph. Could make a nice chart in a Modern Dashboard though.
Yeah, that is what I did. Added this query in a dashboard. But I don't think the widget exists of what I wanted to do. Thanks for checking
This sounds awesome, any chance of sharing this query for the Modern Dashboard?
Solarwinds Capacity Planning query
SELECT Engines.ServerName AS ServerName, Engines.PollingCompletion AS Polling, ((Engines.Elements *100) / 22700) AS Perc_of_Max,
Nodes.PercentMemoryUsed, Nodes.CpuLoad, EnvironmentalOverview.CPUinfo AS CPUs, EnvironmentalOverview.RAMinfo as RAM,
Engines.Elements AS Elements, Engines.Nodes AS Nodes
FROM Engines
INNER JOIN Nodes ON Engines.ServerName=Nodes.Caption
INNER JOIN EnvironmentalOverview ON Engines.ServerName=EnvironmentalOverview.HostName
ORDER BY Perc_of_Max DESC
Cheers Zak
