Advertisement

06.10.2008 at 10:49AM PDT, ID: 23473252
[x]
Attachment Details

Need eloquent PowerShell script to get oldest file in a directory

Asked by DaleHarris in MSH/Monad PowerShell

Tags: Powershell, 2.0 CTP V2

I'm creating a script to do the following:
Go into the default log file location for Exchange 2003
Get the list of files held inside
If it's E00*.log, I care about it.
If it's res1.log or res2.log or E00tmp.log, then I don't want it.
It grabs the oldest out of the pile of the E00's and grabs the current date.
If the current file is dated before today, then send me an email saying "Your Log files are old".
If it's not, send me an email saying "Your log files are currently within the nominal time frame".
Also it does a count of the entire directory.


So now that you've gotten the background, all I need help with is the code where it's supposed to get that actual one file into usable format.

I can do something like the code listed below

But the problem is it keeps giving me horrible output.  I can get it to sort and format-table no problem.  I just feel like I'm missing the big picture here.  It should be "If it's not this or this, grab the date, stuff it into the variable"

That's all I need.  Anyone think they can help me out?

Also, may I saStart Free Trial
1:
2:
3:
$directory = C:\Scripts\*.log
$oldestfile = dir $directory | sort -property lastwritetime | select -first 3
"$oldestfile"
 
Loading Advertisement...
 
[+][-]06.10.2008 at 10:56AM PDT, ID: 21753405

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.10.2008 at 11:06AM PDT, ID: 21753499

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.10.2008 at 11:08AM PDT, ID: 21753520

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: MSH/Monad PowerShell
Tags: Powershell, 2.0 CTP V2
Sign Up Now!
Solution Provided By: BSonPosh
Participating Experts: 2
Solution Grade: A
 
 
[+][-]06.10.2008 at 12:11PM PDT, ID: 21754102

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.10.2008 at 12:24PM PDT, ID: 21754208

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.10.2008 at 12:40PM PDT, ID: 21754367

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.10.2008 at 12:42PM PDT, ID: 21754383

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.10.2008 at 12:57PM PDT, ID: 21754514

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.10.2008 at 01:11PM PDT, ID: 21754639

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.10.2008 at 01:16PM PDT, ID: 21754679

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.11.2008 at 10:38AM PDT, ID: 21762324

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628