The most recent content from our members.
To create a query to alert on a flapping routing protocol. First, for the Alert Engine, we need to Alert on nodes so we have to design a SQL query to return NodeId we can use the NPM_RoutingTable_Flap so that we also have the FlappingId to allow a count We also want to be able to identify the Protocol we are interested in…
As a database administrator (aka DBA, or Default Blame Acceptor) throughout my career, I’ve worked with a myriad of developers, system administrators, and business users who have all had the same question—why is my query (or application) slow? Many organizations lack a full-time DBA, which makes the question even harder to…
I need some help whit this SQL script i have used in the Report. Need to get the Status of the interface if its up or down and whit LED icon. Can anyone help whit this? select Interfaces.nodeID AS NodeID, Nodes.Caption AS NodeName interfaces.caption AS InterfaceName, interfaces.interfaceIndex, NodeIPAddresses.IPAddress,…
I'm needing some help adding up the number of "Units" my Nodes reports on a specific UnDP that I have created. RawStatus is the number that is node is reporting and these numbers are correct. All my of nodes are getting summed correctly (somehow, it polls the value every 6 hours and there are multiple entries through out…
Hi all, There may be an easier way to do this (and if so, please tell me), but I'm trying to create a Custom SQL Alert for when a server has less than a stated amount of memory free. I create my trigger condition and I'm starting with the query: select Nodes.SysName from Nodes where (TotalMemory - MemoryUsed) < 4096000000…
This is based on the the SWQL 95th Percentile Traffic Rate – Last Month report and now using SQL. I would like to be able to group the data by month summarizing all historical data. SELECT n.Caption as NodeName, format(DateTime,'MM/yyyy') as Report_Date, Max(In_Averagebps) as maxInMaxbps, Max(Out_Averagebps) as…
Simple Query getting 1 rool not returming 1 row or return a null This works or at least passes the test? use SolarWindsOrion Select Case when traps.Message like '%oraEMNGEventTypeAttr1.1=Availability status=Up%' then 1 when traps.Message like '%oraEMNGEventTypeAttr1.1=Availability status=Down%' then 2 end as status from…
Can you believe THWACKcamp is only a week away?! Behind the scenes, we start working on THWACKcamp in March, maybe even earlier. I really hope you like what we have in store for you this year! As always, here are some links I found interesting this week. Enjoy! Florida man arrested for cutting the brakes on over 100…
It looks like you're new here. Sign in or register to get started.