Hi,
I am facing issue appending the output to csv file as the second result is over writing the csv file.
please help.
$TotalCPU = 300
$UsedCPU = 200
$cpu = $TotalCPU - $UsedCPU
if (($cpu) -le 0) {
"vCPU Validation Failed"
return
}
else {
"vCPU Validation Success"
$resultsarray = @()
# Create a new custom object to hold our result.
$contactObject = new-object PSObject
# Add our data to $contactObject as attributes using the add-member commandlet
$contactObject | add-member -membertype NoteProperty -name "CPU" -Value $cpu
# Save the current $contactObject by appending it to $resultsArray ( += means append a new element to ‘me’)
$resultsarray += $contactObject
$resultsarray | Export-csv D:\cpu_mem.csv -NoTypeInformation -Append
}
$Totalmem = 250
$Usedmem = 100
$mem = $Totalmem - $Usedmem
if (($mem) -le 0) {
"Memory Validation Failed"
return
}
else {
"Memory Validation Success"
$resultsarray = @()
# Create a new custom object to hold our result.
$contactObject = new-object PSObject
# Add our data to $contactObject as attributes using the add-member commandlet
$contactObject | add-member -membertype NoteProperty -name "Memory" -Value $mem
# Save the current $contactObject by appending it to $resultsArray ( += means append a new element to ‘me’)
$resultsarray += $contactObject
$resultsarray | Export-csv D:\cpu_mem.csv -NoTypeInformation -Append
}
Error
Export-csv : Cannot append CSV content to the following file: D:\cpu_mem.csv. The appended object does not have a
property that corresponds to the following column: CPU. To continue with mismatched properties, add the -Force
parameter, and then retry the command.
At D:\check_host_mem_datastore_freespace.ps1:127 char:18
+ $resultsarray1 | Export-csv D:\cpu_mem.csv -NoTypeInformation -Append
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidData: (CPU:String) [Export-Csv], InvalidOperationException
+ FullyQualifiedErrorId : CannotAppendCsvWithMismatchedPropertyNames,Microsoft.PowerShell.Commands.ExportCsvComman
d
