Hello,
I have several scripts to get vm info into csv file,
No idea why, but in the last period I get always long output for disk,
example:
UsedSpaceGB | ProvisionedSpaceGB |
24.158.326.207.939.500.000.000.000.000 | 25.341.041.051.689.500.000.000.000.000 |
24.052.384.103.182.700.000.000.000.000 | 25.341.055.978.182.700.000.000.000.000 |
23.361.345.231.067.300.000.000.000.000 | 24.541.032.731.067.300.000.000.000.000 |
23.337.542.755.436.100.000.000.000.000 | 24.541.058.380.436.100.000.000.000.000 |
23.143.484.270.293.200.000.000.000.000 | 24.541.042.864.043.200.000.000.000.000 |
This happening since I upgrade office to 365.
This is script (before got readable data)
$powerstate = @()
foreach($vmlist in (Get-Content -Path C:\Users\geme\Desktop\AP\ALLVM.txt)){
$vm = Get-VM -Name $vmlist
$powerstate += (Get-VM $vm |
Select Name,PowerState,Version,NumCpu,MemoryGB,UsedSpaceGB,ProvisionedSpaceGB,
@{Name="ToolsVersion";Expression={$_.ExtensionData.Guest.ToolsVersion}},@{Name="ToolsStatus";Expression={$_.ExtensionData.Guest.ToolsVersionStatus}})
}
$powerstate | Export-Csv -Path C:\Users\geme\Desktop\powerstate_report.csv -NoTypeInformation -UseCulture
This has always been like this.
I don't know what Office365 has to do with this. Perhaps a default format in Excel has changed.
That kind of report I always had to do like this (use the [Math]::Round method)
Select Name, PowerState, Version, NumCpu, MemoryGB,
@{N = 'UsedSpaceGB'; E = { [math]::Round($_.UsedSpaceGB, 1) } },
@{N = 'ProvisionedSpaceGB'; E = { [math]::Round($_.ProvisionedSpaceGB, 1) } },
@{Name = "ToolsVersion"; Expression = { $_.ExtensionData.Guest.ToolsVersion } },
@{Name = "ToolsStatus"; Expression = { $_.ExtensionData.Guest.ToolsVersionStatus } } |
Export-Csv -Path C:\Users\geme\Desktop\powerstate_report.csv -NoTypeInformation -UseCulture
Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference
This has always been like this.
I don't know what Office365 has to do with this. Perhaps a default format in Excel has changed.
That kind of report I always had to do like this (use the [Math]::Round method)
Select Name, PowerState, Version, NumCpu, MemoryGB,
@{N = 'UsedSpaceGB'; E = { [math]::Round($_.UsedSpaceGB, 1) } },
@{N = 'ProvisionedSpaceGB'; E = { [math]::Round($_.ProvisionedSpaceGB, 1) } },
@{Name = "ToolsVersion"; Expression = { $_.ExtensionData.Guest.ToolsVersion } },
@{Name = "ToolsStatus"; Expression = { $_.ExtensionData.Guest.ToolsVersionStatus } } |
Export-Csv -Path C:\Users\geme\Desktop\powerstate_report.csv -NoTypeInformation -UseCulture
Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference
Thanks a lot LucD , this works proper.