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

Comments

Needs images and a sample report.

Author
rlagger
Last modified
Thursday, January 7, 2021 - 11:37
Properties
Supported Version
Report Category
Includes a Report Layout
No
Databases
Tags
Rating
  • 1
  • 2
  • 3
  • 4
  • 5
Total votes: 0
Downloads