Thread Info
  • State Suggested Answer
  • Locked Locked
  • Replies 4 replies
  • Answers 1 answer
  • Subscribers 8 subscribers
  • Views 18804 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

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

BrianDowns

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. 



This thread was automatically locked due to age.
Parents
  • FormerMember
    0 FormerMember
    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
Reply
  • FormerMember
    0 FormerMember
    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
Children
No Data
Unfiltered HTML