Solved

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

Posted on 2016-09-05
7
24 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 94

Expert Comment

by:John Hurst
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 94

Expert Comment

by:John Hurst
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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

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 94

Expert Comment

by:John Hurst
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
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…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

749 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