Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
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

need help is swql query

i need to add ( orion.nodescustomproperties = city ) in mention query so that i can city wise report than will import to custom pie chart.

SELECT SI.StatusName AS Status, COUNT(Status) AS Total FROM Orion.Nodes N INNER JOIN Orion.StatusInfo SI ON SI.StatusId = N.Status GROUP BY SI.StatusName ORDER BY Total DESC

Where orion.nodescustomproperties = city

but its not working

Find more posts tagged with

Comments

makecrazy

plzz help on this query

alain_p

Hi makecrazy

You will need to join an extra table to get this working.

SELECT
SI.StatusName AS Status
, COUNT(N.Status) AS Total
FROM Orion.Nodes N
INNER JOIN Orion.StatusInfo SI ON SI.StatusId = N.Status
JOIN Orion.NodesCustomProperties AS CP ON N.NodeID = CP.NodeID
WHERE CP.City LIKE 'XXXXX' <--- Please replace XXXXX with your value
GROUP BY SI.StatusName ORDER BY Total DESC

Hope this helps you out.

Kind regards,

alain_p

makecrazy

not giving any value

makecrazy

need city average AVAILABILITY

tony.johnson

Where do you intend to use this data? Is it a modern dashboard or Orion web-based report? Also over what time period are you looking to get the data? Keep in mind that you will be averaging averages as you will have a value for each node which you will be grouping by City.

Quick Links

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)…
Cisco ASA SSL Tunnels
Active SSL Tunnels-ASA.UnDPThis poller *should* display the number of Active SSL VPN (Anyconnect) Tunnels currently connected to your box. However, I tried it with my 5520 running 8.0.4 and for some reason I get a OID Not Supported. Here's my post in the forum: *EDIT* This is confirmed working with at least Interm release…
HP ProCurve Switches Hardening check
HP ProCurve Switches Hardening check.xmlGeneral hardening for HP switches