zackm ✭✭✭✭✭

sorry, I was away on PTO for a bit. without the UDT (User Device Tracker) module; the only accurate way to get a report like this would be to have NPM monitor every single physical interface on your devices. The issue being that the products you own are not designed to meet your needs in this situation. This is 100% in the…

Try this one out: DECLARE @startOfPreviousMonth DATETIME = DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE())-1, 0) DECLARE @startOfCurrentMonth DATETIME = DATEADD(month, DATEDIFF(MONTH, 0, CURRENT_TIMESTAMP), 0) DECLARE @lastSevenDays DATETIME = DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE())-7, 0) SELECT DISTINCT ahv.Name 'Alert…

maybe try changing the joins to a FULL OUTER JOIN type? I can look later, a bit swamped atm.

Hey fitzy141​!!! So good and bad news... Good: You were right on point with your report creation. Bad: Your requested dates are too far back to show the data you want given the default data rollup periods in SolarWinds NPM. * Detail Data (every single data point for a metric) is kept for the last 7 days * Hourly Data…

So, specifically for custom properties set up for Nodes; you should double check and make sure you have them enabled for use throughout your environment. You can technically limit them down, which can cause what you are seeing. Though I don't know why you would want to (but that's another post). However, all other custom…

Yes, it should be a GROUP BY. However, GROUP BY statements go above ORDER BY statements.

I just tested this in NPM 10.6 and it is working for me. Can you try this in SQL? SELECT Caption, LastSystemUpTimePollUTCFROM NodesWHERE Status = 2 That is the quantifier for this report. (Status = 2 is DOWN) If that returns no results, then you will get an empty report. If that does return results, then something might be…

UnDP = Universal Device Poller. By default, SolarWinds only has information (MIBs) for XX number of devices. One of the strongest features of SolarWinds is the ability for anyone to create new pollers for almost any device by using the UnDP to make device-specific pollers. I would highly recommend a look at this section of…

a screenshot would be best for sure. without seeing all the details, it's hard to answer why the report is acting that way. have you tried to create a table using the same selection criteria to see if the missing nodes are just hidden from the chart?

If you combine this with the Network QoE sensor form NPM 11, you should easily be able to identify exactly what you are looking for. NTA will give you packet header information, specifically the 7 key fields outlined by NetFlow v5. * Source IP Address * Destination IP Address * Source Port Number * Destination Port Number…

How long does that same query take to execute in SWQL Studio?

Can you explain a bit more on your goal for that one? I am a little confused on what you are asking. (sorry)

to clarify, meaning that there's an internal issue tracking this bug because it shouldn't require node management rights, but it currently does requires those rights in the present state? or am I reading that wrong?

You can add Custom Properties via the GUI then; when you click "Insert Variable", you just have to find the correct drop down combination.

you might put in a ticket to support on this one. I am not getting the errors you are seeing on this end.

Sorry about that, I misread your original post. I thought you wanted the % of polls that were outisde of the SLA thresholds. This one should work. As to why you were still seeing other IP SLA Operations, on the last line, you need to remove the '--', this is a line comment marker in SQL (like # in PowerShell) SELECT…

you might need to open a case on this one with Tech Support. The underscore is used as a wildcard in SQL, so it might be causing issues because you cannot escape it. You can try to use a backslack ( \ ) to escape the character, but I don't know how that would interact in the web report engine to be honest.

that's just a warning that your original data set had NULL values in it that were removed during the aggregate functions. basically, in the joining of InterfaceTraffic to Interfaces to Nodes, there were columns with NULL values; but after the SELECT clause finished, the NULL values were eliminated from the final results…

Gotcha. Basically, your best option would be to take an existin report and modify it. SolarWinds comes with a built-in report called "95th Percentile Traffic Rate - Last 7 Days'. If you take the raw SQL out of that report, you can modify it to show you the last 30 days as seen below: SET NOCOUNT OFFSET ROWCOUNT 0DECLARE…

oh yeah, that's totally do-able with the right server(s). I'm agreeing with your comment about using a custom property for identifying specific interfaces to change the interval on instead of changing the default interval for all interfaces.

Can you verify a particular node/port combo where you know for sure the interface is "Up/Down"? I know for us, all unused interfaces would be placed in Admin down status. With this query/report, we are only listing devices that are Up/Down. Past that, it would be up to the engineer to identify ports that actually have…

Try ${Node.IP_Address}

What are your installed software modules and versions? (You should be able to get a full list at the footer of your SolarWinds website)

You could try these: SQL for All Alerts per Object: SELECT Name 'Alert Name' ,EntityCaption 'Object of Alert' ,COUNT(1) 'Times Alert Triggered'FROM AlertHistoryViewWHERE EventTypeWord = 'Triggered'AND TimeStamp > (GETDATE()-1)GROUP BY Name, EntityCaption SQL for All Alerts: SELECT Name 'Alert Name' ,COUNT(1) 'Times Alert…

The first thing I would do is enable some more traps to see if the issue is with sending the traps or receiving them. In other words, if you can receive any traps from your router, then you have confirmed communication across UDP Port 162 (default). Once you have confirmed this, then you can try and narrow down a potential…

you only have ingress turned on for gig0/0/0. you would need to enable egress as well to get your chart to have the 'both' option.

What OID are you using to get these results?

Actually, it probably would. Let me work on some lab stuff and see if I can get an example of a work-around.

One thing to note; I noticed when I was creating this that the "Available Space" column did not show in my initial report. Check your column widths! (Took me a few minutes to see that the default for the report is 'Custom') This is from http://oriondemo.solarwinds.com/ to ensure it is the default report that comes out of…

#ChallengeAccepted jbiggley​ and I will have to talk about this in a few months time.