asked on
PowerShell Output to CSV by Date and Rename
I have a powershell script that gets Exchange calendar permissions and saves it to csv. I'm working on creating an automated report that will email the changes in permissions on a daily basis. One of the components I need assistance with is having the output saved to include the date in the file name in the form of YYYYMMDDcalpermissions.csv
Presently the script saves it as a static name, but when I run an automated daily comparison, I need a way to differentiate between yesterday's export and today.
How do I change the output to be named on variable based on the computer's date?
$Output | Sort-Object Mailbox | Select-Object Mailbox, User, {$_.AccessRights}, IsValid | Export-Csv -Path C:\CalendarPermissions.csv
Thank you.
Presently the script saves it as a static name, but when I run an automated daily comparison, I need a way to differentiate between yesterday's export and today.
How do I change the output to be named on variable based on the computer's date?
$Output | Sort-Object Mailbox | Select-Object Mailbox, User, {$_.AccessRights}, IsValid | Export-Csv -Path C:\CalendarPermissions.csv
Thank you.
Powershell
Last Comment
footech
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Looks like Subsun beat me to it... :)
Open in new window
then substitute the variable for the path parameterOpen in new window