Monday 6 October 2014

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

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

4 comments:

  1. I tried this and I got a syntax error when saving it. Can you please help me with this?

    ReplyDelete
  2. I tried this and I got a syntax error when saving it. Can you please help me with this?

    ReplyDelete
  3. Hello Frederick,

    I've just ran the report and works fine in my SCCM 2007:

    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

    regards.

    ReplyDelete
  4. To get it to work I had to get rid of the "AS" sections:

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

    ReplyDelete

Give me you feedback!