Title
#sql
j

Julian Scala

10/15/2020, 8:29 PM
Any example of a query to get the filevault service status on MacOS?
harroldhino

harroldhino

10/15/2020, 10:27 PM
SELECT d.encrypted FROM mounts m JOIN disk_encryption d ON m.device_alias = d.name WHERE m.path = '/';
10:27 PM
Does that work?
j

Julian Scala

10/15/2020, 10:28 PM
Yah, thats what I am using, just facing a weird scenario where unencrypted Macs show as encrypted on that query :this_is_fine:
10:28 PM
There is a follow up on this in the #macos channel
10:28 PM
Thanks though!
harroldhino

harroldhino

10/15/2020, 10:31 PM
Gotcha! To be honest, I was just excited to come across a question that I might be able to answer. I’m in disbelief that I was (partially) correct.
j

Julian Scala

10/15/2020, 10:31 PM
Hahah! No worries at all, the intention is what counts. So appreciate your help!
10:32 PM
I also thought the query I built was a disaster, thats why I throw the question here. You got it right and if in the future someone looks for a Filevault query, this will come up!
harroldhino

harroldhino

10/16/2020, 12:31 AM
brb, telling my entire company