sunvad

Congratulations to the new MVPs! 

Thank you. We moved to OpenSSH and configured CUCM to send all the backups to a different server.

Glad that you were able to fix it! Could you help me with the process please for the downgrade? We are currently on SFTP/SCP version 2.2.6.60051. 

Thank you Shuth. I've tried this prior to creating a post here, it wouldn't work for some reason, but it did couple of days after. Not sure what I missed. I've configured an alert using SWQL - it basically does the same.

Additional info: Format = Text (on the UDP). Trigger Condition: I've tried both I want to alert on "Custom Node Poller" and "Custom Poller Table Current Status" - still no luck. @"KMSigma.SWI" Seeking your help on this please. :-)

@"sum_giais" can this report be edited to include data in the last 'x' months?

We use the following query for our availability KPI Widget - current month. Select ROUND(AVG(orion_responseTime_availability_avg),2) as Net_Avail from ( SELECT TOP 2000 aggSub._avg AS Orion_ResponseTime_Availability_avg FROM Orion.Nodes n LEFT JOIN ( select i.nodeid, avg(i.availability) as _Avg from orion.ResponseTime i…

Thank you @"bobmarley", this one definitely worked. It is a pretty long list based on my filter :-) Is there a way to pull this report only during business hours, say 9am to 5pm in the last 30 days/last month time period? thanks again.

Thank you @"bobmarley", and sorry for my delayed response. I have seen this thread. Quick check please - does the query capture results, when the interface was utilized say more than 90% for a continuous time period of XX minutes? Not really good with scripting, sorry about that.

@"KMSigma.SWI" @"bobmarley" - Can you help please? :)

what is considered normal? 

Figured it! join SysLog ON Nodes.NodeID = SysLog.NodeID where (Message LIKE '%Down%BGP%') and datetime>dateadd(hour,-24,getdate()) Group by Nodes.Caption, Nodes.NodeID having count(*)>2

Changed alert from SWQL to SQL, but no luck. Any changes to get this working correctly please?

Hi, can this be used to set up alerts for flapping BGP routes?

Hi bob, I'd like to create a new alert using web console for the following trap info. Can you walk me through the steps please?

Definitely helped bump this post 

See this post

Using SNMP OID - 1.3.6.1.4.1.9.9.42.1.2.10.1.1. We have multiple IP SLAs configured on the WAN Router; you can see the test result in my original post. I was hoping to display the results as a table widget, but couldn't figure out a way and hence my post. However, I have added individual IP SLAs as a poller on the node.…

We have created a group which has all categories of devices (network, server etc.) in the DMZ segment. Status rollup mode is set to 'Show worst status', so even if a single node is down, group status is down. Now this generates one alert for the group and another for the actual 'node down'. I've tried to create a…

thwack.solarwinds.com/.../cisco-wap-inventory-report

You're the best! thank you @"marlief22"

Hi @"marlief22", I've tried adding a case section and it gives an error about a syntax. Do I add an "END" somewhere in the case statement? SELECT n.Node.Caption, n.CurrentValue, n.Node.Status, n.Node.DetailsUrl CASE WHEN n.Node.Status = 2 THEN 'Unknown' ELSE n.CurrentValue AS [Service Status] FROM…

thank you @"marlief22". Will try this and update how it worked. Cheers!

Waited for the issue to occur and hence the delay :) Here is how it looks. As you can see, two nodes are operationally down, however the status displayed is "service is working". It is taking the last polled value from UnDP. Dashboard Query: SELECT n.Node.Caption, n.CurrentValue, n.Node.Status, n.Node.DetailsUrl FROM…

Late update And you're right. I have tested your query and it does list the correct number of ports. Works perfectly for me. Thank you. :)

Thank you @"dunky2k" and @"marlief22" Quick question pls - Is the query fetching directly from the Switch? Reason I ask is because we have a case where not all interfaces were checked (under list resources) when a particular node was added, probably because it was inactive/not in use. If the query only works for interfaces…

Sure, here you go. Add below OIDs via UnDP and assign them to each WLC that you wish to report on. AP NAME : 1.3.6.1.4.1.14179.2.2.1.1.3 (Assignment name as bsnAPName) IP : 1.3.6.1.4.1.14179.2.2.1.1.19 (bsnApIpAddress) MODEL : 1.3.6.1.4.1.14179.2.2.1.1.16 (bsnAPModel) SN : 1.3.6.1.4.1.14179.2.2.1.1.17 (bsnAPSerialNumber)…

IT WORKED! What a flawless report, thank you Alain

Hi @"alain_p" - appreciate your help on this, thank you. I have imported the report and unfortunately it did not work for me. Although I've modified cpa.ASsignmentName to the ones matching in my original post, there is no luck. Only 4 pollers are assigned to my test WLC - AP Name, IP, Model and Serial and I can see…

Bump!