extract filename and data from file

Question

I have hourly log files from the past couple of months and i would like to export the data to MS Charts.

I've managed to get the data out, but having problems with getting the date on the x axis of the Chart.

The file name of the log file contains the date and i've tried using the creatation date or last write time. The closest i've got is to count the number of logs then divide by 24, but the dates it generates does not match up with the data.

Any ideas please?

Everything works as expected, but i cant get the X Axis to display the correct dates. in theory, it should calculate the 11 June as the start date, and the end date is yesterday's date. the format of the file it reads from is HealthCheck Wed 10 Sep 2014 - 05.00 AM.log

Ideally, I would like to get the date from the file name. I dont want to rely on calculations on when the file was written as this is prone to errors.

[void][Reflection.Assembly]::LoadWithPartialName("System.Windows.Forms")
[void][System.Reflection.Assembly]::LoadWithPartialName("System.Windows.Forms.DataVisualization")
$Farm = "XAccess"

#gets files from yesterday
$Date = Get-Date #-Uformat %x
$Date = ($Date).adddays(-1)
$Date = $Date.ToString("M/d/yyyy")
$files = get-childitem "c:\$Farm*.log" | Where{$_.LastWriteTime -lt $date}

$ActiveSessions = Select-String -path $files '(?<=^"*Total Active Sessions: )\d+(?=)'|

 ForEach-Object {$_.Matches[0].Value}


#Calculates numbers of days 
$datapoints = $ActiveSessions.count/24

#== Creates Chart ==#

# create chart object 
$Chart = New-object System.Windows.Forms.DataVisualization.Charting.Chart 
$Chart.Width = 1600
$Chart.Height = 800

# create a chartarea to draw on and add to chart 
$ChartArea = New-Object System.Windows.Forms.DataVisualization.Charting.ChartArea 
$Chart.ChartAreas.Add($ChartArea) 
[void]$Chart.Series.Add("Data")
$Chart.ChartAreas["ChartArea1"].AxisX.Interval = 24
$Chart.ChartAreas["ChartArea1"].AxisX.LabelStyle.Angle = -40
$Chart.ChartAreas["ChartArea1"].AxisY.Interval = 5
$Chart.ChartAreas["ChartArea1"].AxisY.title = "Active Sessions"
$chart.Series.Add('ChartArea1')

# add a data point for each server 

foreach ($session in $ActiveSessions) 
{ 
$dp1 = new-object System.Windows.Forms.DataVisualization.Charting.DataPoint(0, $session) 
$dp1.AxisLabel = (get-date).adddays(-"$datapoints").tostring("ddd dd MMM")
$datapoints = $datapoints - 0.0416666666666667 
$Chart.Series["Data"].Points.Add($dp1)
} 


# set the title to the date and time 
$title = new-object System.Windows.Forms.DataVisualization.Charting.Title 
$Chart.Titles.Add( $title )
$Chart.Titles[0].Font = "Arial,13pt" 
$Chart.Titles[0].Text = "Year to Date sessions for $Farm" 

# save the chart to a file 
$Chart.SaveImage("C:\$Farm Farm.png","png")

Answer 1

I tried using regex but could not get pass the error i mentioned.

so after a bit more research, i decided exporting the creation date of the file and the data i needed into a CSV file, then creating the chart from that. So this is the code i used to get the data in to csv:

$files = get-childitem "c:\$farm*.log" | sort CreationTime    
Foreach ($file in $files)
{
    $FileCreation = $file.CreationTime.Date.ToString('ddd dd MMM yyyy')
    $ActiveSessions = Select-String -path $file '(?<=^"*Total Active Sessions: )\d+(?=)' | ForEach-Object {$_.Matches[0].Value}
   Add-Content d:\licInUse.csv "$FileCreation,$ActiveSessions"
}
    # processing the Data
    $Processes = Import-Csv -path d:\licInUse.csv -Delimiter ',' -Header "Date","Count"
    $DateNames = @(foreach($Date in $Processes){$Date.Date}) 
    $SessionCount = @(foreach($Date in $Processes){$Date.Count})

then used the following to plot the data

$Chart.Series["Data"].Points.DataBindXY($DateNames, $SessionCount)