Creating a Modern Dashboard for some nodes in my organization

mickdon

Hi All, I'm trying to create a dashboard for some of my nodes; however,  I need to select only nodes that start with certain names for example

SELECT DisplayName, DetailURL FROM Orion.Nodes where Status =1 and DisplayName like 'ABC' or 'BCD' ORDER BY DisplayName DESC

This is erroring out when i try to validate the query. Any help will be greatly appreciated.

adam.beedell

Download the Orion SDK for SWQL studio, will make errors much easier to work with.

SELECT DisplayName, DetailsURL FROM Orion.Nodes where Status =1 and (DisplayName like 'ABC' or displayname like 'BCD') ORDER BY DisplayName DESC

That works ^

Two main problems

  - DetailsUrl is a plural
  - You need to redefine the thing to be compared to after an operator
      - Also the logic there would have displayed BCD stuff regardless of status, which is probably not what you intended