I am trying to find a way to use Powershell to list just the timestamps of a directory listing. I am trying to find a way to populate a report where I need to list all the timestamps of SQL Server backup files stored in several directories. Currently I am manually updating my Excel sheet with each file's timestamp, but this is very tedious. I would love to be able to use Powershell to list all the SQL Server backup files and their timestamps and pipe them into a CSV format that I can use to update my formatted report.
Does anyone have any ideas?