4 Replies Latest reply on Aug 20, 2018 6:42 AM by rajasekar

    Custom DashBoard

    bartley

      I'm working on a custom dashboard, like already showed somewlere else in Thwack.

      Now i would like to create another filter on it but i don't know how.

      I want to filter this on a customproperty assigned on an interface instead of the node. How do i need todo this?

       

       

      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

       

      where

      --This is the part that's not working, but i don't know how to link to this?

      Orion.NPM.InterfacesCustomProperties.CircuitCode like 'A'

       

      order by caption