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]'))
Post date
Wednesday, February 13, 2019 - 13:46
Last modified
Thursday, January 7, 2021 - 11:37
Downloads
Attachment | Size |
---|---|
![]() | 2.4 KB |
Comments
rlagger
2019-02-13
13:47:45
currently unpublished as I need to get a sample report together
Needs images and a sample report.