take a look of one of the best report scripts
https://www.frankysweb.de/neue-exchange-reporter-version-exchange-reporter-3-7/
if it is an adhoc job you can try it with vba https://docs.microsoft.com/en-us/office/vba/api/outlook.folders.add
TB-1159 found another cool solution
you can use ISE and debugg (F9) Mode - it's nice to see the output
$spalte = 0
$File = Get-Content C:\temp\node.txt
$excel = New-Object -ComObject Excel.Application
$workbook = $excel.workbooks.add()
$excel.visible = $true
ForEach($line in $File){
write-host $line -ForegroundColor Yellow
If($line -match "node"){ # new Column
$zeile=1
$spalte++
$excel.cells.item($zeile,$spalte) = $line
}
else{ # same column
$zeile++
$excel.cells.item($zeile,$spalte) = $line
}
}
exclude MSTransport ? Whats the difference to disable defender?
if I understand it correctly. Since all Exchange services are excluded, we can deactivate the virus scanner, since only Exchange is running on the server.