- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Export Esxi information
Hello
there is a script that can export the next Data from my Esxi Servers?
- Cluster
- Host
- CPU Model
- ID CPU
- Cores per CPU
- Esxi Total Memory
- Current CPU power man policy
- Esx Version
- Boot Time Or Uptime
- DNS Servers
- NTP Servers
- Bios Version
- Bios Date
thank you!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Most of the informations you need can be provided by the software RVTools (you can export in a .csv /excel file any informations)
Here's the link
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello
with rvtools the (,) is prevent me to import the data to sql servers and use it in reporting services.
i prefer script instead
thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
You can try this, the display is not very good but you got all the information :
You have to write your cluster or * in the $esx line
$esx = Get-Cluster "YourCluster or * " | Get-VMHost
foreach ($esx in $esxHosts) {
$esx | Select Name,ProcessorType,NumCpu,MemoryTotalGB,Version,Build
$esx | Get-View | Select @{N="Uptime"; E={(Get-Date) - $_.Summary.Runtime.BootTime}}| fl
$esx | Select @{Name="NTPServers"; Expression = {($esx | Get-VMHostNTPServer)} } | fl
$esx | Get-VMHostNetwork | Select DnsAddress | fl
$esx | Get-VMHostHardware | Select BiosVersion | fl
}
It only misses ID CPU and Bios Date, i'm working on this..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try something like this.
Bios information depends on the HW vendor and the HW type, it is not avaialble for all HW.
Select Name, @{ N = 'Cluster'; E = { (Get-CLuster -VMHost $_).Name } },
ProcessorType,
@{N = 'CoresPerCPU'; E = { $_.ExtensionData.Hardware.CpuInfo.NumCpuCores } },
MemoryTotalGB,
@{N = 'PowerPolicy'; E = { $_.ExtensionData.Config.PowerSystemInfo.CurrentPolicy.ShortName } },
Version,
@{N = 'BootTime'; E = { $_.ExtensionData.Summary.Runtime.BootTime } },
@{N = 'DNSServers'; E = { $_.ExtensionData.Config.Network.DnsConfig.Address -join '|' } },
@{N = 'NTPServers'; E = { $_.ExtensionData.Config.DateTimeInfo.NtpConfig.Server -join '|' } },
@{ N = 'BIOSVersion'; E = { $_.ExtensionData.Hardware.BiosInfo.BiosVersion } },
@{ N = 'BIOSDate'; E = { $_.ExtensionData.Hardware.BiosInfo.ReleaseDate } }
Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You have this info in uc4.
Moreover, these paramaters can be export easily with vmware orchestrator ![]()
Good luck!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Not sure what you mean by CPUId?
Is that the CPU Tag?
Perhaps show an example?
Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
CPU count
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If you mean the physical CPU packages, you can add this line
otherwise you can use the property NumCpu (which is packages X corespercpu)
Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference