Search the Community
Showing results for tags 'inventory report esxi'.
Found 1 result
I am trying to create a inventory report that includes information on the VMHost based on what it sees in the virtualization plugin. I am able to output a list of all of the VMs on a VM-Host with the VM-Host hardware information but I would like to make it cleaner. Sort-of like the format below: VMWare ESXI Hostname: (VMWare Version) (Used Memory)/ (Total Memory) (Used Cores)/(Total Cores) (Hardware Model of the server) (Processor Model Information) (Serial Number of server) VMInfo VMInfo ............ VMWare ESXI Hostname: (VMWare Version) (Used Memory)/ (Total Memory) (Used Cores)/(Total Cores) (Hardware Model of the server) (Processor Model Information) (Serial Number of server) VMInfo VMInfo ............ Does anyone know how to accomplish such organization? This is an example of my current SQL statement. This grabs the VMWare ESXI VMs and puts them in a list and adds hardware server in the line item letting you know what ESXi server it is on. SELECT locations.clientID, plugin_vm_esxhosts.DeviceId, plugin_vm_esxvirtualmachines.VmName, plugin_vm_esxhosts.DeviceName, plugin_vm_esxhosts.ProductName, plugin_vm_esxhosts.OtherInformation, plugin_vm_esxhosts.ProductFullVersion, plugin_vm_esxhosts.Vendor, plugin_vm_esxhosts.Model, plugin_vm_esxhosts.BiosVersion, plugin_vm_esxhosts.License, plugin_vm_esxhosts.CpuGhz, plugin_vm_esxhosts.NumberCores, plugin_vm_esxhosts.RamMb, plugin_vm_esxhosts.ProcessorType, plugin_vm_esxhosts.ProcessorSockets, plugin_vm_esxhosts.CoresPerSocket, plugin_vm_esxvirtualmachines.PowerState, plugin_vm_esxvirtualmachines.GuestOSFullName, plugin_vm_esxvirtualmachines.IPAddress, locations.name, networkdevices.IPAddress AS hostIP FROM plugin_vm_esxhosts JOIN networkdevices ON networkdevices.deviceID = plugin_vm_esxhosts.deviceid JOIN locations ON networkdevices.locationid = locations.locationid JOIN plugin_vm_esxvirtualmachines ON plugin_vm_esxvirtualmachines.deviceID = plugin_vm_esxhosts.deviceID