CARION

YEs it does return one value. To me it seems like the nested SELECT is not supproted inside CASE function. i have tested this with a simple SELECT query with not luck: , CASE When AO.RealEntityType= 'Orion.Groups' then ( SELECT N.CustomProperties.Type_Node FROM Orion.Nodes AS N Where N.IPAddress= '192.168.0.23' ) ELSE…

Hey Adam thanks for answering, im facing an error while processing this request. i need to retreive a Custom Property when the alert is based on agroup. The whole SWQL works fine until i add this one: , CASE When AO.RealEntityType= 'Orion.Groups' then ( SELECT N.CustomProperties.Type_Node FROM Orion.Nodes AS N LEFT JOIN…

is it possible to use SELECT statement after then when use CASE function ? THEN SELECT SWQL CODE THEN (SELECT SWQL CODE) i tested both examples but it seem that it's not working i get There was an error processing the request.

i was using a custom query , i changed it into a custom table and it works perfectly. thanks Adam for the tip.

Hey Adam, tanks for your answer. i tested your answer cause it looks very interesting to format the display of the severity but it didn't work work me: 

Thanks a lot for your help, the function toString helped me solve the problem.

Thanks all for your help, Group By did help me solve my issue.

Thanks KMSigma for your answer but i'm getting one value using 'OR' syntax also.

Thanks for taking time to reply. let me explain the reason why we are using groups in the first place, we have several types of nodes (network equipements) and we use a Custom Property called Type_NODE to classify them. Nodes that works in a single model like access switches: we use alert based on nodes custom prototype ,…

The project manager (Not a technical persone) emphasises the fact to add the AP into ORION but the enginners refused that due the high number of nodes to monitor and adding the AP will impact extremely the performances of ORION. that's the reason why i was thining that if we can provide the AP status through the controler…

Thank you so much DONROBERT5 for your reply. would you please confirm to me this info: i can get the status (alert) of an AP even if the AP is not added to ORION instance ?