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

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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