• Locked Locked
  • Replies 1 reply
  • Subscribers 24 subscribers
  • Views 1334 views
  • Users 0 members are here
Options
Related
This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

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

mpepprell

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?

Parents

  • 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%'

Reply

  • 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%'

Children
No Data

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.