This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

how i know this devices availability monthly or weekly

concat(round(avg(Availability), 2), ' %' ) as Network
FROM Orion.ResponseTime rt
monthdiff(datetime,getdate())=0 and rt.Node.CustomProperties.TETCO_Teams='Network'