ESx host in maintenance mode

Hey Guys and Gals looking for a way to pull up a list of ESx hosts that are in maintenance mode(according to vcenter not Orion), this info is available in the database.  From said list I'd like to provide a link for the user to utilize to go to that esx host, this doesn't seem to be available in the DB but is available via SWIS for the host table, but the inmaintenancemode column ins't available via SWIS......

any experts out here that can help me?

Unless someone has other suggestions I guess I'm going to have to save my DB results to a file and use the results via SWIS to get the URL's I need.  I wonder why Solarwinds makes some things so hard sometimes....

Thanks as always

Chris