wesleykparker · Senior Network Engineer · ✭✭✭✭✭

This is an old feature request, but I ran into the trouble today and saw no responses with a search that addressed it. I've found that you can't use the SUBSTRING feature in a "Custom Query" resource unless you use an "ORDER BY" statement. If there is no "ORDER BY" then the query will not run even if you have commented out…

You hopefully already figured this out. But the approach proposed by @"cnorborg" is the way that i would do it. Shouldn't be difficult. A custom SWQL alert for nodes that looks like the following should do the trick. Use the built in alerting features in alert builder to set how long the status must be active to achieve…

Are you trying to get serial numbers for your stackmembers? There is the table Orion.NPM.SwitchStackMember that contains these. You will have to make sure you have the swtichstack poller applied to all the devices you want this to work on.

I don’t believe there is functionality like that with a Custom Query Widget. I’m pretty sure it’s possible to do the reverse, as in use SWQL queries within HTML widgets, but I don’t really have any experience writing HTML so I don’t use those generally. You could use the “_icon_for_<query field>” functions to link a…

The “Custom Query” widget. This is the widge type I I use most. You can usually get to about 80% as nice as the built in widgets with these and can manipulate data however you like.

I cut this from a custom widget I use to monitor software versions. I edited it a little to try to make it manageable. Also, sorry if it is not in proper form...I'm definitely a makeshift SWQL user. This isn't the most efficient code block, but I usually write my custom queries like this because it makes it easier to…

Your query works fine in my environment. I'd start by checking the NCM.TransferResults table and seeing if your entries are in there. Also, if you navigate to the Transfer Results page in NCM, does it show the transfers you are looking for there? If they are, then I would look to see if maybe you've deleted the nodes that…

First off, i'd check this link for how to use the Device command templates. I think you have a fundamental misunderstanding of what is going on. Create and manage device templates (solarwinds.com) I don't have a Ubiquiti switch to test with, but I can see plenty of issues with your config above. #1 you need to change the…

I don't see a reason why your rule shouldn't work if it truly is configured as above. I can offer this though. If you use the following string and change your String Type to Regex, you would only need one line. I know sometimes it gets confusing about whether to use AND or OR, especially when doing negative lookups. This…

Here's a revised query. This can be used on a dashboard view to see all APs on all WLCs or can be added to a Node view page for the WLC to see only the APs on that controller. It's also fully searchable. SELECT wap.DisplayName as [AP Name], CONCAT('/Orion/Wireless/ThinAccessPointDetailsView.aspx?NetObject=WLTAP:',wap.ID)…

One poller for each. [View:/cfs-file/__key/communityserver-discussions-components-files/4/Cisco-WLC-Serials-and-Models.UnDP:640:480]

Here's a SWQL query I made that integrates model and serial info for you Cisco APs. Obviously you can modify the columns of the table as you want. I just left all the standard tables in for this. You have to add custom pollers to your WLCs for the following OIDs. 1.3.6.1.4.1.14179.2.2.1.1.17 - Serial…

Doubt you are still looking for this, but I threw this query together to see what creds are assigned. You could run it in a report or use SWQL Studio. If you haven't downloaded SWQL Studio and you manage you Solarwinds Environment in any way, you should go ahead and download it. SELECT v3.Node.Caption, NodeID, ROCred.Name…

This is probably too late, but there is a resource called "Multiple Universal Device Pollers Chart". This is designed to do match on one UnDP that is on multiple nodes. Multiple Universal Device Pollers Chart On a single chart: Graph and sum the results of a single Universal Device Poller for multiple nodes Graph the…

Well, my case is still open so I haven't gone "nuclear" yet. I'm not a DBA, so I'm not super comfortable changing out things with the DB. I know that my test view runs in the Database Manager, so I assume it would fix the real view if I were to modify it. But, since that would be a fix that would get undone any time I ran…

I checked one of my canned Alerts that include the device name and it used the following: ${N=SwisEntity;M=DisplayName} I also use this trick in order to peel of the domain part of the FQDN. This works as long as you have no periods in your device name. In my case, a few of our nodes are in by IP address, so the statement…

This is what I use in a Widget, there are some statements you could adjust if you wanted a longer report. SELECT users.Username, SUM(users.Duration) as [Connected Time], COUNT(users.Username) AS [Times Connected], MAX(users.[Last Connection]) as [Last Connection], ROUND(SUM(users.InTotalBytes)/1000000,2) AS [In…

I've noticed you've posted this a few times while searching for WLC issues. I believe this behavior is due to this global setting "RemoveDisappearedAPs" being set to default. The default action is for Solarwinds to delete APs from the database once they disappear from a controller. I usually change this setting to not…

Thanks for the reply. I eventually worked around this issue by removing the complex table headers and putting fillers in (ex. Column_1, Column_2 etc...) and then replacing the column names in the report generator where you can define the columns. 

If you are mirroring the alert from above posted by dzastrow, you can group pollers by adding more Match statements in the "Alert on objects where" clause. Alert on all objects where: Wireless Access Point - Controller Name - is equal to - zelle-wlc01 Could be something like: Alert on all objects where At least one child…

I created a new view in my DB called NCM.Nodes_test. I made my changes and then re-added the DB to the Database manager application. My test view runs fine. 

My ticket is still open. They say their lab environment doesn't have the same issue. They asked me to re-run the installation wizard. This did not fix our issue. Waiting for them on having someone look at our installation.

I've located the source of the trouble. The query to create the NCM_Nodes view has a problem. The query runs in SQL Studio but flags for the same issue as why the Database Manager errors and displays no output. I was able to fix the query for the View, but haven't implemented the changes in our DB until I hear back from…

More research shows that the issue is with the following columns in the NCM_Nodes view. I"m going to see if I can trace back. Maybe we have some sort of weird credential that is triggering this. -- ,[SNMPContext] -- ,[SNMPUsername] -- ,[SNMPAuthType] -- ,[SNMPAuthPass] -- ,[SNMPAuthKeyIsPass] -- ,[SNMPEncryptType] --…

Was looking for some related data and saw your question. I've run into this before. Here is how I work around it. Use your option 2 with the custom SWQL as the datasource. Add another column to your query to use as the Legend. I would use something like "'on UPS' as Legend" SELECT m.PowerControlUnit.Node.NodeId, ElementId,…

This exact issue has been solved previously. I've added the link to that post below. I tested on my system and works fine. In addition to that solution, this is how i do it. If you use NCM in your environment, you can also query the column "Model" in the table "Orion.HardwareHealth.HardwareInfoBase" or in SWIS the shortcut…

I've had trouble in the past with the "Credential Set Library" messing up any manually entered settings. Because of this I've been religious about making sure no one adds new credentials that aren't supposed to be there. This can happen automatically when adding a node and changing any setting in the snmpv3 credentials…

This is something i've been working on today as well. Are you saying that the graph that comes out on the node details page looks correct? Are you transforming that poller? I talked to my telecom engineer and he says that the output of that OID needs to be divided by 2 to get an accurate reflection of calls. Not sure why…

I made this custom query for my Node details pages. I'm sure it's not as cool as the Solarwinds built in widget will be, because I don't really know anything about html. SELECT TOP 100 -- Edit this number for how many messages you want to load to widget (you can modify the widget for how many messages to page) let.Name AS…

The variable you are looking for is ${AgentIP} :log warning "Script Test Start" :log warning "Node IP is ${AgentIP}" :log warning "Script Test End" I don't remember if I've found the published SW docs on that, but this thread has some old stuff in it. Looking for list of NCM variables