Find files without owners in eDirectory

Details

This code finds files within a scan target where the owner is either NULL, [Nobody], [Supervisor], or [UNKNOWN] instead of an FDN in eDirectory.

Code

 SELECT
    sd.identity_system,
    sd.scan_target,
    sd.fullpath,
    sd.size AS size,
    srs.byte_string(sd.size) AS size_string,
    sd.create_time,
    sd.modify_time,
    sd.access_time,
    sd.owner_display_name
FROM
    srs.current_fs_scandata_edir AS sd
WHERE
    (sd.scan_target LIKE ('\\SERVER\VOLUMENAME') Escape '#') AND
    (sd.owner_display_name IN (NULL, '[Nobody]', '[Supervisor]', '[Unknown]'))

Author

rlagger

Post date

Wednesday, February 13, 2019 - 13:46

Last modified

Friday, April 26, 2024 - 12:48

Properties

Supported Version

3.6

Report Category

File System

Includes a Report Layout