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
Feb 16, 2016Cirrostratus
You 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).