wluther · Breaker of Things · ✭✭✭✭✭

@"dkos", I should rephrase my question, as the answer will lead you down different paths. In my example, I am actually using SAM to pull the SNMP values, as we don't really need anything more than the basics. If you use SAM to poll SNMP values, you can simply add a resource to display the components/statistics data on the…

@"dkos" You can either use SAM or create a poller via the Universal Device Poller. Once you create the poller, having it point to the SNMP data you need to pull, you can then display that data in various ways. You don't necessarily need to display the data via SWQL queries, though you can usually manipulate it a bit more.…

I created a new report and added a custom query to it, then duplicated it until I had 5 of them. The report seems to load just fine for me, but the query is about as simple and calm as could be, so maybe it's just not using enough juice to encounter the issue. SELECT TOP 1 n.Caption FROM Orion.Nodes AS n

@"bourlis" Would you be willing to export the report and dump it here. Maybe we can pull it into a completely different system and test it there too. I just rebuilt my dev environment this morning, running 2023.1, and could test it here to see if I get the same thing.

@"syoung" The first thing I'd do, is verify your results are as expected. You can start by clicking the little down arrow to the far right side/corner of the first row of the trigger condition. This will give you the option to generate a SWQL query for the condition as built, and should give you a starting point. You can…

@"tallyrich" not sure if this helps, but I have a post which may be somewhat related. thwack.solarwinds.com/.../i-don-t-know-what-i-m-doing-and-this-is-how-you-do-it-how-i-learned-how-solarwinds-products-work-part-3-of-1 I hope it helps. Thank you, -Will

Hopefully my reply with the log info will be unmarked as spam.

These are the repeating log entries, 10-300 MB daily, just this info nonstop. 2023-02-16 23:41:19.880 -06:00 [ERR] Unable to load license file 'C:\Program Files (x86)\SolarWinds\Kiwi Syslog Server NG\KiwiSyslogNG-1-Evaluation.lic' due to error code '"SaveFailed"'. 2023-02-16 23:41:20.075 -06:00 [INF] Invoking…

*Installed as a service.* Not sure if something got hung up during my install, but I cannot, for the life of me, get any syslog messages displayed (possibly even received) in this beta. Firewall completely disabled, forwarding messages from production Kiwi server to NG server (production successfully forwards to our…

Glad to hear you got what you needed.

@"christian.goulard" This is the report I have scheduled to be sent every morning. This report provides an overview of the max In/Out bps for each of our 3 uplinks, as well as the total combined, over the last 7 days. For me, I find it easier to implement custom properties to group the entities I need for reports and…

@"planglois" On behalf of THWACK Nation, thank you! I'm adding this to my stash of gems now.

My initial reply was blocked, for whatever reason(s), so let's see if this reply makes it through or not... This is what I have used for a while now, which I originally found floating around on THWACK. Case When Floor((SecondDiff(e.EventTime,GetDate()) + 0.0)/86400)>0…

@"HelpMeTHWACK" I use an old case statement I swiped from someone else on THWACK, probably 100 years ago, but it still seems to work well so far. ,Case When Floor((SecondDiff(e.EventTime,GetDate()) + 0.0)/86400)>0 Then ToString(ToString(Floor((SecondDiff(e.EventTime,GetDate()) +0.0)/86400))+'d '+…

Just in case it is what you are looking for, here is a quick and simple run through of how to get there. Add your new/empty table widget Select the graphical query builder Search, find, and add these fields. You can either submit what you have, or you can scroll down a bit and filter out some of the results if you'd like.…

@"bunjiega" You should be able to get pretty close by just using a few of the main fields without even needing to use a SWQL query. Is this something, more or less, you are tryin to accomplish?

Yeah, the ability to modify so much has always been a great asset to these products. I truly think that has been an enormous factor in the success of these products. Here is a tool that will do 90% of what you need, and we've made it to where you can build the last 10% to make it fit exactly how you want. Unfortunately,…

I believe this is what I was thinking... Disable Duplicate Detector for Discovery Engine in Orion Platform * RDP the main server and stop the services. * Go to C:\Program Files (x86)\SolarWinds\Orion\ and edit the SolarWinds.Orion.Discovery.Job.dll.config in a Notepad as an admin. * Scroll to bottom of the file and look…

I believe you will need to add/change a setting in one of the config files on the server. I think it's the business layer config file, but I'll check my notes and reply back when I find it. (Presuming I'm properly understanding your request)

This is the way.

@"jamshad2712" I'm not super certain, but you might be able to wrap something in a ISNULL(,0), which should dump out a 0 if not having another value. Maybe (again, just as a guess, as I'm not somewhere I can test) you can try ISNULL(COUNT(1),0) AS CountItems I do something like that in a few spots for some of our…

SIGN.ME.UP! (Please)

So, if it's an option, maybe just add the "raw" data in another column. It's not as clean looking as just the single column, but it will work. SELECT i.Name ,ROUND(((i.Inbps) / 1000000000),2) AS [In Gbps] ,(i.Inbps) / 1000000000 AS [Inbps]

@"dkeyser" I think it is because you are actually clicking the column header to sort. If you use the ORDER BY in the SWQL, then the results should already be sorted without needing to click the header to sort. I do the same thing with last boot and uptime. I have my last boot column in case someone wants to click the…

@"scott.campbell-taylor", just to add another option into the mix, you can always just create a new tab up top. You can add whatever you want as the links within the tab. As a bonus, you should even be able to then allow/hide the tab in the user settings/permissions. My post is a bit old, but I'd imagine it's all still…

Not in a spot to test anything for real, but a quick mock up should get the point across. SELECT InterfaceCaption ,CONCAT('Meow', 'Arf', 'Moo - ', InBps) AS [InBandwidth] FROM The.Land.Of.Interfaces ORDER BY InBps

@"dkeyser", unfortunately, I don't believe there is a cool formatting prefix for that, but that sounds like a feature request I'd sure vote for. In regards to sorting your SWQL query output, you should be able to sort by the actual column/field values (pre-concat), even if you're displaying something else entirely. Try…

@"patriot" Using the TOLOCAL, you just put that first, then put the date/time field in the parentheses directly afterwards. You'll probably need to assign an alias as well, but it can usually be the same name as the field, or completely different if you'd prefer. If you were going to put the "TriggeredDateTime" value from…