Query to check machines which are having 128 bit bitlocker algorithms


As we know , BitLocker uses Advanced Encryption Standard (AES) as its encryption algorithm with configurable key lengths of 128 or 256 bits

I want to create a collection which will show machines which are having 128 bit encryption algorithm, can you please help me with the query.

Thanks in advance.



solved 0
Ketan Kamble 11 months 2020-06-20T17:23:25+05:30 3 Answers 124 views Beginner 0

Answers ( 3 )


    I have not implemented MBAM integration but try to Google it you will find your answers.

    1.Have you enabled the Bitlocker inventory in Client Settings?
    2. Try for Below query, different encryption value will show different encryption result.

    select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_BITLOCKER_DETAILS on SMS_G_System_BITLOCKER_DETAILS.ResourceId = SMS_R_System.ResourceId where SMS_G_System_BITLOCKER_DETAILS.EncryptionMethod = 5

    3. Go through below technet article where many have faced same issue.


    4. There is an inbuilt report which will show the data you required but you need to change few values in report mentioned in above technet article.

    !!!NEW VALUE!!!

    =Switch(Fields!EncryptionMethod.Value=4294967294, “Unknown”, Fields!EncryptionMethod.Value=0, “None”, Fields!EncryptionMethod.Value=1, “128-Bit with Diffuser”, Fields!EncryptionMethod.Value=2, “256-Bit with Diffuser”, Fields!EncryptionMethod.Value=3, “128-Bit”, Fields!EncryptionMethod.Value=4, “256-Bit”, Fields!EncryptionMethod.Value=5, “Hardware”, Fields!EncryptionMethod.Value=6, “128-Bit XTS”, Fields!EncryptionMethod.Value=7, “256-Bit XTS”)

    Best answer


    Personally i am not looked into that MBAM views and tables in SCCM DB. Working on MBAM integration POC with SCCM 2002 version. Soon i will findout this information will be available on what tables and views in SCCM.



    Hello – I don’t have the exact query details but you might get the query if you try the following method yourself


Leave an answer

Sorry, you do not have a permission to answer to this question .