Retrieving a List of Devices Experiencing Reachability Issues in the Last 24 Hours

Products

• CA Performance Management
• Network Observability

Issue/Introduction

How can I get a  list of devices encountering reachability issues within the past 24 hours ?

Environment

Dx NetOps Performance Management All releases

Resolution

With this OData query, you can sort by count and get a list of devices that had less successful polling during the selected time interval, in this case, 24 hours:

HTTPS:

https://DA:8582/odata/api/devices?$apply=groupby(reachabilitymfs/ID, aggregate(reachabilitymfs(im_Reachability with countdistinct as Value))) &resolution=RATE&period=1d&$select=ID,Name,PrimaryIPAddress, reachabilitymfs/Value&$filter=((reachabilitymfs/im_Reachability lt 1))&$format=text/csv

 

Or if HTTP:

https://DA:8581/odata/api/devices?$apply=groupby(reachabilitymfs/ID, aggregate(reachabilitymfs(im_Reachability with countdistinct as Value))) &resolution=RATE&period=1d&$select=ID,Name,PrimaryIPAddress, reachabilitymfs/Value&$filter=((reachabilitymfs/im_Reachability lt 1))&$format=text/csv

This query will return a CSV formatted list including the device ID, name, primary IP address, and the count of less successful polling attempts.