Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Get Vcenter name in emails on hardware errors.

Hey Ya'll, I received a great query that I can use to get the Vcenter name into the email alerts when the trigger condition was on the "VMware Triggered Alarm" Shown below

Get vcenter name in email alerts

Host Name - ${N=SwisEntity;M=Host.HostName}

vCenter Name - ${N=SWQL;M=SELECT E0.Host.DataCenter.VCenter.displayname FROM Cortex.Orion.Virtualization.TriggeredAlarmState E0 WHERE E0.relatedhost = ${N=SwisEntity;M=Host.HostID}}

But I also had to setup node hardware alerts where the triggered condition is on "Hardware Sensor (Node)" So this query is not working to get the Vcenter name.

Does anyone know what the query should look like FROM Orion.HardwareHealth.HardwareItem

Find more posts tagged with

Accepted answers

Rachel.Davidson

I Joined a table and got it to work! :-)

vCenter Name - ${N=SWQL;M=SELECT VH.DataCenter.VCenter.DisplayName

FROM Orion.HardwareHealth.HardwareItem AS HI

JOIN Orion.VIM.Hosts AS VH ON HI.NodeID = VH.NodeID

WHERE HI.NodeID = HI.Node.NodeID}

All comments

Rachel.Davidson

I thought this might work but it does not. :-(

vCenter Name - ${N=SWQL;M=SELECT HI.node.Host.DataCenter.VCenter.displayname

FROM Orion.HardwareHealth.HardwareItem AS HI

WHERE HI.NodeID = HI.Node.NodeID}

cheryl1

I'll admit right away that I'm not entirely sure about this one. You might want to float this one up in the VMAN forum? I seem to recall a similar question a while back, and I think it was answered by someone familiar with VMAN, but I can't find the thread now. LOL

adam.beedell

I think you'd go hardware item to host/node to host to datacenter to vcenter or similar

Rachel.Davidson

I Joined a table and got it to work! :-)

vCenter Name - ${N=SWQL;M=SELECT VH.DataCenter.VCenter.DisplayName

FROM Orion.HardwareHealth.HardwareItem AS HI

JOIN Orion.VIM.Hosts AS VH ON HI.NodeID = VH.NodeID

WHERE HI.NodeID = HI.Node.NodeID}