Search the Community
Showing results for tags 'esxi'.
Found 3 results
We've been working to try and utilize the Virtualization manager inside of Automate. We want to see if it's possible to setup our host for regularly scheduled reboots when it hits a certain uptime. Has anyone had success with this or even using the Reboot Host button inside of the virtualization manager. Any input is appreciated!
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