CODEWITHSUNDEEP
powershellcsvpowershell-2.0export-to-csvinvoke-command
Zabaa
Zabaa

Reputation: 329

Cannot convert result form Invoke-Command to csv type

I have a problem with converting results from Invoke-Command into csv type. Code below :

    $remoteResultEventLog += Invoke-Command -ScriptBlock {
Param ( [string]$EventLogName,
        [string]$EventLogEntryType,
        [DateTime]$EventLogAfter, 
        [DateTime]$EventLogBefore, 
        [string] $searchPattern, 
        [Boolean] $caseSensitive)

    $events = Get-EventLog -LogName $EventLogName -EntryType $EventLogEntryType -After $EventLogAfter -Before $EventLogBefore
    if ( $caseSensitive ) 
    { 
        $events | Select-Object Index, Time, EntryType, Source, InstanceID, Message, PSComputerName, @{Name='Search Pattern';Expression={$searchPattern}} `
        | Where-Object { Select-String -InputObject $_.message -Pattern $searchPattern -Quiet -CaseSensitive}
    }
    else 
    { 
        $events | Select-Object Index, Time, EntryType, Source, InstanceID, Message, PSComputerName, @{Name='Search Pattern';Expression={$searchPattern}} `
        | Where-Object { Select-String -InputObject $_.message -Pattern $searchPattern -Quiet }
    } 
    } -ArgumentList $EventLogName, $EventLogEntryType, $EventLogAfter, $EventLogBefore, $searchPattern, $caseSensitive -Session $serverSession

    $remoteResultEventLogCsv = $remoteResultEventLog | ConvertTo-Csv -NoTypeInformation -Delimiter ";"

The last line give this error :

ConvertTo-Csv : Cannot bind argument to parameter 'InputObject' because it is null.

At C:\Temp\RemoteCheckTest\new\RemoteCheckFiles.ps1:131 char:65

+ $remoteResultEventLogCsv = $remoteResultEventLog | ConvertTo-Csv <<<<  -NoTypeInformation -Delimiter ";"

    + CategoryInfo          : InvalidData: (:) [ConvertTo-Csv], ParameterBindingValidationException

    + FullyQualifiedErrorId : ParameterArgumentValidationErrorNullNotAllowed,Microsoft.PowerShell.Commands.ConvertToCsvCommand

But Input Object in that case $remoteResultEventLog is not a null I checked

Thanks for any answer

Upvotes: 0

Views: 1093

Answers (1)

David Brabant
David Brabant

Reputation: 43499

What's the content of $remoteResultEventLog? Maybe you could try to replace the last line in your script with:

$remoteResultEventLogCsv = $remoteResultEventLog | Where-Object {$_} | ConvertTo-Csv -NoTypeInformation -Delimiter ";"

Upvotes: 1

Related Questions