Microsoft Office Forums

Go Back   Microsoft Office Forums > Windows and Other Software > Windows

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 09-04-2018, 06:20 AM
karpinsky karpinsky is offline Windows 10 Office 2016
Novice
 
Join Date: Mar 2018
Posts: 3
karpinsky is on a distinguished road
Default "Last modified by" column


Hello,
I am looking for the solution how can I quickly pick up in File Explorer which files were modified by a specific user. Is it possible at all in W10?
Reply With Quote
  #2  
Old 09-04-2018, 02:52 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 18,603
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

If, 'modified by a specific user' is equivalent to the file's 'owner' as recorded by the operating system, you could use something as simple as:
DIR C:\SomeFolder /Q > FileList.txt
from a command prompt, then open & sort the entries in FileList.txt (e.g. using Excel), where 'C:\SomeFolder' specifies both the drive and folder to process. Otherwise, you'll need a script that can interrogate each file's metadata. You could also add the /S switch to process sub-folders of the specified folder, as in:
DIR C:\SomeFolder /Q /S > FileList.txt
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 09-06-2018, 04:43 AM
karpinsky karpinsky is offline Windows 10 Office 2016
Novice
 
Join Date: Mar 2018
Posts: 3
karpinsky is on a distinguished road
Default

Ok, thanks for reply. Actually I expected to add field such as 'file owner' into File Explorer. I use One Drive as synchronised with File Explorer and many users modify files on-line, so it would be convenient for me to find in the easy way who modified the file as the last.

After unfolding the list of fields that I can add to sort files ("picking details", I note, that there is no field indicating who saved the file as the last. The only field akin to "last modified by" is "authors", but it returns only who created first version of the file.

I can look into One Drive located on web browser but it takes time. Is there any chance?
Reply With Quote
  #4  
Old 09-06-2018, 04:59 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 18,603
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

I doubt you'd get any more detail from One Drive. If you're on a network, though, the network software should include auditing tools that would return the lastmodified user details; indeed, the better ones can log every access & modification.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to format "I" column based on if "F" column row is not blank ravl13 Excel 3 08-22-2017 12:26 PM
Count # of times "text" is in 1 column is specific date is in the other column ann.acornacchio Excel 4 12-31-2016 05:40 PM
Need help with conditional formatting & returning "Pass" / "Fail Results" in a Column N mikey386 Excel 2 12-11-2014 01:14 PM
Custom column in "List" view, show on Contact Card phillyhy Outlook 0 05-16-2012 11:13 PM
How to choose a "List" for certain "Heading" from "Modify" tool? Jamal NUMAN Word 2 07-03-2011 03:11 AM


All times are GMT -7. The time now is 01:12 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft