Thread Info
  • State Suggested Answer
  • Locked Locked
  • Replies 4 replies
  • Answers 1 answer
  • Subscribers 8 subscribers
  • Views 18799 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.
  • 0
    Hi BrianDowns.
    Unfortunately Sophos does not supply SQL queries for the information you require. The SEC management console does not provide that kind of report either.
    AnubisG

    Anubis

    Community Support Engineer | Sophos Support

    Sophos Support Videos | Knowledge Base | Documentation | @SophosSupport | Sign up for SMS Alerts |

    If a post solves your question use the 'This helped me' link

  • 0
    Actually, there is a way to run an inventory report. It's just not in the reporting section of the Safeguard console.

    1) Go to the root

    2) Select the Inventory Tab on the center/right portion of the console

    3) Select just one machine in the inventory

    4) Select Print Preview

    5) Play with your page setup for best results - landscape is probably best

    6) Pull down the File menu.

    7) At this point, you can either print directly to paper, or export to PDF or about 7 other formats.

    Boom! I think this is what most people are looking for. It's just not in the "Reports" section of the console.

    Adam in DC

    Adam in DC

  • 0
    I run this query to show if Device Encryption is present:

    SELECT
    SAFE_GUARD_DIR.SGD_name as 'Machine name',
    IVT_INST_FEATURES.IIF_FEATURE as 'Feature Installed',
    convert (VARCHAR,IVT_INST_FEATURES.IIF_MODIFY_DATE,3) as 'Last modified'
    FROM IVT_INST_FEATURES INNER JOIN
    SAFE_GUARD_DIR ON IVT_INST_FEATURES.IIF_MACHINE_ID = SAFE_GUARD_DIR.SGD_ID where IVT_INST_FEATURES.IIF_FEATURE like 'Device%'
    order by IVT_INST_FEATURES.IIF_MODIFY_DATE

    Then cross reference the results using Vlookup/excel
  • 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
Unfiltered HTML