How can I run a report to show what machines are encrypted or not?

Question

Is there a report or a way to run a report to show what machines are encrypted in my network or not? I have Sophos Enterprise Console.

FormerMember · Answer

Hi Brian, 
 
If you're using SafeGuard 5.61 from the Sophos Enterprise Console (SEC) this won't be possible that I'm aware of. 
 
However, if you're using the full version of SafeGuard from the SafeGuard Management Centre (SGN) then this will show a list of all encrypted Clients and the last time that a policy was received. 
This assumes your database is called SafeGuard, please amend as necessary: 
 
use SafeGuard 
SELECT 
SAFE_GUARD_DIR.SGD_name as 'Machine name', 
IVT_MACHINES.IMA_ENCRYPTED_DRIVES as 'Drive encrypted', 
IVT_MACHINES.IMA_UNENCRYPTED_DRIVES as 'Drive not encrypted', 
IVT_MACHINES.IMA_LAST_POLICY_RECEIVED as 'Last policy received on' 
FROM IVT_MACHINES INNER JOIN 
SAFE_GUARD_DIR ON IVT_MACHINES.IMA_MACHINE_ID = SAFE_GUARD_DIR.SGD_ID 
WHERE (IVT_MACHINES.IMA_ENCRYPTED_DRIVES IS NOT NULL) 
 
If you do need any further SQL queries for SafeGuard they can be found here. 
 www.sophos.com/.../109925.aspx