Sophos Safeguard Management Centre ver 8.30.0.78

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

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.

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

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

Yes, I am checking in the database only.

I can execute other queries successfully.