cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

How to: Show all ESXi Hosts in Maintenance Mode

The magic of the Orion Platform lies in the open database and the flexibility to customize your views using your data. I'll be writing up some common customization requests that we receive for Virtualization Manager, as an ongoing blog post series. If you like a particular customization described, feel free to add a feature request here Virtualization Manager Feature Requests to add it as a default report or widget. We are also looking to see your custom content so send what you have to us here: Send us your VMAN custom content directory for 500 THWACK points!

First, start off with your basic "Custom Table" widget.

pastedImage_1.png

Click "Configure this resource"

pastedImage_2.png

Change the title and subtitle and then click "SELECT DATASOURCE." In this particular example, you'll be changing the selector to "Advanced Database Query" and selecting "SQL"

pastedImage_0.png

Now it's time to take a good look at your data. In your Orion database, you'll be looking for a table named VIM_Hosts

pastedImage_5.png

With a small SQL query like

SELECT  HostName, IPAddress
FROM SerenaOrion.dbo.VIM_Hosts
WHERE InMaintenanceMode = 1;

You'll be able to find the Name and IP address of any ESXi host that is in maintenance mode. Add that into the Data Source Picker

pastedImage_8.pngpastedImage_9.png

Once you've updated your data source, select your table columns.

pastedImage_10.png

pastedImage_11.png

I've chosen HostName and IPAddress, but also choosing not to group the results.

pastedImage_12.png

Click submit and there you have it, a widget that can be added to any of your custom dashboards views.

pastedImage_13.png

If you'd like to add this data to a report, again the custom table will be your ally. Simply find the custom table and follow the same customization steps that were detailed for the widget

pastedImage_0.png

pastedImage_1.png

pastedImage_2.png

Finalize your report by clicking through the wizard and now you can have this same report emailed to you. What customizations have you done? What would you like to see next?

Version history
Revision #:
1 of 1
Last update:
‎06-04-2018 07:21 PM
Updated by: