cnorborg · Network Professional IV · ✭✭✭✭✭

It's just you… 😋

Probably easier to download the agent and either deploy manually or via one of the mass deployment options (GPO, SCCM, or patchmanager). https://documentation.solarwinds.com/en/success_center/orionplatform/content/core-deploying-the-agent-manually-sw443.htm…

That's a longer answer! And, it should be in your PowerBI documentation. I would assume it would consist of creating a username in your Solarwinds SQL database for it to use, and then setting up PowerBI to use it. But, beyond that…

There should be logging on the AD controller that tells you why your credentials are failing? I've found quite often when dealing with AD, its the username format that I get wrong, not the password. Also, don't give Solarwinds admin credentials on your AD controller. All it needs is "Event Log Reader" permissions I…

The short answer is "yes". PowerBI is just a data visualization tool, Solarwinds is at its backend, a data gathering tool. The way to do it is to give PowerBI access to your SQL database, preferably read-only! That's where the short answer ends. For PowerBI to get the data out of Solarwinds that you want, and in a useful…

I'll believe it when I see it. (But hopefully will be retired before then!)

I'm guessing you just need to multiply the value by 100?, you can even do that in the SWQL query you used to get it.

Not sure? Might default to True in the websettings, without the value being present? You could always add it manually and see if it helps?

Sure, you can do AD based authentication on groups either via simple AD integration, or by using SAML. You give permissions to the group, just don't give them "Administrator Rights", one of the dropdowns near the top. Below that you can give them various permissions for each module, but without "Administrator Rights" they…

I prefer to do it like this: NOT ((Caption LIKE '%imbox%') OR (Caption LIKE '%atm%'))

So, UDT is actually quite simple and basic if you break it down into its components. The first part that needs to work right is getting the MAC addresses. For this, the device needs to be monitoring the right "Ports" from a discovery, as opposed to "Interfaces". If you added devices manually and didn't get the ports…

Netflow is not a lot of data, I wouldn't worry about it. But, if you really want to do so, just use Netflow to measure it!! 😁

Sounds like your trying to be a "Managed Service Provider"? https://www.solarwinds.com/partners/global-system-integrators

Oh wow, another discussion I was involved in, and from 10 years ago almost! Yea, I wouldn't advise to go cleaning the database yourself. Most likely, the actual issue is you need to look at other fields that you aren't yet looking at, to try and find something that differentiates between the duplicates. ie: in my…

As I noted, you'll have to adjust to your environment. Perhaps you need the ones with mask null instead of without? Or maybe you need both?

Sorry, had to modify your query to fit my environment, having no Fortigates (thank heaven!!) Pretty sure you can make it workable for you once again. First, I'd say try and simplify things. All 3 of the tables your working with have "Navigation Properties", or what I like to call implicit joins. Just look for the chain…

Nice! I did a minor improvement on it to remove one of the joins through the use of a "Navigation Property", or what I like to call an implicit join, which you can see by the chain icon in SWQL Studio. the AuditingArguments table is easily referenced by using the "Arguments" navigation property. Faster, more efficient,…

Maybe attend this class? https://thwack.solarwinds.com/discussion/151779/tired-of-the-sql-tuning-race-let-s-talk-query-optimization-on-march-10

Hmm… Not finding the option to do that on my PA's, maybe put this in as a feature request?

I'm assuming you mean where you put config backup files. It doesn't have to be on the same server, can you switch to using a file share on a file server and use a service account that has permissions there?

Most HSRP stuff is already polled within the tables already by Solarwinds. They don't usually do much with it, but you can find it there. Its in the Orion.NodeCdpEntry table. There is another table for LLDP also, Orion.NodeLldpEntry.

If you put on 3d glasses, or rose colored sunglasses, it changes them!! 😏

Yes, setting a static IP in DHCP is probably best…

Did you set the custom widget to not display if there isn't any data?

Couple things to check. Make sure your ports are monitored, the easiest way to monitor them is via a discovery job. But, you can check if they are in Settings / UDT Settings / Manage Ports. You can see what is configured for UDT here and if its missing anything, add it using a discovery job. You should also check to see…

Agreed, I wouldn't mess with the levels that much as it will greatly affect performance. Even to move the polling down to 1 minute for 250 interfaces will probably increase your load quite a bit. I think the default is 9 minutes. Increasing it like that is like putting 2250 interfaces on (9*250). Not to mention that's a…

Any firewall rules maybe? Worth a check…

If you do have nodes in NCM and that query still returns nothing. I'd check using both SWQL Studio, and I'd stick it in a resource on a page. Probably the easiest way to add a resource would be to go manage your Dashboard, and add either a modern or a classic dashboard. If Modern, you'd then want to add a widget and do a…

You are sure you have added nodes to NCM, and are downloading configs from them and such? You can have nodes in NPM, but not in NCM. If you go into "Edit Properties" or "Edit Node" on a node, then scroll down near the bottom, there is a dropdown box that says "Manage node(s) with NCM" that should be set to "Yes", and if so…

If your protocols are all set to "SSH" of some sort and not telnet, this query should give you a list of devices not using the global protocol. SELECT NP.Nodes.Caption FROM NCM.NodeProperties NP WHERE NOT ((NP.ExecProtocol = '${GlobalExecProtocol}') OR (NP.CommandProtocol = '${GlobalConfigRequestProtocol}') OR…