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

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

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