How to find the file encryption status using sql query ?
Hi System Admin10
I would suggest you check this article and see if you are able to fetch reports for file encryption status.
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 22.214.171.124.
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.