→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
SimplyClueless
Engaged Sweeper III
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..
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
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

View solution in original post

1 REPLY 1
Daniel_B
Lansweeper Alumni
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