Christopher Kodama
SELECT * FROM bitlocker_info JOIN logical_drives ON logical_drives.device_id = bitlocker_info.drive_letter WHERE logical_drives.description NOT LIKE 'Removable Disk';