Hi - is there a way nodes can be identified via Country via swql on a modern dashboard
so if a node contains the letter 3 it is UK based etc as per below
3 - UK
5 - Roi
7 - NL
9 - BE
thanks in advance
I'd filter results with the where added to first, and count them after, something like this.
Select Count(t0.Caption) AS KPI_Numbe, t0.Location From (SELECT N.Caption, Case when N.Caption…
I use SWQL in modern dashboard, But I save my city data in Table Orion.NodesCustomProperties
SELECT TOP 10 ncpg_province, count(ncpg_province) as num_province
GROUP BY …
Sure, below I have a query, the first column is the node caption, and I try to find the location using a case statement in 2 ways. Location1 looks for the numeral anywhere in the name, Location2 looks…
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK© online community. More than 180,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.