BookmarkSubscribeRSS Feed
atul_desh
Quartz | Level 8

$file1 = Get-Content L:\servers.txt
$file2 = Get-Content L:\HofixID.txt

$objects = foreach($f1 in $file1)
{
foreach($f2 in $file2)
{
New-Object psobject -Property @{
Server = $f1
HotfixID = $f2
}
}
}

$objects |Export-Csv -Path "L:\output.csv" -NoTypeInformation

$CSV = import-csv “L:\output.csv” | select Server,HotfixID,@{n=’CommanName’;e={$_.Server + ” ” + $_.HotfixID}}

$CSV |Export-Csv "L:\outputfinal.csv" -NoTypeInformation

$PCSV =import-csv “L:\patch_ouput.csv” | select Server,HotfixID,@{n=’CommanName’;e={$_.Server + ” ” + $_.HotfixID}}

$PCSV |Export-Csv "L:\patch_outputfinal.csv" -NoTypeInformation

 

1 REPLY 1
ChrisHemedinger
Community Manager

Hi @atul_desh - do you have a question?  Looks like you're using PowerShell to assemble a list of hotfix info.  What do you need from the community?

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!