osQuery Management Server (Policy).Full disk encryption enabled (Windows) (SQLite SQL Statements)

SELECT 
  CASE 
    WHEN EXISTS (
      SELECT 1 
      FROM bitlocker_info 
      WHERE drive_letter = 'C:' AND protection_status = 1
    ) THEN 'true'
    ELSE 'false'
  END AS policy_result;