Summary

Find files in an eDirectory scan target where the owner cannot be resolved to a Fully Distinguished Name — owner is NULL, [Nobody], [Supervisor], or [Unknown].

Details

When the eDirectory scan encounters a file whose owner reference is missing, deleted, or system-assigned, it records one of four sentinel values instead of an FDN: NULL (no owner stored), [Nobody] (system placeholder), [Supervisor] (assigned to the supervisor account), or [Unknown] (owner reference exists but cannot be resolved).

This query lists every file in a scan target whose owner_display_name matches any of those sentinels. Update the scan_target value in the WHERE clause to match your environment.

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]'))