NPM Dashboard Customisation

Hi All,

I've been playing around quite a bit with reporting and dashboards over the last few days and am struggling to get some of the data in the format I want.

Before I spend too much more time on it, I'd like to know if what I'm trying to achieve is even possible out of the box, or if I'd need to look at custom development to get the data in the format I would like.

I've attached a simple mocked up example for what I can see in the GUI vs how I would like to display basic VM data. The percentage bars provide a nice visual, but I can't see a way to combine or use that source data in a new table or report.

Ideally, I would like to list my Nodes on separate lines with KPI data in the format shown, but if we set aside the possible pitfalls of that, is it even possible? How do I reference the CPU load and Memory used bars in a report, because I just can't see how I do it.

If I create a new view and add the resource "Top XX Volumes by Disk Space Used", I have data there that I want to use in another report, but I can't see how I add a percentage bar into a new report or even edit the layout of that report. It is even possible?

Many thanks in advance,

example.jpg

Find more posts tagged with

orion

report dashboard

Accepted answers

All comments

mesverrum

Natively you cannot do custom percent bars and the like, for that sort of thing I either simplify my requirements down to using icons, which you can make happen with SWQL, or I would move to something like SSRS.

In SWQL you can do something like this, with case sensitive icons to indicate breached thresholds. If you looked around I'm sure you could find the vendor icons as well for your machine type column

select n.caption as [Node], n.detailsurl as [_Linkfor_Node], n.ip_address as [IP],

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]

,CASE

WHEN 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]

,CASE

WHEN 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]

,CASE

WHEN 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]

,CASE

WHEN 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]

,CASE

WHEN 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 n

left join (SELECT count(NodeID) as [CPU Count], nodeid

FROM Orion.CPUMultiLoadCurrent

group by nodeid) cpu on cpu.nodeid=n.nodeid

order by caption

orioncrack

Can I ask where that table is constructed? Or what component? I'm trying a custom table resource but its not pretty like your's.

Thx

mesverrum

I generally use the custom query resource for these, that's the only place that the iconfor and linkfor functions work.

smatt

This is fantastic; thanks so much for posting this!

One of the limitations I've found with NPM / Orion is that you can't change a Nodes status based on aggregate values of sub-components, so for example you might have a disk full, but the Node still shows Green on a dashboard.

This seems like a viable way to report on the KPIs I want and I assume it would also allow me to change a status icons based on something like an SNMP trap being received in relation to a Node; something I’ll need to investigate.

Thanks again – it has definitely extended the capability I need.

orioncrack

Beautiful! Thank you!

One last SQL newb help request?

How can I inject a custom property filter to narrow the list down "Select/Where Customer eq McDonalds" (example company, I don't have any affiliation.)

EDIT - I guess I could limit nodes on the View. Testing that now.

EDIT 2 - yep device filter worked at the View level.

Thanks again. I'm sure everyone will now ask "Now if only we could add disks in there"...LOL

timt

mesverrum , this is a great view, thank you for sharing.

Since I have hundreds of servers for a certain application, would there be a way to have a high-level view, and group everything under a certain custom.property, instead of displaying servers per row?

The idea would be just to have a single row to represent all servers in a group, and set off the down/critical icon if the threshold triggers, then click on the link to expand out to your detail view?

mesverrum

I've done pretty elaborate tricks to consolidate data with SWQL, but they always struggle with that interactive element. These days I am finding what you are asking for would probably be very easy with a javascript custom HTML resource (assuming one is a front end web dev, or friends with one). I'm just still working on my JS skills so I can't write a widget to make it happen for you, but thats the direction the wind seems to be blowing these days in custom Orion biz.