Hello community.
I am trying to nest a query in SWQL Studio since I want to generate an alert on (interfaces) that tells me when the Percentage of Errors is greater than 5%.
The first part is already executed,
SELECT TOP 10 PercentErrors
FROM Orion.NPM.InterfaceErrors
Where DATETIME > ADDMINUTE(-10,GETUTCDATE()) AND (ReceivePercentErrors > 5 or TransmitPercentErrors > 5)
However, I need to add 4 Custom Properties from my nodes:
FROM Orion.NodesCustomProperties
Region, Device_Type, Enviroment, SITECODE
And the Caption
FROM Orion.Nodes
Caption
Could you help me complete it?
