Try this SQL Query
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