mecm 2002 bitlocker status sql database

Question

when trying to execute this query to find bitlocker status, it displayed query executed successfully but no results shown,
any ideas of what could be the issue?

SELECT dbo.v_R_System.Name0, dbo.v_GS_ENCRYPTABLE_VOLUME.DriveLetter0, dbo.v_GS_ENCRYPTABLE_VOLUME.ProtectionStatus0
FROM dbo.v_GS_ENCRYPTABLE_VOLUME INNER JOIN
dbo.v_R_System ON dbo.v_GS_ENCRYPTABLE_VOLUME.ResourceID = dbo.v_R_System.ResourceID

I also when trying to view the he BitLocker Enterprise Compliance Dashboard Reoport in configutation manager, it error out with

Answer 1

error

Answer 2

It looks like below known issue, try the workaround to see if it helps:
https://learn.microsoft.com/en-us/mem/configmgr/core/get-started/2019/technical-preview-1909#general-known-issues

Answer 3

after excusing the query I sill the same error