for machine in qry_all_machines:
data_e_hora_atuais = datetime.now()
ref_time = RefTime(time_ref=data_e_hora_atuais, machine_id=machine.id)
session.add(ref_time)
session.commit()
try:
con_ssh = SSH(hostname=machine.hostname, username=machine.username)
ca = ConnectionActive(connected='YES', ref_time_id=ref_time.id)
session.add(ca)
session.commit()
disk_usage = con_ssh.cmd_disk_usage()
for disk in disk_usage:
du = DiskUsage(filesystem=disk['filesystem'],
type=disk['type'],
size=disk['size'],
used=disk['used'],
mounted_on=disk['mounted_on'],
available=disk['available'],
use_percent=disk['use_percent'],
ref_time_id=ref_time.id)
session.add(du)
session.commit()
cpu_usage = con_ssh.cmd_cpu_usage()
for cpu in cpu_usage:
cpuu = CpuUsage(cpu=cpu['cpu'],
