Powershell output formatting issue

Question

So I'm working on an inventory script for our servers and have hit a roadblock at the storage. Here's the code:

$StorageInfo=Get-WmiObject win32_volume | Where-Object {$_.DriveType -eq 3 -and $_.Label -ne 'System Reserved' -and $_.DriveLetter -ne $null}

$DriveLetters=$StorageInfo | Select-Object DriveLetter | Sort-Object DriveLetter | ft -HideTableHeaders
$DriveNames=$StorageInfo | Sort-Object DriveLetter | Select-Object Label | ft -HideTableHeaders
$DriveCapacity=$StorageInfo |Sort-Object DriveLetter | ForEach-Object {[Math]::Truncate($_.Capacity / 1GB)}

$DriveLetters

$DriveNames

$DriveCapacity

The data that comes from that is as follows:

I'd like to be able to format it as such:

C:\, OSDisk - 232gb
D:\, Data - 97gb
C:\, SQLData - 97gb
C:\, SQLLogs - 97gb
C:\, SQLTemp - 97gb

...and I can't quite figure this out. Can anyone offer assistance?

Shay Levy · Accepted Answer · 2013-06-14 17:13:28Z

2

Try this way:

Get-WmiObject win32_volume -Filter "DriveType=3 AND Label <> 'System Reserved' AND DriveLetter IS NOT NULL" | 
Select-Object Name,Label,@{Name='CapacityGB';E={[Math]::Truncate($_.Capacity / 1GB)}}

If you want the exact output as described (thanks Ansgar):

Get-WmiObject win32_volume -Filter "DriveType=3 AND Label <> 'System Reserved' AND DriveLetter IS NOT NULL" | ForEach-Object{
    "{0}, {1} - {2}gb" -f $_.Name,$_.Label,([Math]::Truncate($_.Capacity/1GB))
}

edited Jun 14, 2013 at 17:13

answered Jun 14, 2013 at 16:31

Shay Levy

128k34 gold badges193 silver badges210 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ansgar Wiechers Over a year ago

Use "{0}\, {1} - {2}" -f (DriveLetter,Label,@{Name='...}) instead of Select-Object ... to get the particular output format.

Josh Waclawski Over a year ago

I'll be working on this again at the end of this week. I'll let you know how it goes then. Thanks for the responses, guys!

user3397917 · Accepted Answer · 2014-03-12 06:15:00Z

0

$logfile = <log file path>
 $path = <path of the file to which we need to sort> 
$Array = gc $path
 $Count = $Array.Count
 for($i=0; $i -le $Count; $i++) 
{ $a =$Array[$i]
 $i = $i+1
 write-output $i | out-file $logfile
 $a+=" "+ $Array[$i] 
$i = $i+1 
write-output $i | out-file  $logfile 
$a+=" "+ $Array[$i]
 write-output $i | out-file $logfile 
$New = $a | Select-Object -Unique #| out-file $logfile }

answered Mar 12, 2014 at 6:15

user3397917

211 silver badge1 bronze badge

Collectives™ on Stack Overflow

Powershell output formatting issue

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related