Hi,

I found the query below which can be used to report on bitlocker encryption.

I would like to add a column 'Operating System' so I can see Windows 7 or Windows 10.

Can anybody help with this?

1. select resource.name COMPUTER_NAME, LOGICAL_DRIVE, PROTECTION_STATUS , ENCRYPTION_STATUS, ENCRYPTION_METHOD, LOCK_STATUS from invcomputer inner join resource on invcomputer.computer_id=resource.resource_id inner join managedcomputer on resource.resource_id=managedcomputer.resource_id inner join invbitlockerstatus on invcomputer.computer_id=invbitlockerstatus.computer_id where managed_status=61