Table chart (Modern DashBoard )

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

I keep getting the following error. 

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

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

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.  

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.

Same error as above.  

But the results show below

But that does not look like a Custom QUERY widget. 

The edit page should look like this:

Success!  Thanks, 

I commented out the where to get all devices