dgsmith80 · Monitoring Engineer · ✭✭✭✭✭

Hi @"tigger2" , So the change with the new Log Viewer / Analyzer is that everything is associated with the Node. So there is a system rule that discards messages from any device that is NOT in your Nodes table. I have found the best way around this is to add the device as an External Node. SolarWinds will not be polling…

If you are using Account Limitations to restrict what nodes are visible to the account, the Map should honour account limitations and hide any nodes that the account does not have access to view.

What condition is it that indicates to you that there has been an HA Failover? Is there a specific value in one of those UnDP Pollers you expect to see?

Your so close You need to select "Unique Name" and then the screen @"antonis.athanasiou" posted will show on your screen with the list of all your pollers.

I constantly have problems uploading Diagnostics and the like using the Serv-U as my Diagnostics files are sometimes anything from 100-500mb, but I have a PerfView dump that is over 1gb and it just refuses to complete. It's never been as good since they moved to Serv-U if I'm honest.

If all users connect via AD could there be a way to track it from the AD Server? Maybe something that ARM could help with :P

Well, firstly SolarWinds do NOT recommend running SolarWinds and SQL Database on the same server for any Production environments because of scale and resiliency. If you're considering HA then it already tells me you consider your platform necessary enough to make it resilient in which case you should STRONGLY consider…

I'm also now encountering this issue. The fix mentioned by @"dsimpkins" is the most logical, but my question to SolarWinds is still why this account was introduced and if it can be changed somewhere within the SolarWinds configuration. I have one client who do not allow local SQL accounts and we have an AD Service Account…

Hi Jason, I think the reason nobody has replied is that what you are asking isn't an easy task, in fact, I would wager that the combination of those fields might be impossible due to the nature of the difference between Average Availability vs Individual Events I tried loading the report on my own platform and it doesn't…

I'm confused why you're trying to recreate fields from a report that has already been linked above. https://thwack.solarwinds.com/content-exchange/the-orion-platform/m/reports/3003 already has all the fields you desire? It might be easier to edit that report to add any missing fields as the fields your asking to add to…

This is by design I'm afraid. The legacy SNMP Trap Viewer & Syslog Viewer applications were retired in favour of the new Log Analyzer (Also known as OLV). And as you rightly said the ability to "tag" messages via Rule actions is an advanced feature so only available with the full paid version. 

Hi Jason, As your looking across multiple vendors you need to change the selection criteria, the following will select any Cisco OR Meraki that is Down OR Unknown As a side note looking at some of the posts above you seem to have a Custom Property that contains the description of "Store Router" if you want to filter on…

If you add in the DateTime field to your query you can use the Time-Based Settings in your report. SELECT [Nodes].CustomProperties.AvailabilityReportingGroups AS [Team] , [Nodes].Caption AS [Node Name] , CONCAT(ROUND(AVG( [Nodes].ResponseTimeHistory.Availability ), 2), '%') as [Avail] ,[Nodes].ResponseTimeHistory.DateTime…

No worries - For the record, I'm using it on the latest version and it's still working. But yes it is an un-supported change that I have to replace if/when we rebuild or upgrade so I appreciate your point.

Or you could look at something like this: thwack.solarwinds.com/.../114843

If I understand your request correctly; then you just need 'SELECT TOP 1' at the start of your query.

That would be via a "Feature Request" - thwack.solarwinds.com/.../feature-requests

SELECT Count(N.NodeID) AS [UK] FROM Orion.Nodes N WHERE N.Status = '2' AND N.CustomProperties.AssetTag LIKE 'Store Router' AND (N.Caption LIKE '3%' OR N.Caption LIKE '4%') As your doing an OR as well as an AND in your WHERE statement you just need to break it up. The (brackets) means it first looks for the 3% OR 4% in the…

So it looks like this too has been broken by the latest SolarWinds update - In SolarWinds wisdom, they decided that Event Log data pertaining to Database Maintenance is Administrator only!! 

Excellent then yes it's much easier. Basically '9%' becomes any word beginning with 9. So '3%' for UK, '5%' for ROI etc SELECT Count(N.NodeID) as [NL] FROM Orion.Nodes N WHERE N.Caption like '9%' AND N.Status = '2' AND N.CustomProperties.AssetTag like 'Store Router'

Is the 9 always the first character of the hostname or is it xxx907xxx etc? If it's always the 4th letter in the hostname or can it vary? Is it always 4 digits in the hostname like 9000 - 9999 or 3024 etc

Can you expand on what you mean? Maybe with an example of the output hostname?

SELECT Count(N.nodeid) AS [UK] FROM Orion.Nodes N WHERE N.CustomProperties.Country = 'UK' AND N.Status=2

I think your first task is to find a way to clearly identify the location of each device in your environment. I've found naming convention to be a very unreliable method as there are various iterations of naming standards across the years. Once you have a solid method of identifying the devices you can use that method to…

Thanks both - I'll take a look. The biggest blocker for me is that a majority of the engineers running these checks won't have admin access in SolarWinds and they don't have the ability to edit reports. So it has to be automatically generated and they just either browse to a file or export a report etc. 

Is anyone else having issues with non-admins being able to view this page since the latest update? I've been using a similar SWQL Query on our NOC Dashboards for over a year but recently it stopped working. It now only shows users devices they have personally put into maintenance..... Which is useless.

Good Luck, it might be a bit late for you as it sounds like the train already left the station, but if you can think about what other custom properties might help you later on down the line and set them up now and start populating them as you build up the platform it will save you a lot of headaches later. Try to keep…

So as per previous posts, I would say that Custom Properties are your friend here. If you have an Upper and Lower limit, you can define those in a CP. I use the CriticalValue setting rather than a fixed value in my example. Typically my team want to know about Response Time spikes, but I've shown an example of how the…

Can't agree more with what @"mesverrum" already said. First step is to create those custom properties so you have a clear way to identify which interfaces are part of a Failover Group, and then you could also consider marking it as Active/Standby so you know which interfaces are the ones that should always be Up, and which…

If you want a Modern Dashboard Widget for your Poller Table you could do something like these: SELECT [E].ServerName AS [Poller], -- List the Name of your Polling Enginers [E].Elements AS [Element_Count] -- The Total Element Count of each Polling Engine FROM Orion.Engines [E] LEFT JOIN Orion.Nodes [N] ON [E].ServerName =…