从log抓licenses使用绘图

过年那几天写的，比较忙，不整理了，不全，只有提取数据部分。

# -*- conding:utf-8 -*-
import paramiko
import re
import csv
from datetime import datetime
import numpy as np
import matplotlib.pyplot as plt
import matplotlib.dates as md

ip = [
'172.20.25.88',
'172.20.14.167',
'172.20.14.176',   
'172.20.25.70',    
'172.20.25.79',   
'172.20.25.200',  
'172.20.25.208',   
'172.20.25.218',  
'172.20.25.226',  
'172.20.24.231',   
'172.20.24.241',   
'172.20.30.9',     
'172.20.30.18',    
'172.20.30.27',    
'172.20.30.36',
]

d_to_n = lambda date:("").join(date.split('-'))

def average(a=[]):
    b = len(a)
    sum = 0
    for i in a:
        sum += i
    aver = sum/b
    return aver

ssh = paramiko.SSHClient()
ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy())

def get_date():
    ssh.connect(hostname='172.20.25.88',port=22,username='cmd',password='cgadmin!')
    cmd =  'cat /cdr/work/logs_dupprev/logs/LicenseStatistics_`hostname`.log'
    stdin,stdout,stderr = ssh.exec_command(cmd)  
    dates = []
    lices = []
    res = {}
    for i in stdout:
        if re.search('CDR',i):
            try:
                res[d_to_n(i.split(' ')[0])] = int(i.split(':')[-1].strip())
            except ValueError:
                pass
    for k,v in sorted(res.items(),key=lambda x:x[0]):
        if int(k) > 20171110:
            dates.append(k) 
    return dates
    ssh.close()

def get_lic(ip):
    ssh.connect(hostname=ip,port=22,username='cmd',password='cgadmin!')
    cmd =  'cat /cdr/work/logs_dupprev/logs/LicenseStatistics_`hostname`.log'
    stdin,stdout,stderr = ssh.exec_command(cmd)
    dates = []
    lices = []
    res = {}
    for i in stdout:
        if re.search('CDR',i):
            try:
                res[d_to_n(i.split(' ')[0])] = int(i.split(':')[-1].strip())
            except ValueError:
                pass
    for k,v in sorted(res.items(),key=lambda x:x[0]):
        if int(k) > 20171110:
            dates.append(k)
            lices.append(res[k]) 
    return lices
    ssh.close()

print get_lic('172.20.25.200')