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

SWQL Query valid in SWQL Studio, Ambiguous in Modern Dashboard Widget

Good evening

I have made a SWQL query to get the following information:
-- Hosts (from Orion.VIM.Hosts) with the Cluster name (Orion.VIM.Clusters)

This runs successfully in SWQL studio but when I attempt to apply this to a empty table widget on a modern dashboard the following error occurs:
-- Provided SWQL query is not valid. Details: RunQuery failed, check fault information. Ambiguous column name DisplayName.

The query is really quite simple as I am new

>> SELECT h.DisplayName, h.Status, c.DisplayName
>> FROM Orion.VIM.Hosts h
>> JOIN Orion.VIM.Clusters AS c ON h.ClusterID = c.ClusterID
>> WHERE h.DisplayName LIKE 'esx%'

Because of my newness I am kind'a stuck here

Can someone help?

Find more posts tagged with

Comments

spaghettishapes

Issue is your duplicate displayname return in the select, the widget would like them to return different column headers.

This works instead:

SELECT h.DisplayName as [Host Name], h.Status, c.DisplayName as [Cluster Name]
FROM Orion.VIM.Hosts h
JOIN Orion.VIM.Clusters AS c ON h.ClusterID = c.ClusterID
WHERE h.DisplayName LIKE 'esx%'