question

BoopathiSubramaniam-6294 avatar image
BoopathiSubramaniam-6294 asked ·

SCCM SQL Query to get bitlocker recovery password


Hi,

I am using the below query to get the recovery password.

select a.Id, a.Name, b.VolumeId, c.RecoveryKeyId, c.RecoveryKey, c.LastUpdateTime, c.Disclosed from RecoveryAndHardwareCore_Machines a
inner join RecoveryAndHardwareCore_Machines_Volumes b ON a.Id = b.MachineId
inner join RecoveryAndHardwareCore_Keys c ON b.VolumeId = c.VolumeId
where RecoveryKeyId LIKE '4DFDHHHH%'

But recovery password is more than 48 digit.
35111-capture.jpg



Please share the query to get bitlocker recovery password in actual format


mem-cm-general
capture.jpg (26.2 KiB)
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Jason-MSFT avatar image
Jason-MSFT answered ·

That's because it's encrypted in place. There is no (supported) direct query you can use for this.

Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

FionaYan-MSFT avatar image
FionaYan-MSFT answered ·

@BoopathiSubramaniam-6294

For our sercurity protection,we may not see our recovery key directly in our data base. If we install a SQL Server certificate, Configuration Manager encrypts your data in SQL.

If we really want to see our recovery key,maybe we could set up BitLocker portals through our sccm and configure our portal to let us have access to all recovery areas of the administration and monitoring website.
For more details,please see this article:
https://docs.microsoft.com/en-us/mem/configmgr/protect/deploy-use/bitlocker/setup-websites


If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


1 comment Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@BoopathiSubramaniam-6294

May we know the current status of the question? If there is any other assistance we can provide, please feel free to let us know, we will do our best to help you.

0 Votes 0 · ·