sum_giais

That said though, have you tried using Modern Dashboards? Personally I don't use custom HTML widgets because they aren't available in modern dashboards (not clear if it ever will be..) and due to their security concerns.

I use Visual Studio Code myself... but if you haven't done so yet, I'd recommend creating a custom view -- "Scratch View" if you will where you can sandbox your HTML in SolarWinds. There's also plenty of web html IDE's out there, it's not perfect but sometimes I'll use www.w3schools.com/.../tryit.asp

Hi @"patriot", I believe @"KMSigma.SWI" is noting that the order of your BETWEEN statement is wrong. E.g. it should follow this format: AND <datetime-field> BETWEEN AND <newerdate>. Currently you have it like this: AND <datetime-field> BETWEEN <newerdate> AND Does that make sense and help clarify? So it should be adjusted…

Hi @"calc2014" I think @"ultrapep" is looking to deny accessing the server directly via its serverside IP address, not a specific client source.

If I could make a good opsec recommendation... edit your last post and either remove the photo or blur/black out your address bar and logos etc.

I've seen this issue as well, I *believe* I put in a support case and brought it up as a bug. Modern Dashboards don't take into account custom thresholds of any kind. Either way I'd recommend putting in a support case for it, the more customers reporting the same issue the better.

Are you trying to stop users from accessing the site via https://127.0.0.1 for example, and only permit https://mysite.local? Honestly I'm not too familiar with SERV-U FTP but normally I would think of using IIS URL Rewrite for this. But I'm not sure what this product uses for its web server. That would determine your…

Welp, dumb question. Is the SQL monitor for that database running? Are these reports working for other databases?

To display it in local time you need to change the select for the date to: ToLocal(StartTime.EventTime) AS DownTime

Can you post your edited query? What I posted ealier all you should have to do to limit it to 'ACME Bird Seed' is remove the double dashes on line 19. Are you adding another AND?

[quote userid="99062" url="~/product-forums/the-orion-platform/f/report-lab/96076/i-give-up-on-swql-joins/303174#303174"]An implicit JOIN in SWQL is kind of like connect the dots, so to speak[/quote]Well said @"wluther"! Just to expand on that, SWQL converts everything to SQL under the hood, and using the dot notation…

Both the WHERE MONTHDIFF portions. SWQL also has a BETWEEN function if you wanted to replace those sections yourself. I'll just add this in here: github.com/.../SWQL-Functions

I haven't tested this but I have a theory that this may be syntax related. Lots of things you can do in native SQL / SSMS aren't always permitted inside various functions in SolarWinds. It may be worth structuring the query with proper SELECT X FROM Y format with what you have as a subquery. Something like: SELECT TOP 1…

Should be the last 3 months but if thats not what you see its an easy adjustement in 2 places of the query...

What if you delete all the columns and re-add them? Typically thats due to mismatching column names likely a result of updating the datasource to swql

Hi @"jamshad2712", Below is your query adjusted to include another column "Critical", cheers. SELECT n.Vendor ,COUNT(CASE WHEN n.Status = 1 THEN 1 END) AS [Up] ,COUNT(CASE WHEN n.Status = 2 THEN 1 END) AS [Down] ,COUNT(CASE WHEN n.Status = 3 THEN 1 END) AS [Warning] ,COUNT(CASE WHEN n.Status = 4 THEN 1 END) AS [Critical]…

Hi @"patriot", I made an attempt at converting this query over to SWQL. I'm not entirely sure it is going to provide the same output and work in the same manner that you may expect so I'll ask if you could give it a test and let us know. I didn't go so far as to make the SQL query work in my environment so wasn't able to…

Good point @"shuth" I didn't think about that and assumed the source as the network source lol. Yeah this sounds like a limitation with Log Analyzer that wasn't there with the legacy trap/syslog functionality I didn't think. If I find anything on that I'll relay it

I'm not familiar with sending traps some DPA myself but am with DPA alerting. Could the DPA trap send additional data in the trap that could then be ingested in Orion, and perhaps relayed to ServiceNow as a result? Just scratching the surface here but reviewing the documentation it does appear that the following fields are…

It just has to be a numeric int, single column with a single row return if no message... but have you tested your sql query in something like SSMS, or Orions Database Manager (I see its querying the SolarWinds database it appears) Knowing that I usually force it to a SELECT TOP 1 so there's no way it will return more if…

cool sounds good... thank me when it works LOL I think the only catch with this is, unless you limit the alert to a specific node or poller you are going to end up with an alert on both (2x alerts) because they both will have a difference > 0 no matter what way you look at it. Is that the desired result? Thats more a…

Are you using the "No polling engine update in last 10 minutes" alert? If you go into Manage Alerts under Settings, there's a canned alert definition for this that you could enable. Another canned one which is good is "Node polling failed on last 5 tries". Contrary to what it says -- it typically means a problem with the…

Hey @"greg.remer", I think this may be of some help for you. Find the CustomPollerID's of those pollers using the 1st query below (not the CustomPollerAssignmentID's), and then update the 2nd query appropriately on lines 8, 9 and 10. The CustomPollerID of snChasUnitActualTemperature should go in line 8 for the first INNER…

Ok, I think I have something that you could work with. So this query is something that will need to be tailored to your environment so I'll provide you some steps to do so... * Use the 1st query to find the 2 unique CustomPollerAssignmentID's for each poller * Use the 1st query to find the RowID for the poller (since this…

Thought I was the only one or going crazy, phew!

So I can explore how I might approach this. To be honest though -- more work to be done here and I am left with more questions but I need to shift my focus. Question 1: Are the 2 pollers you show in your screenshot the only 2 pollers you need to alert on this for? I ask because that would change the approach. * Because the…

So if you're using a custom SWQL alert, you may have noticed the SELECT portion gets predefined for you so a CASE statement would only be helpful if using it in a subquery or join etc. The conditions you need are fairly simple it seems but I have one question. Do you need an alert when the top row records value (current…

Not trying to convince you one way or the other... but I do think it's worth noting that is an old thread and not really necessary to go to that length I don't believe. There's fully supported methods to do what's mentioned in that thread. I'm not sure when SolarWinds implemented the ability to "Allow HTML Tags" in columns…

That said... I would really want to know more before doing that myself

What fields are you referring to specifically? Without knowing more its hard to recommend a path towards resolution. What steps have been taken if any thus far by yourself / support? You could suggest if this may be of use and/or be an issue... but I find that clearing the information service subscriptions along with…