Solved

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

Posted on 2016-09-05
7
29 Views
Last Modified: 2016-09-24
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
0
Comment
Question by:aehrenwo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 96

Expert Comment

by:Experienced Member
ID: 41785442
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
 

Author Comment

by:aehrenwo
ID: 41785445
What if you want all subfolders and their content as well (including the path?) is it just adding /s?
0
 
LVL 96

Expert Comment

by:Experienced Member
ID: 41785450
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
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 

Author Comment

by:aehrenwo
ID: 41785462
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
 
LVL 96

Expert Comment

by:Experienced Member
ID: 41785463
Yes.   DIR /s /b  Then everything is on one line. Works fine.
0
 
LVL 24

Accepted Solution

by:
NVIT earned 500 total points (awarded by participants)
ID: 41785513
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
 
LVL 24

Expert Comment

by:NVIT
ID: 41813593
Question answered by NVIT ID: 41785513
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question