Hi,
How to find the file encryption status using sql query ?
This thread was automatically locked due to age.
Hi,
How to find the file encryption status using sql query ?
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
