Fleet’s built-in queries for collecting and storing important device information.
Apple
Linux
Windows
ChromeOS
MDM Disk encryption key file
Retrieves the encrypted FileVault recovery key for managed macOS devices.
WITH
de AS (SELECT IFNULL((SELECT 1 FROM disk_encryption WHERE user_uuid IS NOT "" AND filevault_status = 'on' LIMIT 1), 0) as encrypted),
fv AS (SELECT base64_encrypted as filevault_key FROM filevault_prk)
SELECT encrypted, filevault_key FROM de LEFT JOIN fv
This query uses the filevault_prk
data table. Learn more
Vitals