Adding an ESX Servers list to Orion Web Page

Question

I have the Orion upgraded to include the new ESX awareness and have discovered my ESX servers.  Additionally, I have added a section to my Orion Web page that shows all of my ESX servers by doing a list of nodes with Vendor Like 'VMware, Inc.'

What I would like to have is a section on my Orion Web Page that is like the free SolarWinds VM Monitor shows but with all of the ESX servers listed, i.e. the ESX server with something like the List of Virtual Machines as an indented set.  I have been playing with this for a day or so and can't quite get the pieces to work together.

Thanks

paulw001 · Accepted Answer

I used report writer to create a report like this:

SELECT  TOP 10000 Nodes.Caption AS NodeName,
VirtualMachines.DisplayName AS DisplayName,
VirtualMachines.NodeID AS NodeID,
VirtualMachines.OperatingSystem AS OperatingSystem,
VirtualMachines.GuestState AS GuestState

FROM
VirtualMachines INNER JOIN Nodes ON (VirtualMachines.HostNodeID = Nodes.NodeID)

ORDER BY 1 ASC, 2 ASC

(Or put another way:

Select Fields: Node Name, Display Name, Virtual Node ID, Operating System, State

Don't filter results, Show all records

Timeframe: Last 7 days (that handles VM Moves etc.)

Do not summarize the results

Default field formatting (The OS column might needs some work)

Don't group.

You can then embed this into a view in Orion to get a nice view of all provisioned VMs and links to where there are located/data on them etc. (I left the Monitoring ID in because I wanted to easily work out which VMs were production and which were templates or Dev/QA systems).