This topic contains 3 replies, has 2 voices, and was last updated by
January 7, 2017 at 4:48 pm #61485ParticipantTopics: 3Replies: 4Points: 0Rank: Member
I am pretty new so please excuse the rather rudimentary question.
I am trying to write a script that will check my backups and report the time and status to me. I am currently hung up on trying to get the LastWriteTime into the output by assigning the date it pulls to a variable. Here is what I have in my mind so far that currently does not work:
$LogFile=C:\Users\john\iDrive\logs\account\IDL-01\\*.xml | Sort-Object | Select-Object -Last 1
$BackupLogDate=$LogFile | select LastWriteTime.ToString("yyyy-MM-dd HH:mm")
Write-Host "The backup on $BackupLogDate was $BackupStatus"
The error I keep getting is "Cannot run a document in the middle of a pipeline", which I am now realizing I do not understand pipelines well enough to diagnose the issue.
Any help would be greatly appreciated!
January 7, 2017 at 5:34 pm #61486ParticipantTopics: 4Replies: 104Points: 82Rank: Member
Use Get-ChildItem to enumerate the files in the path you specified
$LogFile = Get-ChildItem -Path 'C:\Users\john\iDrive\logs\account\IDL-01\*.xml' | Sort-Object -Property LastWriteTime | Select-Object -Last 1
Then use Select-Object with the ExpandProperty parameter to grab the value of the LastWriteTime property
$BackupLogDate = $LogFile | Select-Object -ExpandProperty LastWriteTime
You could also do it all in one line
$BackupLogDate = Get-ChildItem -Path 'C:\Users\john\iDrive\logs\account\IDL-01\*.xml'| Sort-Object -Property LastWriteTime | Select-Object -Last 1 -ExpandProperty LastWriteTime
January 7, 2017 at 6:23 pm #61489ParticipantTopics: 3Replies: 4Points: 0Rank: Member
Thanks so much for your help! That was exactly what I was looking for. I really appreciate the explanation as well as I am trying to teach myself powershell by making this script and its a bit trial by fire!
Again, I truly appreciate your effort and assistance!
January 8, 2017 at 10:18 am #61507ParticipantTopics: 4Replies: 104Points: 82Rank: Member
My pleasure 🙂
The topic ‘Creating LastWriteTime as a Variable’ is closed to new replies.