PowerShell - Get a list of VIPs and SSL profiles (client and server)
Problem this snippet solves: Having had numerous occasions where I needed to figure out where a particular SSL profile was assigned and seeing a few similar questions here on DC, I decided to make u...
Updated Jun 06, 2023
Version 2.0Michael_Jenkins
Cirrostratus
Joined May 21, 2019
Michael_Jenkins
Cirrostratus
Feb 16, 2016You could do a few different things:
1. Pipe the result to CSV/TAB and paste it into Excel. You can add the following line instead of the Format-Table one:
Add ' | ConvertTo-Csv -NoTypeInformation -Delimiter "`t" | clip.exe'. (clip.exe will copy the output to the clipboard)
2. Pipe the result to "Out-Gridview" to see all the data (I forget what version of PowerShell you need for Out-Gridview. I think it's 4 or 5).
3. Save the output to a csv file and then open the file. Something like : '| ConvertTo-Csv -NoTypeInformation | out-file "c:\temp\file.csv"; Invoke-Item "c:\temp\file.csv";'
Hope this helps. It's annoying that Format-Table cuts off data, but these are the ways I get around that. Personnally, I use Out-Gridview most of the time and then copy and paste from there (though it doesn't copy the column headers).
Help guide the future of your DevCentral Community!
What tools do you use to collaborate? (1min - anonymous)