/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


Writing Custom SQL Reports in 6.4 to Report the FileVault

11/04/2015 1517 views
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


All 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.
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ