Rachel.Davidson

No, I am looking for the vcenter name. The only table i could find it in is the VIM.VirtualDisk table. :-(

 I can not find any events from any of the vcenters. I have tried different ways to find any event on any vcenter and I get nothing. We have tried it a bunch of ways with different Node fields and VMware Triggered alarm fields

1) Yes the Polling Method is VMAN 2) Yes we tried to just turn off all rules that was under VMware Events.

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}

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}

I have a different alert I am trying to get the vcenter from. This one is pulling from the datastore table. I tried this and it does not seem to work. ${N=SWQL;M=SELECT E0.Hosts.DataCenter.VCenter.displayname FROM Orion.VIM.Datastores E0 WHERE E0.Hosts.HostID = ${N=SwisEntity;M=Host.HostID}}

I got this from marcrobinson and it actually works!!! ${N=SWQL;M=SELECT E0.Host.DataCenter.VCenter.displayname FROM Cortex.Orion.Virtualization.TriggeredAlarmState E0 WHERE E0.relatedhost = ${N=SwisEntity;M=Host.HostID}} I really appreciate all ya'lls help!!!

Sorry that still didn't work. I even used this query in SWQL studio and it does work. SELECT E0.Host.DataCenter.VCenter.DisplayName FROM Cortex.Orion.Virtualization.TriggeredAlarmState E0But I added it to the Insert Variable But those just come back blank in the emails.

Hate to say it didn't work but.. it didn't work. :-) Here is a picture where I configured the message. Then this is what I get in the email. I know we are getting closer!!!

Hey Adam, I did try your code but it only brings the IP address up. Are you actually getting the name or just the IP? SELECT E0.[DisplayName], E0.Host.DataCenter.VCenter.name FROM Cortex.Orion.Virtualization.TriggeredAlarmState AS E0 WHERE ( ( ( E0.[Alarm].[Name] LIKE '%vmnic%' ) AND ( E0.[Host].[Status] != '1' ) ) )

Thanks donrobert5, I will see about getting that part blacked out. :-)

I went ahead and put in a feature request to make the vcenter name available in the Insert Variables option. https://thwack.solarwinds.com/product-forums/the-orion-platform/i/feature-requests/make-the-vcenter-name-available-as-a-variable-in-alerts-for-vmware-triggered-alerts I am hoping to maybe get traction this way. :-)

Hey flackovic, this is the trigger condition I am using. I did add the your code to my alert but it does not bring any info back. Also, don;t you think it is weird that the only place in the database where you can find the VcenterName is in the Orion.VIM.VirtualDisks table? Thanks so much for looking at this, I am super…

Maybe no one knows the easy way to do this??? :-)

Sorry I actually had 2 different reports in there but when I cut it down to just one report it works great!! SELECT DISTINCT [CCS].Component.Application.Node.Caption , CASE WHEN [AUOptions].[ComponentMessage] LIKE 'Connecting%' THEN 'N/A' ELSE [AUOptions].[ComponentMessage] END AS [AUOptions] , CASE WHEN…

Yes the one you put in works. But I need the values to be columns. Our DBAs rewrote the quere and this one works! :-) SELECT DISTINCT APM_AARD.[NodeName] ,CASE WHEN AUOptions.[ComponentMessage] LIKE 'Connecting%' THEN 'N/A' ELSE AUOptions.[ComponentMessage] END AS [AUOptions] ,CASE WHEN…

Ok, I had to upgrade to get this option. So now that I have it, is there a way to add a list of servers in the search field? I tried server,server and server;server but none of those work.

Ahhhh, I only have version 2020.2.5 and it does not have that option in that version. :-( I will have to upgrade for that one. But thanks so much, it will really help when I get it!

Did you ever get an answer on this or get your query working? I have run into the same issue. This works when you use SQL to query the database but it does not work in the report writer. WITH AUOptions AS (SELECT NodeID,ComponentMessage FROM APM_AlertsAndReportsData WHERE UserNotes = 'AUOptions'), ScheduledInstallTime AS…

I would love to be able to make dynamic groups but still have not figured out how to do it easily. I don't think Custom Properties are going to work for what I am looking for. So lets say I have 100 servers numbered 1 - 100. I want to only look at the results on 3,8,25,34,48,56,62,78,82,99 If there was an "in" option then…

ok, couple things. I could not find the SEARCH and SORT options but that does sound like it will be helpful. Also I am not sure if I understand Custom Properties. Can you only add custom properties that have to be manually added? I am trying to add custom property that comes from the information I pulled in a template.…

Yes, thanks that does work!! I was hoping I could make a dynamic group each time and only run the report against a group. I am not sure that is even an option. But let's say we have 5000 servers and I only want to check 100 of them. Do you think that editing the report each time is the best way to get that? I am open to…

What if I only want to run a report against a small list of servers? Is there a way to make a query group "on the fly" with a list of server names?

I did watch a video where when you looked at the summary of a node, there was a window where you could see all the patches installed on that node. Maybe if I can re-create that, it can help me see some of the results I am looking for. Do you know how to add the window in Summary that shows all installed KB numbers on each…