I see in the new version of K1000 that we upgraded to, we have a new series of entries for Mac computers indicating their FileVault encryption status.  This is a very interesting new feature.  I am very excited by it.

I see others have posted here previously about it prior to this addition, using a custom inventory record and querying the database to get that info.  With the newer out-of-the-box behavior, is there a way I can generate this report in SQL without implementing the CIR label->SQL report?
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

1
A new table called MACHINE_FILEVAULT_VOLUME was added to record the information.  This means you can join on that table and pull out the information you need.  Below is a basic query joining it to the machine table, you'll want to modify it to look at a few test machines to see the columns available and confirm the settings to what you expect.

Select MACHINE.NAME, MFV.*
FROM MACHINE
LEFT JOIN MACHINE_FILEVAULT_VOLUME MFV ON
MACHINE.ID = MFV.DEVICE_ID
Answered 11/04/2015 by: CraigT
Orange Belt

  • That last line should read:

    MACHINE.ID = MFV.ID
    • It did work for me in the end when I had time to check. Thanks for your help.
Please log in to comment
Answer this question or Comment on this question for clarity