DBBakCSVLocations.ps1

$BackupFilesLocation = '\\MyfileServer\MyBackupsFolder'

$DBPATHS = Get-ChildItem -Recurse $BackupFilesLocation
#$DBPATH.FullName
$OutputArray =@()

foreach ($DBPATH in $DBPATHS){
    $namesnstuff = New-Object psobject -Property @{
    BaseName = $DBPATH.BaseName -replace "_backup.*"
    FullName = $DBPATH.FullName
    }
       $OutputArray += $namesnstuff
        }
        $OutputArray | Export-Csv "$BackupFilesLocation\FileList.csv" -NoTypeInformation
    
<#
Below is the formula to use in excel.

="RESTORE DATABASE " & B2 & " FROM DISK = '" & A2 & "' WITH MOVE 'mscrm' TO 'E:\MSSQL10_50.SOL\MSSQL\DATA\"&B2&".MDF', MOVE 'mscrm_log' TO 'E:\MSSQL10_50.SOL\MSSQL\DATA\"&B2&".LDF'"

#>