SCCM Report to check BitLocker status

This report is useful for everyone that work with Bitlocker tool:

*****************************

SELECT
 v_R_System.Name0 AS Computername,
v_GS_BitLocker.ProtectionStatus0 AS [Bitlocker Status],
v_GS_BitLocker.DriveLetter0 AS DriveLabel

FROM         v_GS_BitLocker INNER JOIN
v_R_System ON v_GS_BitLocker.ResourceID = v_R_System.ResourceID

********************************