RE: Search Results

[bazola]

Morning all,

I am working on a big project at work and I need to perform a search on the servers for PST Files on all drives.

I need to know Name, Location & Size and Date modified. I know I can use the inbuilt search but I need to be able to export the results to excel ideally so its easy to format.

I wrote a bat script initially to capture this info

@Echo on
echo....
c:
cd\
cls
dir /s *.PST >Cdrive.txt
d:
cd\
cls
dir /s *.PST >c:\Ddrive.txt
pause
exit

The problem is I dont get any formatting with this and I am unable to sort it by size etc.

Does anyone know of any free software that will help me perform this task.

Cheers

Baz

 

[bledd]

dir /?
Displays a list of files and subdirectories in a directory.

DIR [drive:][path][filename] [/A[[:]attributes]] [/B] [/C] [/D] [/L] [/N]
[/O[[:]sortorder]] [/P] [/Q] [/S] [/T[[:]timefield]] [/W] [/X] [/4]

[drive:][path][filename]
Specifies drive, directory, and/or files to list.

/A Displays files with specified attributes.
attributes D Directories R Read-only files
H Hidden files A Files ready for archiving
S System files - Prefix meaning not
/B Uses bare format (no heading information or summary).
/C Display the thousand separator in file sizes. This is the
default. Use /-C to disable display of separator.
/D Same as wide but files are list sorted by column.
/L Uses lowercase.
/N New long list format where filenames are on the far right.
/O List by files in sorted order.
sortorder N By name (alphabetic) S By size (smallest first)
E By extension (alphabetic) D By date/time (oldest first)
G Group directories first - Prefix to reverse order
/P Pauses after each screenful of information.
/Q Display the owner of the file.
/S Displays files in specified directory and all subdirectories.
/T Controls which time field displayed or used for sorting
timefield C Creation
A Last Access
W Last Written
/W Uses wide list format.
/X This displays the short names generated for non-8dot3 file
names. The format is that of /N with the short name inserted
before the long name. If no short name is present, blanks are
displayed in its place.
/4 Displays four-digit years

Switches may be preset in the DIRCMD environment variable. Override
preset switches by prefixing any switch with - (hyphen)--for example, /-W.



so use the /o switch