cscoengineer · Principal Consultant · ✭✭✭✭✭

The orion.nodes does not have datetime - it only has current stats. In order to access the historical cpu or memory, the CPULoadHistory table needs to be used. Here is a sample. SELECT n.[DisplayName] AS [DisplayName] ,n.[InstanceSiteID] AS [InstanceSiteID] ,n.[PercentMemoryUsed] AS [PercentMemoryUsed] FROM orion.nodes n…

I simplified the query and it's working for me. Your dataset might not be matching up One more thing - SWQL studio will work without an order. When you move the code to resource, you generally need an order statement at the end.

Any feedback from the team members?

Thanks for the information. But it seems recently almost all of the links don't work. Both of the links you have provides do not work.

No bug. But you may seen occastion data weirdness as these are just counters. When they overflow (return to zero), there might be a slight abnormal reading. But that should not happen often as they are 64 bit counters.

I would avoid the transforms and do the data manipulations in the custom SWQL. That way you have full control without the limitaions of transforms.

Great start. I generally start with isWAN - to let me know this is an edge interface connection. Then create a page just to monitor the isWAN=true. This incluses text as well as performance analyzer.

I would definitely use SWQL to get the information into a Custom Query. There aren't many resources you can put on a page related to NetPath

Depends on the polling IP. If the polling IP is a loopback, then it will find the best path to the device - even if the trunk is down.

Thanks Chad!!

@"aLTeReGo" - any idea on this? This issue has been going on for a while now. You had commented three years ago that it's being tracked internally as CORE-17163. Even with the EnableHtmlLinkSanitization turned off seems like users are still having issues. Custom HTML Widget (NOT WORKING)?? When I opened a case, I was told…

The EnableHtmlLinkSanitization is turned off (unchecked). Very first thing I did. There are some thwack articles recommending restarting services after the changes or even rebooting the server. Nothing worked and all new installations using custom html refuse to work. However, anything upgraded from prior versions (Orion…

Yes I do select DISTINCT n.Caption as [Node] ,n.DetailsURL as [_LinkFor_Node] ,'/Orion/images/StatusIcons/Small-' + n.StatusIcon AS [_IconFor_Node] ,tmp.data as [Free Stalls] ,tmp.detailsurl as [_linkfor_Free Stalls] ,case when tmp.data>tmp.ThresholdStatisticCritical then '/Orion/images/StatusIcons/Small-Critical.gif' when…

I remember using this a few years ago and it worked. But it's not working now. Is there an update to the script?

Thanks Marlie!! That's perfect for doing a handful of changes. However, doing 7000 volumes changes can be problematic. With the SQL script, it scales really well whether you're doing 10 or 1000. It would take less than a few seconds. The same goes for deleting volumes (I think I posted a SQL script for that as well).…

A widget can be very helpful and can be easily converted to a report ttps://thwack.solarwinds.com/product-forums/network-performance-monitor-npm/f/forum/91830/wireless-aps-swql https://thwack.solarwinds.com/product-forums/the-orion-platform/f/report-lab/91831/wireless-clients-swql Thank you, Amit Shah Loop1 Systems

You can use the OOTB or roll your own. I usually create a widget first to get near realtime information and then migrate the script to a report. https://thwack.solarwinds.com/product-forums/network-performance-monitor-npm/f/forum/38977/asa-details-swql Thank you, Amit

Got it to work using addday instead of weekdiff addday(-7,DATETRUNC('week',getdate())) - start of last week addday(0,DATETRUNC('week',getdate())) - end of last week thank you, Amit

didn't work for me I need to get the group member information for last week (Sunday-Saturday). Since my method isn't working. Do you know of any other way?

Not doing any comparison. Just need to get the starting of last week and pull some group member information. WHich is why I need to join it with the containermember.

I totally agree. 95% of the time I use SWQL. Sometimes I find that on more complicated queries, going through Information Service can be a bit slow and the widget timesouts. Whenever I want the fastest speed possible, I'll go the SQL route (taking into account that it does not use account limitations among other things).

You're right - it's simple enough for SNMPv2, but V3 is a bit more complicated. # Get a list of Cisco SNMPv1, SNMPV2 devices $ErrorActionPreference = 'Stop' Add-PSSnapin SwisSnapin $swis = Connect-Swis -Hostname x.x.x.x -Username xxx -Password xxx $query = "SELECT n.ip_address, n.Community, n.CustomProperties.Uri as [uri]…

In your interface object selection, why select it from a specific polling engine? I would remove that, so if you do have multiple engines and you need to move around nodes because of an engine failure, you can do it without having to worry about adjusting the alerts. You are also selecting different objects for trigger and…

Perfect!! Thanks KMSigma​ and tdanner​ Hopefully it will be fixed soon.

Great!! Thank you very much!!

It works when I run it in PowerShell window, but doesn't inside SAM. Does the module have to be copied into SAM somewhere?

It was off about 6 hours.

Had the same issue. Applied it - and it didn't work. When we checked it the next day - it was working. Really strange.

I have seen other people use traps on the edge network, specifically for bgp neighbor state changes. Source the traps from the inside interface and couple it with a ACL and it should work. -Amit Loop1 Systems Field Engineer

Great! Thanks and done.