Sivaprasad · Networking Technical Support Engineer · ✭✭✭

Whenever Group is down only one alert event should trigger but when devices (one or more Members) in that group are down should generate multiple alert events. please help on this information. Requirement - Whenever group is down should get one alert event. If any members are down, we should get two alert events in the…

Hi twzbowser, Could you please provide the template or script which you run the cisco 9300 switches for the firmware upgrade?? and also share the steps how you have done the upgrade through solarwinds NCM. Thanks, Sivaprasad

Hi Lofstrand, Instead of account ID it is showing System. Till previous version it shows account name , now it is showing system whoever keeps the device muted. Please check and help. Thanks, Sivaprasad

Hi Lofstrand, Thanks for the response and query. For the above query Suppresed by showing as System. In place of system, we need account ID who kept the alerts muted. could you please check this also. I want only Alerts muted so i have removed unmanaged lines from the query. SELECT N.Caption AS [Node], CASE WHEN…

Hi Lofstrand, If you have any query on who muted the alerts. Please share the query. One more question, is there any application to test the query and errors of the query we are getting in the Solarwinds? Thanks, Sivaprasad

Hi Lofstrand, Please find and check the below query once. SELECT 'Muted' as [Status] , n.caption , tostring(tolocal(SuppressFrom)) as [From] , case when SuppressUntil is null or SuppressUntil = '9999-01-01 00:00:00' then 'Not set' else tostring(tolocal(SuppressUntil )) end AS [Until] , case when SuppressUntil is null or…

First query is also working in my environment but after upgrade it is not showing the accountID who kept the alerts muted, now it is showing system instead of account name.. Second query is not working. Please check this. Second Query - After upgrade SELECT 'Muted' as [Status] , n.caption , tostring(tolocal(SuppressFrom))…

Hi Lofstrand, Any luck on the query? Thanks, Sivaprasad

Hi Lofstrand, Thank you for the response. Query is running fine, but having few doubts in the above query, i could not see any DestOrionNodeID column in the Topology Connections table in the database. How this query got running fine ?? and also, i am getting "caption" and "caption1" instead of SourceNode and…

Hi Lofstrand, Thank you for the response and sorry for the delay in response. We have checked the query in our environment. it is working fine. I have received the schema article also. I will get back to you if any help needed. Thanks, Sivaprasad

Hi Lofstrand, Thank you for your response and the query. We have modified your query Discards and Errors separately and test got successful for both report and Alert condition. Below is the query Report Query (TotalPackets- SWQL) SELECT I.Uri, I.NodeID, I.InterfaceID ,IT2.LastTrafficTime ,IE2.LastErrorsTime…