mesverrum · Observability Architect · ✭✭✭✭✭

Haha I didn't notice until after I commented, you were in fact the last client I worked on this with.

The capability was added to the GUI in NPM 12 see this KB on how to do them, Business hours in the web-based Report Manager - SolarWinds Worldwide, LLC. Help and Support -Marc Netterfield Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook: Loop1 Systems * Twitter: @Loop1Systems

This is a bug I've seen a couple times in the newer releases. Run a config wizard on your server and it should fill in your list with hundreds of widgets.

You will want to summarize it so the statistic is a count of every down service and the message is a concatenated list of them

That's going to be an issue with how that specific model responds to the standard snmp values for interface description and alias. Some models just don't give up the information one would expect.

Doesn't this wlc report on the thin aps connected to it? Each thin ap would have a list of clients connected and it would be fairly straightforward to build a query that counts the number of clients on a specific ssid across all aps

1 minute intervals is pretty high frequency (default is 9 minutes for interface stats) so I'm not shocked that the tables are large, I would expect that the times where it comes back quickly are when the data you need is still freshly cached either in IIS or on the SQL side in memory and not on disk from other things that…

Yeah I feel like the new Ipam features did not get the ux treatment they deserved. I find that clients who make use of Ipam REALLY use it and end up with hundreds of subnets easily so making sure the screens allow for bulk operations is pretty important.

Good to know about that, i ran into the same issue this week and just moved the second addresses to the CC box as an interim solution

all you can do is break them up. If you can't get a more narrowly scoped list of subnets then if it was me I would just write a script to do build discoveries in batches. Maybe something like break the /16 into many /22's and after that completes have it build a new discovery with the next /22. I expect it will take a long…

From here my guess would be that the status you are displaying is not the individual sensor status but instead is maybe the overall status for the node hardware. Sometimes it can be a pain to hunt down the status you want when the gui shows 8 different kinds of status objects.

You were definitely over complicating this, but if you don't know SQL you wouldn't know what you need and what's irrelevant. First of all you don't want this to be a node alert, it should be an interface alert on the interface that breached the threshold. Like I mentioned initially, this query might time out in a big…

Asset Inventory does not collect a timestamp for the last logged in user. You could potentially collect that information from a SAM event monitor looking for event 4624 I just set up a template and it looks like doing an event monitor like this would collect that info, then you just need to build a report to show the…

I would say that despite his feeling that bitwise values are ubiquitous in snmp responses I have to admit I do this all day for a living and extremely rarely encounter snmp responses that anyone wants to monitor that aren't text strings or integers. I would say it hasn't been common enough that anyone at solarwinds deemed…

The reason I suggested you make the change inside the alertconfiguration is first of all because alertactive is not editable in the API, so its a non-starter right out of the gate. If you wanted to change a message you need to change the alertconfiguration before the event actually happens. If you did manage to edit the…

Is your transmit and receive percent utilization pulling from the historical traffic section or the current stats?

Netpath requirements are outlined here NetPath requirements - SolarWinds Worldwide, LLC. Help and Support Here is an overview of Cisco IP SLA (this feature depends on your hardware supporting it and having the correct licenses from cisco, most routers have it and most newer switches can at least be configured as a…

I believe those are based on this post from one of my colleagues Scoreboard

To get to your specific point about changing the URL that comes across in the email alerts, see this KB article Configure website URL for Alerts and Reports - SolarWinds Worldwide, LLC. Help and Support I second the other recommendations to be very careful about exposing the orion server itself to the public internet…

Good point, if you are going to be filtering in more than one or two alert's it makes more sense to reference a property. When I actually use this script I am usually filtering against alerts on certain object types, typically excluding all the orion.vim.xx object types from app team dashboards since they don't normally…

Helps if you know SWQL, but basically if you see an alert that you want to exclude from a view you just change the where condition to where o.AlertConfigurations.Name not like 'Alert I want to hide' and o.AlertConfigurations.Name not like 'second alert I want to hide' You can get a lot more elaborate than that if you are…

Disregard, didn't notice this was in the LEM forum, i posted info about how this is done using NPM/SAM.

It would appear that PowerBI can be connected to Postgres Configuring Power BI Connectivity to PostgreSQL Database - oxcrx34285 Your team mate would likely be on their own to reverse engineer the tables and such to find what they want to display but if they want to do the leg work it can be done. 

Yeah, i've got a client who does a lot of customization and they run a powershell script on a windows scheduled task every few minutes to check for the path and if it is missing create a pointer in inetpub for all their custom php and stuff when it gets deleted during CW. Very effortless that way.

Mine works like this,

Find and replace City with your property select n.customproperties.City, count(n.nodeid) as Total, isnull(down.total,0) as Down, round((isnull(down.total,0)*1.0/count(n.nodeid)),2) as DownPercent from orion.nodes n left join ( select count(n.nodeid) as Total, n.customproperties.City from orion.nodes n where n.status=2…

Ah you are using the wizard, that's the long way around for this you just want to hit Manage applications from the main SAM page That should get you about to where I was point you

The powershell monitors can run locally from the orion server, or they can run remotely where orion uses powershell remote execution to run them on the node you assign the template to. Create a Windows PowerShell monitor​ also these articles may help The Basics of PowerShell (part 1) The Basics of PowerShell (part 2) The…

The syslog trap viewer alerts are also in the db so I would expect you should be okay there as well.

The resource is just the Custom Query resource