Query to resolve file owner to AD Display name
Submitted by michael.persinger on Thu, 07/02/2015 - 10:23
I'm able to generate a report that lists a file's owner to their account name, but managment would like the report to show the actual name of the employee as that's more meaningful for them.
Right now I'm pulling this information in my query:
SELECT srs.current_fs_scandata.fullpath, srs.current_fs_scandata.filename_extension, srs.current_fs_scandata.size, srs.current_fs_scandata.owner_name, srs.current_fs_scandata.modify_time, srs.current_fs_scandata.access_time
FROM srs.current_fs_scandata
I see that there is an SRS.AD_ACCOUNT_NAME, but I'm not sure how to make that work for me in this instance. Any help would be great.
rlagger
2015-07-08
09:26:33
A feature request has been added to address the need
We have had several requests, for extending the data collected about a directory service object. For instance in your case collecting given name (first name), surname (last name), display name (full name), etc. Others want to collect the description attribute on groups.
michael.persinger
2015-07-10
14:47:45
Thanks---sounds good.
Thanks---sounds good.
micky.rathod@mi...
2018-10-24
21:50:55
Any update on the query? /feature?
Any update on the query? /feature?
rlagger
2018-11-01
08:25:44
This is still an outstanding feature request.
no update yet, but I will add another vote to the feature request.