Command prompt DIR - get specific fields of information (SharePoint 2007 site)

I have a SharePoint 2007 site we are migrating and I am trying to extract all folders and files within a map network drive for the site using the command prompt and export a text file.

The fields I want to display are the full field path, the last modified date of the file, and the content owner.

Preferably separated by a comma or other character to parse after export.

Any suggestions?

Regards,

Adam
aehrenwoTechnology AnalystAsked:
Who is Participating?
 
NVITCommented:
Make a FileInfo.bat file of this, which  returns a listing in the format:
c:\local\acadfuns.lsp,02/24/2016,domain\user1
c:\local\testfile.txt,03/23/2016,domain\user2

Open in new window


Adjust the set dirroot= line to your needs.  i used c:\local. If you want to do the whole c:\, use c:\.

@echo off
setlocal enabledelayedexpansion

set dirroot=c:\local

FOR /r "%dirroot%" %%A in (*) DO (
  for /f "tokens=1,5" %%a in ('dir /tw /q "%%A"^|find "/"') do (set sOwner=%%b& set sModified=%%a)
  echo %%~fA,!sModified!,!sOwner!
)

Open in new window


Open a CMD window.

To see the results:
FileInfo.bat

Open in new window


To send the results to a CSV file results.csv:
FileInfo.bat>results.csv

Open in new window

0
 
JohnBusiness Consultant (Owner)Commented:
Open cmd.exe and type DIR /?

Full path, last modified date, owner and more are all available.

DIR *.* > File.txt puts the output in a file for you.
0
 
aehrenwoTechnology AnalystAuthor Commented:
What if you want all subfolders and their content as well (including the path?) is it just adding /s?
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
JohnBusiness Consultant (Owner)Commented:
If that is all you wanted, just add /s

But you can add other parameters to get more information in the same pass for a file.

Run a few tests interactively (not to a file) to see how it works.
0
 
aehrenwoTechnology AnalystAuthor Commented:
The only issue with this method is it shows the path and then all of the files within. is there  a way to display the path on the same line as the actual files themselves?

01/01/2016 X:\systems\samplefile.doc  <Owner>

versus

x:\systems\

01/01/2016 12:15 AM <DIR> 1,000  samplefile.doc
0
 
JohnBusiness Consultant (Owner)Commented:
Yes.   DIR /s /b  Then everything is on one line. Works fine.
0
 
NVITCommented:
Question answered by NVIT ID: 41785513
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.