Powershell 学习笔记【持续更新】

# Get the current script execution path so our CSV file gets saved back there
[string]$curloc = get-location
out-file -filepath "$curloc\WADBs.csv"

# Create the empty CSV array
$arrCSV = @()

 # Create the empty record object and start populating it with information
       $objDB = "" | select DBName,DBStatus,WebApplication
       $objDB.DBName = $database.name
       $objDB.DBStatus = $database.status
       $objDB.WebApplication = $webapp.URL

# Add the new record as a new node in the CSV array
  $arrCSV += $objDB 

 # Now that we’ve added all of the records to the array we need to write the CSV array out to the file system
    $arrCSV | Export-Csv "$curloc\WADBs.csv" -NoTypeInformation