Thread Info
  • State Suggested Answer
  • Locked Locked
  • Replies 4 replies
  • Answers 1 answer
  • Subscribers 8 subscribers
  • Views 18802 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
  • 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
Reply
  • 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
Children
No Data
Unfiltered HTML