none
Bitlocker Status Query on SCCM Database RRS feed

  • Question

  • Hi Team,

    I found a query which can be run on SCCM DB to find the bitlocker status.The query is  -

    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

    It gives me output like this -

    Name0        DriveLetter0    ProtectionStatus0
    Server A        V:                       0
    Server B        D:                       0
    Server C       W:                       0

    What does this means? Does this means that Bitlocker is enabled on V drive on Server A ??

    Thanks in advance.


    Thanks, S K Agrawal

    Monday, November 16, 2015 10:30 AM

Answers

All replies