/build/static/layout/Breadcrumb_cap_w.png

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?

0 Comments   [ + ] Show comments

Answers (1)

Posted by: CraigT 8 years ago
Orange Belt
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

Comments:
  • That last line should read:

    MACHINE.ID = MFV.ID - dugullett 8 years ago
    • It did work for me in the end when I had time to check. Thanks for your help. - ajstein 8 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
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