This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

VMAN Cluster alert displays wrong host

Running 2020.2.4, noticed the out of the box Cluster predicted memory depletion alert was on.

Before customising it to inform people, I looked at the details and it is displaying the incorrect host as the cause in both the active alert and the event raised.

When I check the query adding in the inner join in to the swql to show the expected host, and also in the alert to try there also, the swql shows as expected but the alert/event still refer to an incorrect host:

SELECT  Clusters.Uri,  Clusters.DisplayName,  hosts.hostname, clusters.MemoryUtilizationDepletionDate  FROM  Orion.VIM.Clusters  AS  Clusters

inner join  orion.vim.Hosts  as  hosts  on  hosts.ClusterID  =  clusters.clusterid

where DayDiff(getdate(),   clusters.MemoryUtilizationDepletionDate)<7

Helpful advice would be gratefully received.

Parents
  • just to add, doing the same query with swql's inbuilt link without the join to remove the additional join being doubted shows the same issues of wrong host returned in the alert compared to the query. Making the alert from scratch again also shows the same. Most odd.

    SELECT   Clusters.Uri,   Clusters.DisplayName,   clusters.hosts.hostname,  clusters.MemoryUtilizationDepletionDate   FROM   Orion.VIM.Clusters   AS   Clusters

    where DayDiff(getdate(),    clusters.MemoryUtilizationDepletionDate)<7

Reply
  • just to add, doing the same query with swql's inbuilt link without the join to remove the additional join being doubted shows the same issues of wrong host returned in the alert compared to the query. Making the alert from scratch again also shows the same. Most odd.

    SELECT   Clusters.Uri,   Clusters.DisplayName,   clusters.hosts.hostname,  clusters.MemoryUtilizationDepletionDate   FROM   Orion.VIM.Clusters   AS   Clusters

    where DayDiff(getdate(),    clusters.MemoryUtilizationDepletionDate)<7

Children
No Data