Dear All,
We are modern dashboard inthe tool, we want to overall infra percentage in dashboard could you please suggest the same.
Thank You
karunakar
Not sure I fully understood the question, but here is a new version where we filter to only show nodes where the custom property field "environment" is LIKE "%LAN & WAN%". Hope that at least give you the guidance to adjust according to your need:
SELECT ROUND((100.0 * COUNT(N1.NodeID) /( SELECT COUNT(N2.NodeID) AS Nodes FROM Orion.Nodes AS N2 WHERE N2.Status NOT IN (11,9,27) -- Unmanaged, external and disabled ) ),2) AS PercentOK FROM Orion.Nodes AS N1 WHERE N1.Status=1 OR N1.Status=2 -- Up or Warning AND N1.CustomProperties.environment LIKE '%LAN & WAN%'
Hi Team,
we are looking total infra percent for the customproperty field in environmen like LAN & WAN infra upercent detials.
Like this?
A KPI widget based on below SWQL query:
SELECT ROUND((100.0 * COUNT(N1.NodeID) /( SELECT COUNT(N2.NodeID) AS Nodes FROM Orion.Nodes AS N2 WHERE N2.Status NOT IN (11,9,27) -- Unmanaged, external and disabled ) ),2) AS PercentOK FROM Orion.Nodes AS N1 WHERE N1.Status=1 OR N1.Status=2 -- Up or Warning
Please review the link below; it will help you.
Modern Drill-Down Dashboard – Built for Real-Time Infra Insights - THWACK
Cisco Firepower Threat Defense FTD-1.3.6.1.4.1.9.1.2320.ConfigMgmt-CommandsExported with NCM 2023.4.2
AlertSummary.xmlHi All, I've done some work to tidy up our alert definitions (both the Alert Manager and Alert Actions) and the more important alerts have now been tailored and given a "[ *** ]" prefix so it is easy to see the alerts we have catered for versus those that might appear once in a while. I am monitoring this…
I wanted to share a new dashboard a co-worker ( @mblackburn ) came up with to help us better view groups of interfaces and various metrics for each. Using a single HTML widget, we are able to visually compare numerous different interfaces by populating each interface dataset onto its own graph. We are able to view…
PALO-ALG - Logging.xmlPalo Alto Networks ALG Security Technical Implementation Guide :: Version 2, Release: 3 Benchmark Date: 27 Oct 2022