3 Replies Latest reply on Jul 1, 2013 7:00 PM by jpineda

    Alert when ESX Status in equal to UP

    jpineda

      Has anyone successfully done this before?polling

       

       

      I submitted a ticket and they said that this will need to be a custom sql alert because there's no template made for it yet.

      hardware.jpg

        • Re: Alert when ESX Status in equal to UP
          rlaplante@bhfs.com

          Looking for the same (similar) alert.  What I found was thought the Custom sql alert is there, you still have your hands tied a bit.  The Custom SQL Alert limits what databases/tables you can query.  Only there WHERE is available, Select and FROM are restricted.  I want to alert on Operation Status != Connected.  I found the db where that data is [SolarWindsOrion].[dbo].[VIM_Hosts].  This specific table cannot be queried from the Custom SQL Alert.  The following select statement works in SQL managment studio.  If you are not the VMWare admin talk to them.  vCenter can be configure to send SNMP trap to Orion and you can alert off of those.  I opted to just let vCenter send an email alert and by-pass Orion.  (hint-hint nudge-nudge towards SolarWinds to work on ESX Host Alert templates ;-)

           

          SELECT [HostID]

                ,[HostName]

                ,[VMwareProductName]

                ,[IPAddress]

                ,[ConnectionState]

                ,[OverallStatus]

                ,[NetworkUtilization]

                ,[NetworkUsageRate]

                ,[CpuLoad]

                ,[CpuUsageMHz]

                ,[MemUsage]

                ,[MemUsageMB]

                ,[VmCount]

                ,[VmRunningCount]

          FROM [SolarWindsOrion].[dbo].[VIM_Hosts]

          WHERE (OverallStatus != 'green' OR ConnectionState != 'connected')