Writing Custom SQL Reports in 6.4 to Report the FileVault
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?
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
Answers (1)
Please log in to answer
Posted by:
CraigT
9 years ago
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
