How can you see the last poll time for interfaces, sorted by oldest first

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

How can we monitor/capture interfaces that stopped polling?

Resolution

You can accomplish this via the Data Aggregator OpenAPI and the following query as a baseline.  It will show the interfaces with data points sometime within the last 4 hours, sorted with the oldest at the top:

http://daHostname:8581/odata/api/portmfs?$apply=groupby(ID,%20aggregate(Timestamp%20with%20max%20as%20Value))&&resolution=RATE&period=4h&$orderby=Value%20asc&$expand=interface,device&$select=ID,Value,interface/Name,device/ID,device/Name,device/PrimaryIPAddress?$format=text/csv

From here you can open the output file in something like Excel or Google Sheets and view the entries in a table form.