This may have already been answered elsewhere, but having trouble finding anything. I'm trying to include a list of VMs running on a ESXi host, and the query below works except it only returns the first VM in the results. How do I include the entire results in an email alert? Thanks!
select VM=b.Name
from [SolarWindsOrion].[dbo].[VIM_Hosts] a
inner join [SolarWindsOrion].[dbo].[VIM_VirtualMachines] b on a.HostID=b.HostID WHERE a.HostName LIKE 'esx001%'