The most recent content from our members.
Hi team, Recently we have run into a few cases where the Incoming request (per minute) have passed our device limit and affecting the internal network. Appreciated if someone can guide me or enlighten my how to collect the Incoming request (per minute) for the below devices: * F5 Load balancer * Juniper Firewall My target…
Hi Guys, I was working on a swql query to get the list of all vms from vmware / hyperv or nutanix. This query has helped me to identify which servers are Managed servers and which are not. Thats not it, I have also added custom properties too for more granular analysis. Here's the query for your reference. SELECT n.Name as…
Hello We have a custom Poller which is polling the last failover of the device to HA. We can see the value with the following SWQL. Now the format of CurrentValue is HH:MM:SS UTC Oct 7 2024. What we want to do is convert into DateTime format and validate if the timestamp is less than 1hr it means the device has recently…
Hi, I am looking for your kind support to develop an SWQL query to get AvgRate value displayed as a chart with historical data. I already have a custom poller which is displaying default total value as shown in the screenshot but I need AvgRate value which is already available in DB. Thanks Shahzad
Hello, I want to make a dynamic colouring process in order to highlight the DELAYED_TARIH field in my query. If the date is today's date, I want it to remain red if it is a date that is not yet due, I want it to remain green. I am waiting for your help in this regard, thank you. SELECT Caption AS LOKASYONADI,DetailsUrl AS…
Hi, I'm facing some issues while UnDP custom poller for Power device. That power device have 5 interfaces but i need only 1 interface and remaining 4 needs to be removed from custom poller. I need to use the formula like P[dBm]= 10*log10(P[mW]) P[dBm]= 10*log10(1000*SNMPreading*10^-6*0,1) here snmpreading value will get…
How is it possible to add the polled time for a custom poller to this query below? I am unable to use the inbuilt SolarWinds widget as it displays unwanted information (chart values which are presented on a separate widget). SELECT a.CustomPollerName AS Name, a.CurrentValue AS Value FROM Orion.NPM.CustomPollerAssignment a…
There seems to be a limited set of widgets to apply in EOC, most importantly the Custom Query Widget
Anyone know what table the interface IP address and Subnet mask is located in? Everything that I am seeing either goes back to outdated information or gives me the node IP address. Any help would be greatly appreciated. I would think it would be under the "Orion.NPM.Interfaces" table but no luck. SELECT…
I'm looking to create custom query on SolarWinds to show the status of a SQL job, but I want to be able to view the last 5 times (if that makes sense) I have found this prebuilt query on THWACK (SQL Agent Job Status - Forum - Server & Application Monitor (SAM) - THWACK (solarwinds.com)) already but I'm struggling to get it…
It looks like you're new here. Sign in or register to get started.