3wal · IT Officer

Thanks! Useful info, is there any way I can add a widget to a dashboard that can show me a particular route? if so, how to?

Highly needed!

Try this query to check the last time the entity you're querying was updated, UnDP will retrieve information via SNMP based on the OIDs that you've defined. The Orion entities uses different methods to pull data and feed the tables. SELECT FirstUpdate, LastUpdate FROM Orion.Packages.Wireless.AccessPoints WHERE…

Thanks @"marcrobinson" this worked for me. Now is juts a matter to clean the query a bit. Thanks a lot!

Hi, Use the 'CRC Align Errors This Hour' value greater than your defined threshold/room for errors, and set your alert to evaluate the condition every 1,5, or 10 mins as needed. The alert won't wait for an hour to evaluate the condition but will do it based on the specified time you set. If the CRC Align Errors This…

Hi, To achieve this you'll need to query two entities: Orion.Nodes & Orion.NodesCustomProperties These two entities have a value in common "NodeID" which will help you to asociate the numbered value with the system name of the device. SELECT TOP 1 Nodes.SysName, NodesCustomProperties.NO_ALERT_NODE FROM Orion.Nodes,…

Thanks! It worked for me

An easy and elegant solution.

Thanks shuth! It worked, I also made it work with a little variation but I found yours more simple. SELECT CASE WHEN ResponseTime > 300 THEN 'NotOK' WHEN ResponseTime < 300 THEN 'OK' ELSE 'Down' END AS NodeStatus FROM Orion.NodesStats WHERE NodeID LIKE '1'

It helped me, thanks a lot!

Thanks for the contribution, it helped me.