Save Search results to a file. 3

[Hellooooooooo]

Hello everyone.

I'm having a nightmare. I need to list all of the files saved on one of the 2k servers with a PST extension so that I can create a report. I've tried doing a DOS file listing and saving it to file, however if I save it in CSV format, the information as all over the place in Excel and will take hours to sort out for the report. Sort of cutting and pasting every file found, is there an easy way to do it. Why does Windows Search not let you save the results other than the search parameters.

Need to repeat this on 6 more servers to :-(

Cheers all.

Marty

 

[petrosky]

Hi Marty,

Here is a "dirty" way to find them.

If you drop to a command prompt.

dir c: /S /B > c:\dir.txt

Open dir.txt in excel and make sure all the files listed fall in column A.

In cell B1, =FIND(".pst",A1,1)

Copy down.

Sort on column B.

I'm sure there must be a better way...

Peter.

Remember- It's nice to be important,
but it's important to be nice

 

[LWComputingMVP]

Better way:

DIR /s /b x:\*.pst>PSTList.txt

Where x is the drive you want to list the PST files.

 

[petrosky]

Nice one lwcomputing.

Remember- It's nice to be important,
but it's important to be nice