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

Table chart (Modern DashBoard )

jamshad.abdulrahiman

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

CourtesyIT

Getting same thing within the Classic dashboard. The modern one works great. Also, I have installed SolarWinds on a separate Drive (E:\) not on C:\ so my links to icons and such dont work.

Seashore

What kind of error do you get? If the same as on your posted picture above you are using "custom table widget". Use "custom query widget" instead.

The path to icons are relative to the web installation so drive letter should not matter.

CourtesyIT

Same error as above.

But the results show below

Seashore

But that does not look like a Custom QUERY widget.

The edit page should look like this:

CourtesyIT

Success! Thanks,

I commented out the where to get all devices