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' ) ) ) )