Automate Dataview for Bitlocker Details

[robot25]

Would love to have an Automate Dataview that can list the protected systems, volumes, keys, etc across all clients. Any chance that can be included in the next release or maybe include a sql view that can be used to easily create my own? I found a couple of tables (plugin_p4a_bitlocker_protectors and pluugin_p4a_bitlocker_volumes) but don't know enough about the columns to create my own joins and query in dataview creator. I am on hosted Automate.

[Cubert]

Are you aware of the volume and Key Export feature?

Have a look at this post for more information.

viewtopic.php?t=6514

Its not a dataview but it does export to CSV so you can then use external tools to play with data.

[robot25]

Yes I am, and I like that feature, however I'm interested in a dataview so that I can view the same data across all my clients in one table. Is the source of the key export feature a SQL view, or a query? Perhaps that logic can be used for a dataview that meets my need. I'm willing to take a stab at building my own dataview but do not know the underlying views, tables, relationships, and queries.

[PL-MSTech]

We are using the volume list to look at everything...the volume list shows that our drives are encrypted but it show the protection status as off. How do we turn the protection on?

[Cubert]

We saw that and have now created a maintaince task to manage these data issues.

Build 1.0.0.18 due out in the next 24 hours or so will resolve this issue for you.

It will require that the plugin completed a norman maintenance cycle. This is typically executed at 12 am.

So you will see changes 24 hours after plugin updates if the plugin auto update. Else if you manually update, the data should be fixed by 12:30 AM the following morning.

Then it will maintain the clean up of that data moving forward.

[robot25]

This post is going off track; hoping we can get back to the original topic.
I'm interested in an Automate dataview so that I can view the same data across all my clients in one table. I'm willing to take a stab at building my own dataview but do not know the underlying SQL views, tables, joins, and queries.
Maybe if there is a straightforward SQL View that is used to populate the per-company list I can expand that to display for all companies? Maybe P4A can develop an Automate data view? Just looking for some direction...

[Cubert]

I digress,

Maybe this is what your looking for?

Code: Select all

SELECT * FROM plugin_p4a_bitlocker_volumes A LEFT JOIN plugin_p4a_bitlocker_protectors B ON A.ComputerID = B.ComputerID and A.MountPoint = B.MountPoint;

Which should have an output like the following.

Screenshot 2025-02-03 092405.png (26.64 KiB) Viewed 2705 times