report-generator

Report Generator

Description

This script generates a high level report in xlsx format based on a JSON file generated by F5 Telemetry Tracker. This can be used for offline reporting. The report can also be generated in realtime/online by sending a GET request to F5 Telemetry Tracker /reporting/xls or /f5tt/reporting/xls endpoints.

sampledata.json is provided for testing purposes

Required python packages:

pip install flask
pip install requests
pip install xlsxwriter
pip install pandas

Usage

$ python3 reporting.py
reporting.py [json filename] [output xlsx filename]

$ python3 reporting.py sampledata.json samplereport.xlsx
-- Importing JSON
-- Analyzing CVE
-- Analyzing TMOS releases
-- Analyzing hardware devices
-- Analyzing Virtual Editions
All devices: 2
- Hardware : 0
- VE & vCMP: 2
All CVE    : 2
- Critical : 1
- High     : 0
- Medium   : 1
- Low      : 0
Output file written to samplereport.xlsx

Sample report

TMOS details

Hardware platforms details

CVE details