0 Replies Latest reply on Nov 9, 2017 2:03 PM by bman6074

    SWQL code Help

    bman6074

      What do I have wrong? After adding the E0.[AlertActive].[triggeredDateTime] for the triggered date and time the script fails. I am still learning SWQL coding. So haven't fully grasp the logic yet.

       

      SELECT E0.[Uri], E0.[DisplayName], E0.[Node].[Caption], E0.[VolumeType], E0.[Node].[EngineID], E0.[StatusLed], E0.[AlertActive].[triggeredDateTime]

      FROM Orion.Volumes AS E0

      WHERE ( ( E0.[Node].[Status] != '9' ) AND ( E0.[Node].[Status] != '2' ) AND ( ( ( E0.[Status] = '2' ) ) ) AND ( ( ( E0.[Type] = 'Fixed Disk' ) OR ( E0.[Type] = 'Mount Point' ) OR ( E0.[Type] = 'FixedDisk' ) ) ) )