Jump to content

Search the Community

Showing results for tags 'inventory report esxi'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • MSPGeek
    • Announcements
    • The Geek Cast
    • Code of Conduct
  • ConnectWise Automate / Labtech
    • ConnectWise Automate / LabTech
    • ConnectWise Automate / LabTech - Development

Categories

  • ConnectWise Automate
    • Scripts
    • Plugins
    • SQL Snippets
    • Role Definitions
    • Automate PowerShell Code
    • Reports
    • Internal Monitors
    • Remote Monitors
  • ConnectWise Manage
    • API Interacting Code

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


About Me


Location


Agent Count


INTERESTS


OCCUPATION


ICQ


WEBSITE


WLM


YAHOO


AOL


FACEBOOK


GOOGLEPLUS


SKYPE


TWITTER


YOUTUBE

Found 1 result

  1. 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
×
×
  • Create New...