Dear All,
Greetings!
Am trying to get the following details but it is not getting any output in excel file, someone help me in correcting this.
Get-Cluster |select Name, DrsEnabled, @{N="Details" E={Get-VMHostHardware | select VMHost, Manufacturer, Model, SerialNumber,BIOSversion}} | export-csv .\info.csv
output
Dataceneter Name, Cluster Name, DRSenabled, VMhost, Manufature, Model, Serialnumber, BIOSversion.
The name of the property is not correct.
Try like this
Get-VMHost -PipelineVariable esx |
Get-VMHostHardware |
select @{N='Site';E={$ds.Name}},
@{N='Cluster';E={$cluster.Name}},
@{N='Total Servers in Cluster';E={$cluster.ExtensionData.Summary.numHosts}},
@{N='VMHost';E={$esx.Name}},
@{N='DrsEnabled';E={$cluster.DrsEnabled}},
Manufacturer, Model, SerialNumber,BIOSversion |
Export-Csv -Path .\info.csv -NoTypeInformation -UseCulture
I have no experience with this HP Portal. But if it can be queried with a script, you should be able to add this.
Can you show how you script such a query?
Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference
Try like this
Get-VMHost -PipelineVariable esx |
Get-VMHostHardware |
select @{N='Cluster';E={$cluster.Name}}
@{N='VMHost';E={$esx.Name}},
@{N='DrsEnabled';E={$cluster.DrsEnabled}},
Manufacturer, Model, SerialNumber,BIOSversion |
Export-Csv -Path .\info.csv -NoTypeInformation -UseCulture
Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference
Yes! it is working.
I just added Datacenter details which was not listed in the out put., am looking to get the count of the server is in each cluster which is not working whith the following exentsiondate.
and is there any possibility to check the server warranty status by connecting to the HP portal through the script?
Get-Datacenter -PipelineVariable ds|
Get-Cluster -PipelineVariable cluster |
Get-VMHost -PipelineVariable esx |
Get-VMHostHardware |
select @{N='Site';E={$ds.Name}},@{N='Cluster';E={$cluster.Name}},
@{N='VMHost';E={$esx.Name}},
@{N='DrsEnabled';E={$cluster.DrsEnabled}}, Manufacturer, Model, SerialNumber,BIOSversion, @{N='Total Servers in Cluster';E={$cluster.extendata.summary.numberofhosts}, |
Export-Csv -Path c:\iinfo.csv -NoTypeInformation -UseCulture
The name of the property is not correct.
Try like this
Get-VMHost -PipelineVariable esx |
Get-VMHostHardware |
select @{N='Site';E={$ds.Name}},
@{N='Cluster';E={$cluster.Name}},
@{N='Total Servers in Cluster';E={$cluster.ExtensionData.Summary.numHosts}},
@{N='VMHost';E={$esx.Name}},
@{N='DrsEnabled';E={$cluster.DrsEnabled}},
Manufacturer, Model, SerialNumber,BIOSversion |
Export-Csv -Path .\info.csv -NoTypeInformation -UseCulture
I have no experience with this HP Portal. But if it can be queried with a script, you should be able to add this.
Can you show how you script such a query?
Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference
oh, yeah property was incorrect. thank you Lucd for correcting.
I found a script to check hp servers warranty
Since warranty is something that does not change, or at least not frequently, I would suggest to run that script and create the CSV file.
Do that in a separate script, and use the produced CSV as a kind of lookup table in the code above.
I don't know how the content of that CSV looks like, so I don't what property you could use to do the lookup.
Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference