Generate Progress connection number line chart by parsing .lic file

Install plotly's python package

pip install plotly

https://plot.ly/python/getting-started/

Example script

import time  
import plotly  
from plotly.graph_objs import Scatter, Layout

today=time.strftime("%m/%d/%y")

max_count=[]  
min_count=[]

#only generate working hour connection chart
workingtime=['09:00:00','10:00:00','11:00:00','12:00:00','13:00:00','14:00:00','15:00:00','16:00:00','17:00:00','18:00:00']

#Open file and read line by line
for line in open(r'/PATH/TO/DB/dbname.lic','r'):  
    elements=line.split()
    if elements[0]==today and elements[1] in workingtime:
        print(line)
        max_count.append(elements[4])
        min_count.append(elements[5])

trace1 = Scatter(  
    x=workingtime,
    y=max_count,
    name='MaxConnection',
    fill='tozeroy'
)
trace2= Scatter(  
    x=workingtime,
    y=min_count,
    name='MinConnection',
    fill='tonexty'
)

data = [trace1, trace2]  
plotly.offline.plot(  
    {"data": data, "layout": Layout(title="Daily QAD License Usage Report",xaxis=dict(title='Report Date:'+today), yaxis=dict(title='Connections'))},
    show_link=False,
    filename='ConnectionChart.html',
   auto_open=False)