SELECT
cm.Name,
ck.RecoveryKeyId,
cv.VolumeGuid,
cvt.TypeName
AS 'Volume Type',
RecoveryAndHardwareCore.DecryptString(ck.RecoveryKey,
DEFAULT) AS RecoveryKey,
RecoveryAndHardwareCore.DecryptBinary(ck.RecoveryKeyPackage,
DEFAULT) AS BitLockerRecoveryKeyPackage,
ck.LastUpdateTime
FROM
RecoveryAndHardwareCore_Keys ck
INNER
JOIN RecoveryAndHardwareCore_Volumes cv on ck.VolumeID = cv.ID
LEFT
JOIN RecoveryAndHardwareCore_VolumeTypes cvt on cv.VolumeTypeId = cvt.Id
LEFT
JOIN RecoveryAndHardwareCore_Machines_Volumes cmv on cv.Id = cmv.VolumeId
LEFT
JOIN RecoveryAndHardwareCore_Machines cm on cmv.MachineId = cm.Id
