Bitlocker report

[SimplyClueless]

Sorry if this has already been covered- but any suggestions on creating a report in lansweeper that shows me all the machines that do not have bitlocker enabled?

I guess I mean all the laptops; machines with a TPM chip- they are named in the convention "lt-win7-xxx"

I think there is a field in lansweeper to see if there in an encrypted drive somewhere..

[Daniel_B · Accepted solution]

The following report (similar to the built-in report "Computer: Encryptable Volumes") lists laptops not having Bitlocker enabled:

Select Top 1000000 tsysAssetTypes.AssetTypeIcon16 As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblEncryptableVolume.DriveLetter,
  Case When tblEncryptableVolume.ProtectionStatus = 0 Then 'OFF'
    When tblEncryptableVolume.ProtectionStatus = 1 Then 'ON' Else 'UNKNOWN'
  End As ProtectionStatus,
  tblEncryptableVolume.LastChanged
From tblEncryptableVolume
  Inner Join tblAssets On tblEncryptableVolume.AssetId = tblAssets.AssetID
  Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
  Inner Join tblPortableBattery
    On tblAssets.AssetID = tblPortableBattery.AssetID
Where tblEncryptableVolume.ProtectionStatus = 0