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

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

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