Alex Loewenthal
01/11/2023, 7:19 PMSELECT EXISTS(SELECT * FROM system_info WHERE board_model not in ('VirtualBox', 'Parallels Virtual Platform') AND (select 1 from disk_encryption WHERE encrypted = '1' AND name like '/dev/dm-1')) as is_desktop_encrypted;
Jason
01/12/2023, 3:04 PMSELECT 1 WHERE
(SELECT protection_status from bitlocker_info) = 1
OR (SELECT chassis_types FROM chassis_info) NOT IN ("Notebook", "Laptop");
Alex Loewenthal
01/12/2023, 6:48 PM