wluther · Breaker of Things · ✭✭✭✭✭

Also, nothing fancy needed for the report options, other than grouping, and sorting (if it matters).

@"robert777" I think this might be something closer to what you're looking for, at least compared to the example I provided previously. SELECT DISTINCT n.Vendor ,CONCAT(n.Vendor,' (',[VendorCount].[VCount],')') AS [VendorTotals] ,n.MachineType ,CONCAT(n.MachineType,' (',[MachineTypeCount].[MCount],')') AS…

@"robert777" As Seashore said, you can use SWQL to do a simple count and push it into the caption, or wherever you want to show it. This is a wee bit inefficient, but figured it would get the point across. There are probably many ways to get this info, or something similar, into your report, but it depends on how detailed…

If you have already replaced the default fields with that data, you can sometimes, and very easily, just reference that data with a simple macro and lay it out however you want to in a HTML widget. SysName: ${SysName} Contact: ${Contact} EngineID: ${EngineID} LastBoot: ${LastBoot} LastSync: ${LastSync} Otherwise, since you…

This shows the same info, but polled via each method. You could get more specific if you drill down and filter the UnDP data by directly picking the named poller. SELECT CustomPollerName ,StatusDescription ,CurrentValue FROM Orion.NPM.CustomPollerAssignment WHERE NodeID=${NodeID}

@"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]