Daran · Global Network Manager · ✭✭✭✭✭

Hi @"bobmarley" I like the sound of some of this - what is the "rundeck job" and also could you share the code for the rule that deletes unmanaged/muted nodes? We are using SW as the source of truth for feeding into ServiceNow CMDB for network inventory so I'd be interested to hear what discovery jobs you have running?

Kindly state what make and model of AP...

Perhaps it is a version issue? We are on 2025.1.1 and it is definitely wortking for us (Until I saw your post, we were using a Custom SWQL query to display a link to the relevant map as I didn't know that this option was even available - so thanks for increasing my knowledge and hope you get yours fixed soon!!

I just tried this and it works perfectly for me... We use Groups for each site and have a map for each site. I added the Map widget to the Group view and then chose the Map Name Format as ${Name}. The interesting thing is that when I edit the Map widget, sometimes this "Map Name Format" box is there and sometimes it…

I think that number relates to the amount of data SW trties to get from the back-end databse in one go and has nothing to do with the MTU default packet size of the network.

Actually, I may have got that slightly wrong... you may need to look at this page: ...

You don't need a script - just go here and set your retention values to what you need...

Perfect - thanks!

 @"tobyw_loop1" this is very useful thanks. I've struggled to find what I am looking for in the DB at times and trawling through SWQL studio can be painful. Looking at this schema page is a lot easier... Question: - What would you typically use the Swagger page for? I mean it looks impressive and comprehensive, but what…

I wrote a custom poller to grab the serial number from Aerohive AP's - I am pretty certain you could do the same for a MAC address from an Aruba switch if you have the OID. this is the SQL to grab the info into a custom query - just adjust for the MAC address. SELECT n.NodeID, n.Caption, n.Status, cps.Status AS…

I have a search working in this query... give it a try:

Hi, this is probably a good start for what you're looking for: SELECT ReportJobID, Name, Description, Enabled, AccountID, LastRun, WebsiteID, SchedulesData, ActionsData, ReportsData, UrlData, ActionTitles, ReportTitles, FrequencyTitle, DisplayName, InstanceType, Uri, InstanceSiteId FROM Orion.ReportJobs

I'd be interested to see this too...

yes unfortunately I tend to have the same experience with chatgpt - it is good as a starting point but then you wast a day of two going down blind alleys trying queries to non-existent tables/fields... apologies but it was worth a shot.

chatgpt suggested something like this... SELECT n.NodeID, n.Caption, n.IP_Address, MAX(CASE WHEN AssignmentName LIKE '%avAesTsapiLicenseTotal%' THEN CurrentValue END) AS TotalLicenses, MAX(CASE WHEN AssignmentName LIKE '%avAesTsapiLicenseAcquired%' THEN CurrentValue END) AS UtilizedLicenses, -- Newly added available…

If SW is saying is it down then SW is doing it's job and you should be investigating why it is saying it is down - you could try the following to get a bit more info... SELECT n.NodeID, n.DisplayName, n.IPAddress, n.Status AS NodeStatus, n.StatusDescription, n.ObjectSubType, n.LastSync AS LastPolled, n.DetailsUrl FROM…

Try putting this SWQL into a Custom Query widget on your web console: SELECT NodeID, DisplayName, IPAddress, CASE WHEN ObjectSubType = 'SNMP' THEN 'SNMP' WHEN ObjectSubType = 'ICMP' THEN 'ICMP (Ping Only)' ELSE 'Unknown' END AS PollingMethod, LastSync AS LastPolled FROM Orion.Nodes ORDER BY PollingMethod, DisplayName

If you only need it daily then try one of these: They seem to have timestamps. Other than that, raise a support query.

I think you're probably looking for this value from these two tables:

not quite - I was logged into the actual orion server and was using the Database Manager to look at the various tables... I'm not sure what you mean by views... This query shows all of the fields for the out% utilisation.

These look to be all of the fields for "in" utilisation": SELECT TOP 1000 * FROM [dbo].[InterfacesInPercentUtilization] and similarly for "out": SELECT TOP 1000 * FROM [dbo].[InterfacesOutPercentUtilization] Or just get them to explore these tables: Hope that helps. Daran.

I think this is the older way of doing it but you can use these variables: https://documentation.solarwinds.com/en/success_center/orionplatform/content/core-interface-variables-sw3455.htm e.g. ${InPercentUtil} and ${OutPercentUtil} Or something like this: Interface ${NetObjectName} on ${NodeName} received at…

Thanks all - I raised a case with Support and they were able to resolve my issue. It looks like the alert variable that @"chad.every" mentioned does work after all. I tried it on numerous occasions and in various formats but it wasn't evaluating at all... see below (line above the circled text) as I am pretty sure the…

I am trying to get the original syslog message content into an alert action - I've tried using the macro suggested above and in the article and it does not work. I have raised a support case for this.

Hi @"longct1" - I too have this problem and would be interested to know how you solve it... I need the syslog message content in the Alert Manager so I can parse it!! Thanks in advance.

I've already tried that one and it doesn't evaluate :(

We too are having a bad experience currently! - We spent a lot of time documenting and commenting on over 22,000 CVEs in the SW Compliance area and use this as part of our Audit compliance regime. We were recently called out for using a particular switch IOS and wanted to refer to this work only to find that the entire CVE…

Hi @"BaldFeegle" , we had the same issue and to get around this I created a custom property for the Groups and added the following trigger condition: As long as the engineers remember to set the custom property to Yes/True/1, the group alerts don't fire. I also added a simple widget to the Home page so you can see at a…

Hi @"kpmarcin" - I have implemented your userlinks for both Node and Interface dynamic perf charts - they are great. However, I noticed in your video, that you hover over the config changes and are able to drill into the actual configs... when I try this it shows that say 2 config changes have been made, but as soon as…

Thanks!