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

Sophos Safeguard Management Centre ver 8.30.0.78

System Admin10 over 3 years ago

Hi,

How to find the file encryption status using sql query ?

This thread was automatically locked due to age.

0 Shweta over 3 years ago

Hi System Admin10

I would suggest you check this article and see if you are able to fetch reports for file encryption status.

use SafeGuard

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 'File%'

order by SAFE_GUARD_DIR.SGD_name

Shweta

Community Support Engineer | Sophos Technical Support
Are you a Sophos Partner? | Product Documentation | @SophosSupport | Sign up for SMS Alerts
If a post solves your question use the 'Verify Answer' link.

The New Home of Sophos Support Videos! - Visit Sophos Techvids
Cancel
Vote Up 0 Vote Down

Cancel
0 System Admin10 over 3 years ago in reply to Shweta

Thank you for your response.

I have checked the query & it is not showing any results.

I am using Management Centre Ver 8.30.0.78.
Cancel
Vote Up 0 Vote Down

Cancel
0 MichaelMcLannahan over 3 years ago in reply to System Admin10

Does it connect to the database but then provide no results - or not connect? Do make sure your database name marries up with the example shown. I'll try this query on mine too later if I get a sec
Cancel
Vote Up 0 Vote Down

Cancel
0 System Admin10 over 3 years ago in reply to MichaelMcLannahan

Yes, I am checking in the database only.

I can execute other queries successfully.
Cancel
Vote Up 0 Vote Down

Cancel