Monday, 6 October 2014

SCCM Report to check BitLocker status

           , ,      4 comments   





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. Unknown23 September 2015 at 07:27

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

    ReplyDelete
  2. Unknown23 September 2015 at 07:32

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

    ReplyDelete
  3. G.28 September 2015 at 00:31

    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. Mike Finley5 August 2016 at 13:25

    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!