Hello,
I created a group and put 3 servers in it. When I add a Top 10 nodes by Average CPU load to the dashboard, it shows me all other servers. What I want to do is have dashboard items show me only the nodes in this group. Is this possible?
Top 10 resource will always pick up all nodes, regardless on what page you will add it. So, adding it on group page will not limit it to these group's nodes. I never needed this myself and I would love to know as well if anything like that would be doable by any other means.
Thank you Alex. I was kind of able to figure it out, but just for CPU Load. For the average CPU load every 5 minutes, there is an option for "Automatically display nodes related to the current view". When I select that, it does only show me what is in the group.
For me it does suit my purposes, however I wish other monitors were like that.
Hello Baronson,
You can also apply a filter to any of the Top XX Resources or use the Custom Resources with the option you mentioned above. If you use the edit option within the resource and apply a SQL based filter it will give you the data you want to display. A good example of this is on the Response Time Top XX, I filter for Nodes that are not Down. This syntax is Status <> 2, which is any status but Down. There are many ways to filter a view or in some cases build unique views for Groups to Allow for items like Custom Maps per Group.
Best Regards,
Derik Pfeffer
Loop1 Systems: SolarWinds Training and Professional Services
Indeed so. TOP 10s don't have EDIT button. I was able to find the one which has. In NPM 11.5 it is called "Top XX Hosts by CPU Load" and "Top XX Nodes by Average CPU Load". Would you be able to help with the correct filter? It seems that property "MemberOfTheGroup" is not available
Another remark to consider - if you will manage to add this this filter to display only nodes in a specific group - this will stay so even if you move to another group... meaning that it will show you top 10 of one specific group even if you are on the landing page of another group. Solution with "Automatically display nodes related to the current view" would be more preferable
Hello, did you ever find a solution to this issue. I too would like to display Top XX nodes for only nodes in the selected group which seems very logical. Did you find the correct filter or any other way to accomplish this?
I've done this using custom properties, or if you just want to do it based on group membership then you get into having to do it with custom SWQL. I've attached one example of a SWQL query I use on my Group Details page to bring up all the major node metrics. You could make it a top 10 by ordering by whatever column you want and changing the first line to say select top 10 ...
select n.Caption, n.IP_Address, c.detailsurl as [_linkfor_Caption],case when n.cpuload < 0 then 'Not Polled'when n.host.nodeid is not null and n.host.cpucorecount is not null then concat(round(n.host.cpuload,0),'% of ',n.host.CpuCoreCount,' CPU')when cpu.[cpu count] is not null then concat(cpuload,'% of ',cpu.[cpu count],' CPU')else 'Polling Error'end as [CPU Load],'/Orion/NetPerfMon/CustomChart.aspx?chartName=HostAvgCPULoad&NetObject=N:'+tostring(n.nodeid)+'&Period=Today' as [_linkfor_CPU Load],CASEWHEN cpuload >= n.CpuLoadThreshold.Level2Value THEN '/Orion/images/StatusIcons/Small-Critical.gif'WHEN cpuload >= n.CpuLoadThreshold.Level1Value THEN '/Orion/images/StatusIcons/Small-Warning.gif'WHEN cpuload < n.CpuLoadThreshold.Level1Value THEN '/Orion/images/StatusIcons/Small-Up.gif'END AS [_IconFor_CPU Load],case when percentmemoryused < 0 then 'Not Polled'else concat(percentmemoryused,'% of ',(round(n.totalmemory/1073741824,0)),' GB')end as [Memory Used],'/Orion/NetPerfMon/CustomChart.aspx?chartName=HostAvgPercentMemoryUsed&NetObject=N:'+tostring(n.nodeid)+'&Period=Today' as [_linkfor_Memory Used],CASEWHEN percentmemoryused >= n.percentmemoryusedThreshold.Level2Value THEN '/Orion/images/StatusIcons/Small-Critical.gif'WHEN percentmemoryused >= n.percentmemoryusedThreshold.Level1Value THEN '/Orion/images/StatusIcons/Small-Warning.gif'WHEN percentmemoryused < n.percentmemoryusedThreshold.Level1Value THEN '/Orion/images/StatusIcons/Small-Up.gif'END AS [_IconFor_Memory Used],CASEWHEN responsetime<0 then 'No Response'ELSE concat(responsetime,' ms') END AS [Latency],'/Orion/NetPerfMon/CustomChart.aspx?chartName=AvgRt&NetObject=N:'+tostring(n.nodeid)+'&Period=Today' as [_linkfor_Latency],CASEWHEN responsetime >= n.responsetimeThreshold.Level2Value THEN '/Orion/images/StatusIcons/Small-Critical.gif'WHEN responsetime >= n.responsetimeThreshold.Level1Value THEN '/Orion/images/StatusIcons/Small-Warning.gif'WHEN responsetime < n.responsetimeThreshold.Level1Value THEN '/Orion/images/StatusIcons/Small-Up.gif'END AS [_IconFor_Latency],concat(percentloss,'%') as [Packet Loss],'/Orion/NetPerfMon/CustomChart.aspx?chartName=PercentLoss&NetObject=N:'+tostring(n.nodeid)+'&Period=Today' as [_linkfor_Packet Loss],CASEWHEN percentloss >= n.percentlossThreshold.Level2Value THEN '/Orion/images/StatusIcons/Small-Critical.gif'WHEN percentloss >= n.percentlossThreshold.Level1Value THEN '/Orion/images/StatusIcons/Small-Warning.gif'WHEN percentloss < n.percentlossThreshold.Level1Value THEN '/Orion/images/StatusIcons/Small-Up.gif'END AS [_IconFor_Packet Loss]from orion.nodes njoin orion.nodescustomproperties cp on cp.nodeid=n.nodeidjoin Orion.ContainerMembers c on c.memberprimaryid=n.nodeidleft join (SELECT count(NodeID) as [CPU Count], nodeidFROM Orion.CPUMultiLoadCurrentgroup by nodeid) cpu on cpu.nodeid=n.nodeidwhere MemberEntityType like 'orion.nodes'--and c.containerid like ${id}--and n.caption like '%${SEARCH_STRING}%' order by n.caption
You know, as crazy as it sounds - I do not use groups at all I am yet to find what sort of value they really deliver. Not a bad thing to have in a tool box, but as of now I see it as a extra overhead for teams to manage.
So, how do I do my grouping then? By custom properties, same as mesverrum has mentioned below. For nesting I use "All Nodes" resource and set grouping of up to three level deep, based on custom properties. All reports, alerts, dashboards, resources, etc - all is configured with filters based on custom properties. In fact, your top 10 can be easily filtered down to whatever you like from within top 10 settings of the resources based ... ye, you guessed it - CUSTOM PROPERTIES.
Check this thread initiated by DanielleH for some inspirational ideas:
https://thwack.solarwinds.com/community/solarwinds-community/announcements/blog/2015/10/01/custom-properties-how-do-you-…
