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

Table chart (Modern DashBoard )

I would like to create a table chart (Modern Dashboard) that shows the total number of devices, as well as the status of devices (How many are in UP, Waring, Critical) for Cisco Palo Alto and Fortigate.

Please help some one.

Find more posts tagged with

Accepted answers

stevenstadel

Here is a SWQL query that may help, using different vendors since I have no Fortigate

SELECT n.Vendor,
COUNT (CASE n.Status WHEN '1' THEN 1 else NULL end) AS UP,
COUNT (CASE n.Status WHEN '2' THEN 1 else NULL end) AS DOWN,
COUNT (CASE n.Status WHEN '3' THEN 1 else NULL end) AS WARNING,
COUNT (CASE n.Status WHEN '9' THEN 1 else NULL end) AS UNMANAGED
FROM Orion.Nodes n
WHERE n.Vendor like 'Cisco' or n.Vendor like 'Windows'
GROUP BY n.Vendor

All comments

stevenstadel

Here is a SWQL query that may help, using different vendors since I have no Fortigate

SELECT n.Vendor,
COUNT (CASE n.Status WHEN '1' THEN 1 else NULL end) AS UP,
COUNT (CASE n.Status WHEN '2' THEN 1 else NULL end) AS DOWN,
COUNT (CASE n.Status WHEN '3' THEN 1 else NULL end) AS WARNING,
COUNT (CASE n.Status WHEN '9' THEN 1 else NULL end) AS UNMANAGED
FROM Orion.Nodes n
WHERE n.Vendor like 'Cisco' or n.Vendor like 'Windows'
GROUP BY n.Vendor

CourtesyIT

[View:/cfs-file/__key/communityserver-discussions-components-files/46/Device-Count-Error-02.gif:640:480]

I keep getting the following error.

CourtesyIT

I would like to use this one on the Classic Dashboards if possible.

Seashore

@CourtesyIT, Something like this?

Add a custom query widget and below code:

SELECT n.Vendor,
COUNT (CASE n.Status WHEN '1' THEN 1 else NULL end) AS UP,
COUNT (CASE n.Status WHEN '2' THEN 1 else NULL end) AS DOWN,
COUNT (CASE n.Status WHEN '3' THEN 1 else NULL end) AS WARNING,
COUNT (CASE n.Status WHEN '9' THEN 1 else NULL end) AS UNMANAGED,
CONCAT('/NetPerfMon/Images/Vendors/',N.VendorIcon) AS [_IconFor_Vendor]

FROM Orion.Nodes n
WHERE n.Vendor like 'Cisco' or n.Vendor like 'Windows'
GROUP BY n.Vendor, N.VendorIcon