import subprocess
import pyodbc
import os

try:
    conn = pyodbc.connect(r'DRIVER={ODBC Driver 13 for SQL Server};SERVER=servernamehere;DATABASE=dbnamehere;Trusted_Connection=yes;')
    cur = conn.cursor()
except pyodbc.Error as err:
    print(f"Error: {err}")
    quit()

computer_name = os.environ['COMPUTERNAME']

p = subprocess.Popen("manage-bde -status", stdout=subprocess.PIPE, shell=True)
(output, err) = p.communicate()
p_status = p.wait()
print(output)
f = open(r"c:\bitstatus.txt", "w")
f.write(computer_name+"\n")
f.write(str(output))
f.close
try:
    cur.execute("INSERT INTO BitLocker_ScanLog_D (ComputerName, Result) VALUES (?, ?)", (computer_name, output))
    conn.commit()
except Exception as e:
    print(f"SQL insert error: {e}")