есть код, import pypyodbc
import psutil
import json
import datetime
import socket
conn = pypyodbc.Connection(
"Driver={SQL Server Native Client 11.0};"
"Server=ADMIN-PC;"
"Database=perfmon;"
"Trusted_Connection=yes;UID=sa;PWD=Qwerty1!"
)
cursor = conn.cursor()
now =
datetime.datetime.now()
now = str(now.strftime("%Y-%d-%m %H:%M:%S"))
host_name = socket.gethostname()
for proc in psutil.process_iter(['pid', 'name', 'username', 'memory_percent']):
#print(
proc.info)
A = (
proc.info)
A['time'] = now
A['host_name'] = host_name
A = json.dumps(A)
print("EXEC InsertData '" + A + "'")
cursor.execute("EXEC InsertData '" + A + "'")
cursor.commit()
cursor.close()