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?

It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.

sas-innovate-2024.png

 

Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.

 

Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer. 

 

Register now!

Discussion stats
  • 1 reply
  • 607 views
  • 0 likes
  • 2 in conversation