nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
- SolarWinds Academy
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Modern Dashboards - KPI

karunakar.enugula

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

Find more posts tagged with

npm

Comments

Lofstrand

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%'

karunakar.enugula

Hi Team,

we are looking total infra percent for the customproperty field in environmen like LAN & WAN infra upercent detials.

Lofstrand

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

naveensingh43

Please review the link below; it will help you.

Modern Drill-Down Dashboard – Built for Real-Time Infra Insights - THWACK

Quick Links

PALO-ALG - Logging
PALO-ALG - Logging.xmlPalo Alto Networks ALG Security Technical Implementation Guide :: Version 2, Release: 3 Benchmark Date: 27 Oct 2022
Alert HTML Content
Alert Cleared.htmlHello, I would like to share the HTML template details we have prepared so that Solarwinds alarms can become more meaningful. It can list alarm object details and connected device details separately in HTML template. Except for object and device details, you can easily add custom property information…
Cisco ASR Devices
Cisco ASR Devices.pollerCisco ASR Devices
Basic SWQL Syntax
SWQL is built on the framework of SQL and as such supports most of the standard clauses as part of a query. A very simple example query is: SELECT Caption, IPAddress, Vendor, ResponseTime FROM Orion.Nodes Dissecting this query is relatively straightforward: show some fields (Caption, IP address, Vendor, and Response Time)…