find_lagging_series_by_metric.py

from datetime import timedelta, datetime

from atsd_client import connect, connect_url
from atsd_client.services import MetricsService
from atsd_client.utils import print_tags

'''
Locate series that have no data during the actual time interval (grace_interval) using specific metric.
'''

# Connect to ATSD server
#connection = connect('/path/to/connection.properties')
connection = connect_url('https://atsd_hostname:8443', 'username', 'password')

# set metric and grace_interval to one day
metric = 'nmon.cpu.busy%'
grace_interval_minutes = 24 * 60
# query entities with last_insert_date
min_insert_date = "1970-01-01T00:00:00.000Z"
# calculate the upper boundary for the allowed last_insert_date values excluding grace_interval
max_insert_date = datetime.now() - timedelta(seconds=grace_interval_minutes * 60)
metrics_service = MetricsService(connection)

# query all series for metric
series = metrics_service.series(metric, min_insert_date=min_insert_date, max_insert_date=max_insert_date)

print('metric,entity,tags,last_insert_date')
for s in series:
    print("%s,%s,%s,%s" % (s.metric, s.entity, print_tags(s.tags), s.last_insert_date))