def get_records_list():
"""
Obtains list of all records for given type given time range.
:return: JSON with status "ok" or "error" and requested data.
"""
# Check login
if not session.logged:
json_response = '{"status": "Error", "data": "You must be logged!"}'
return json_response
# Check mandatory inputs
if not (request.get_vars.beginning and request.get_vars.end and request.get_vars.filter):
json_response = '{"status": "Error", "data": "Some mandatory argument is missing!"}'
return json_response
# Parse inputs and set correct format
beginning = escape(request.get_vars.beginning)
end = escape(request.get_vars.end)
filter = escape(request.get_vars.filter)
try:
# Elastic query
client = elasticsearch.Elasticsearch(
[{'host': myconf.get('consumer.hostname'), 'port': myconf.get('consumer.port')}])
elastic_bool = []
elastic_bool.append({'range': {'@timestamp': {'gte': beginning, 'lte': end}}})
elastic_bool.append({'term': {'@type': 'external_dns_resolver'}})
# Set filter
if filter != 'none':
elastic_should = []
elastic_should.append({'term': {'src_ip': filter}})
elastic_should.append({'term': {'resolver_ip.raw': filter}})
elastic_bool.append({'bool': {'should': elastic_should}})
qx = Q({'bool': {'must': elastic_bool}})
# Search with maximum size aggregations
search = Search(using=client, index='_all').query(qx)
search.aggs.bucket('by_src', 'terms', field='src_ip', size=2147483647)\
.bucket('by_dst', 'terms', field='resolver_ip.raw', size=2147483647)\
.bucket('top_src_dst', 'top_hits', size=1, sort=[{'timestamp': {'order': 'desc'}}])
results = search.execute()
# Result Parsing into CSV in format: timestamp, source_ip, resolver_ip, flows
data = ""
for src_aggregations in results.aggregations.by_src.buckets:
for result in src_aggregations.by_dst.buckets:
record = result.top_src_dst.hits.hits[0]["_source"]
data += record["timestamp"].replace("T", " ").replace("Z", "") + "," + record["src_ip"] + "," \
+ record["resolver_ip"] + "," + str(record["flows"]) + ","
data = data[:-1]
json_response = '{"status": "Ok", "data": "' + data + '"}'
return json_response
except Exception as e:
json_response = '{"status": "Error", "data": "Exception: ' + escape(str(e)) + '"}'
return json_response
评论列表
文章目录