help

lesliecalvo · 2021-12-21T15:03:44.000Z

help, i need to export this report to .CSV file

$UserCredential = Get-Credential

Install-Module -Name PSWindowsUpdate -Force
Get-Package -Name PSWindowsUpdate
Set-ExecutionPolicy -Scope Process -ExecutionPolicy Unrestricted -Force
Get-WindowsUpdate -MicrosoftUpdate -Verbose
Install-WindowsUpdate -MicrosoftUpdate -AcceptAll -AutoReboot
wmic qfe list

function Convert-WuaResultCodeToName
{
param( [Parameter(Mandatory=$true)]
[int] $ResultCode
)
$Result = $ResultCode
switch($ResultCode)
{
2
{
$Result = “Succeeded”
}
3
{
$Result = “Succeeded With Errors”
}
4
{
$Result = “Failed”
}
}
return $Result
}
function Get-WuaHistory
{

Get a WUA Session

$session = (New-Object -ComObject ‘Microsoft.Update.Session’)

Query the latest 1000 History starting with the first recordp

$history = $session.QueryHistory(“”,0,50) | ForEach-Object {
$Result = Convert-WuaResultCodeToName -ResultCode $_.ResultCode

Make the properties hidden in com properties visible.

$_ | Add-Member -MemberType NoteProperty -Value $Result -Name Result
$Product = $.Categories | Where-Object {$.Type -eq ‘Product’} | Select-Object -First 1 -ExpandProperty Name
$_ | Add-Member -MemberType NoteProperty -Value $.UpdateIdentity.UpdateId -Name UpdateId
$ | Add-Member -MemberType NoteProperty -Value $.UpdateIdentity.RevisionNumber -Name RevisionNumber
$ | Add-Member -MemberType NoteProperty -Value $Product -Name Product -PassThru
Write-Output $_
}
#Remove null records and only return the fields we want
$history |
Where-Object {![String]::IsNullOrWhiteSpace($_.title)} |
Select-Object Result, Date, Title, SupportUrl, Product, UpdateId, RevisionNumber
}

Get-WuaHistory | Format-Table

Export-Csv >Export-Csv “c:\users\lesliecalvo\Desktop\WindowsUpdate.csv” -NoTypeInformation

cmd /c pause

Rod-IT · 2021-12-21T15:08:10.000Z

Please past your PowerShell content using insert code option </> so it formats correctly.

And if you want help, please try a meaningful topic - ‘help’ is too generic.

lesliecalvo · 2021-12-21T15:15:01.000Z

sorry is I am frustrated no but yes ur correct. can u help me pls, i will like to export it to a .csv file

PatrickFarrell · 2021-12-21T15:17:12.000Z

You would want to pipe your variable out to Export-CSV.

For example, if your variable was $Result

Also there’s no need for the cmd /c pause. Just use the powershell pause command

$Result | Export-Csv "c:\users\lesliecalvo\Desktop\WindowsUpdate.csv" -NoTypeInformation

Pause

Neally · 2021-12-21T15:23:59.000Z

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don't say "Need help" or "PowerShell Help", actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy, past…

192033ab-bb8f-4032-88a5-8e2313af0344-codebutton_small.png

Neally Bot

Neally · 2021-12-21T15:26:18.000Z

“format-table” breaks an object, and ‘export-csv’ needs an object.

try to assign it to a variable

$history = Get-WuaHistory
$history | Format-Table

$history |
Export-Csv "c:\users\lesliecalvo\Desktop\WindowsUpdate.csv" -NoTypeInformation

lesliecalvo · 2021-12-21T15:27:18.000Z

it exported but the document is blank ?

Neally · 2021-12-21T15:28:46.000Z

lesliecalvo:

it exported but the document is blank ?

is there anything in ‘$history’ ?

you have to run the rest of your code, I just provided a snippet.

lesliecalvo · 2021-12-21T15:41:38.000Z

@alexw ty it actually works. any suggestion PowerShell code for the outbound updates or and </> if </> command for the failing ones?

Neally · 2021-12-21T15:43:25.000Z

yeah use an if/else or try/catch statement to see if it returned anything?

lesliecalvo · 2021-12-21T17:54:36.000Z

@alexw I am not really a Powershell person can you provide me an example

Neally · 2021-12-21T18:45:19.000Z

e.g.

$history = Get-WuaHistory
if($history){
$history | Format-Table

$history |
Export-Csv "c:\users\lesliecalvo\Desktop\WindowsUpdate.csv" -NoTypeInformation
}
else{
    write-output "No history returned"
}