$cmd.commandtext = "INSERT INTO dbo.db_sizes (Server, DatabaseName, DataFileName, DataSize, DataUsedSpace) VALUES('{0}','{1}','{2}','{3}', '{4})" -f
$dbname, $mdfInfo.Name, $mdfInfo.FileName, ($mdfInfo.size / 1000), ($mdfInfo.UsedSpace / 1000)
Try {
                    
      $cmd.executenonquery()
      }
catch {
                    
                    
}

[HashTable]$SprocParams =  @{}
foreach ( $c in $RecordFields ) {
	$SprocParams.Add($c.Name , [string]$CurrentRow.$($c.Name) )
	}
$rc = Invoke-StoredProcedure -connection "Server=$TargetSQLServer;Database=$SQLDb;Trusted_Connection=True;Connect Timeout=5;Application Name=$Global:ApplicationName;Workstation Id=$env:COMPUTERNAME;" -timeout 5 -storedProcName 'myschema.mysproc' -parameters $SprocParams 

     Jul 13  

Sometimes this is me

catch {
  write-host 'Catch block' -BackgroundColor Yellow -ForegroundColor Black 
  Write-Host $_.Exception.message -BackgroundColor Red -ForegroundColor Black 
  }

     Jul 13  

Sometimes this is me

$cmd.commandtext = $("INSERT INTO dbo.db_sizes (Server, DatabaseName, DataFileName, DataSize, DataUsedSpace) 
VALUES('{0}','{1}','{2}','{3}', '{4})" 
-f $dbname, $mdfInfo.Name, $mdfInfo.FileName, ($mdfInfo.size / 1000), ($mdfInfo.UsedSpace / 1000)
 )

     Jul 13  

Sometimes this is me

                    catch [System.Exception] {
                        Write-Host $_.Exception.Message
                    }

    foreach ($db in $dbs) 
        {
          
          $dbname = $db.Name
          $fileGroups = $db.FileGroups
            
          ForEach ($fg in $fileGroups)
            {
            If ($fg) 
                {
                    $mdfInfo = $fg.Files | Select Name, FileName, size, UsedSpace
                    $logInfo = $db.LogFiles | Select Name, FileName, Size, UsedSpace
                    $date = get-date
                    $cmd.commandtext = "INSERT INTO dbo.db_sizes (Server, DatabaseName, DataFileName, DataSize, DataUsedSpace, LogName, LogFileName, LogSize, LogUsedSpace, SDate) VALUES('{0}','{1}','{2}','{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}')" -f
                            $instance, $mdfInfo.Name, $mdfInfo.FileName, ($mdfInfo.size / 1000), ($mdfInfo.UsedSpace / 1000), $logInfo.Name, $logInfo.FileName, ($logInfo.size / 1000), ($logInfo.UsedSpace / 1000), $date
                    Try {
                    
                        $cmd.executenonquery()
                    }
                    catch [System.Exception] {
                        Write-Host $_.Exception.Message
                    }
                }
            }
        }

 $date = get-date -format 'yyyy-MM-dd HH:mm.ss.fff'

     Jul 13  

Sometimes this is me