Seashore · Solutions Architect · ✭✭✭✭✭

Use a http or https SAM component. https://documentation.solarwinds.com/en/success_center/sam/content/sam-http-monitor-sw3242.htm

Have you tried running the script outside of SAM first? It's easier to see potential issues outside of SAM, in a normal powershell session.

On each alert rule you have a trigger condition and a reset condition. The alert gets triggered and shows up under active alerts when the trigger condition applies, and is removed again when the reset condition is true. Check what that condition is in the alert rule and if it is true for the alerts that does not reset.…

The issue here is that the output from the case part can be a mix of string and integer. If AC.Severity is 1 or 2 you get a string. Else you get an integer. You are not allowed to mix that in one column. So you have to turn the integer to a string with ToString(). Like this: , CASE When AC.Severity=1 then 'Warning' When…

You don't NEED a new mib for NPM to work. Everything will work without the specific mib file. But, it will sometimes be easier if you have the correct mib within NPM. Many mib's are already in NPM and new once are added every month. The process can be read about here:…

Ok, my last idéa. There is a tool on the orion-server called "PermissionChecker". Checks that all the permissions on the actual orion server is correct. You can try that, otherwise I would suggest a support call…

Ok, then it's not that bug. Just tested myself on the same version and that worked. Do you have permission to all networks and addresses on that network?

What version are you using? If I remember correct there was a bug about that a couple of years ago.

Hi, below code was written for a custom query widget, to display both nodes, volumes, interfaces and application in maintenance mode, both unmanaged and muted. There is comments there to show what parts is for what type of entity. Take the parts you want from it: (Sometimes the correct ActionTypeID's are different on…

Hi If you want to display the vendor icon in the report, you have to include that in the dataset, the query. Otherwise that info is not available to the report. Many times it's also good to include "detailsUrl" in the dataset. Like this: SELECT n.caption ,ni.NodeID ,ni.IPAddress ,n.Location ,n.Vendor ,n.VendorIcon…

As a part time DBA I would say DPA is wonderful! And my colleges that are full time DBA has become addicted to it :-). Saves you a lot of time.

Tried this also in 2023.1.0 and 2023.2.0, works in both installations as a "Custom query widget". I would though change the WHERE part to: WHERE NCE.DeviceId like '%AP%'Named columns could be an issue there. 

Yes that will work. If you want to optimize a bit you only need to add "Tolocal" on the output values. So for example in below part of the query i removed it from the first datevalue: CASE WHEN ToString(N.UnManageUntil)='Jan 1 9999 12:00AM' THEN ' - Forever - ' ELSE ToString(tolocal(N.UnManageUntil)) END AS [Suppressed…

On datetime values you can use "ToLocal(datetime)". Then it should be in the local browsers timezone.

Hi, I added both options. Remove the once you don't want. Change the "ActionTypeID" so it matches what you have in your system. --Unmanaged SELECT N.Caption AS [Node], DATETRUNC('minute', N.UnManageFrom) AS [Suppressed From], CASE WHEN ToString(N.UnManageUntil)='Jan 1 9999 12:00AM' THEN ' - Forever - ' ELSE…

ok, do you want "suppressed for x more days" or "suppress for x days in total"? In case there is no end date, the value will be null

Great!! Suppressed days in not how many days it will be suppressed but how many days it has already been suppressed. 

Ok, understand. I have seen that in some installations the ID's for "actionTypeID" are not the same. Might be that you have other numbers in your installation. Run below to make sure your id's are the same as I had in this installation: SELECT ActionTypeID, ActionType, ActionTypeDisplayName FROM Orion.AuditingActionTypes…

First, I think you should upgrade. Second, you can try this one: --Unmanaged SELECT N.Caption AS [Node], DATETRUNC('minute', N.UnManageFrom) AS [Suppressed From], CASE WHEN ToString(N.UnManageUntil)='Jan 1 9999 12:00AM' THEN ' - Forever - ' ELSE ToString(N.UnManageUntil) END AS [Suppressed TO],…

Hi, I think this is what you are after: If you go to one instance, then "resources" up on the right. There you have a page with a lot if different resources. In each there is a cogwheel to the right of each graph. Click there and you can see and adjust the thresholds for each metric.

Hi You can use below query as a base to create the report: SELECT S.SettingID ,S.Name ,S.Description ,S.Units ,S.Minimum ,S.Maximum ,S.CurrentValue ,S.DefaultValue , CASE WHEN S.CurrentValue!=S.DefaultValue THEN 'Not Default' WHEN S.CurrentValue=S.DefaultValue THEN 'Default' END AS Status FROM Orion.Settings AS S WHERE…

This is how you can configure a SAM WMI Component for this: BUT, I'm not sure this WMI query works on modern Windows. The results I get does not seem reasonable. 

I would suggest you download SWQL-studio if you haven't already: https://github.com/solarwinds/OrionSDK/releases In SWQL Studio, you can run your query normally but you can also go to menu "Edit" / "Copy Query AS" / "Curl..." to get the query in a format suitable for this usage.

Hi, the DPA upgrade does not work like orion upgrades at all, you will not have the issue of it forcing you to go to the latest version. DPA upgrades are most of the times really smooth. 

Hi, there is lots of info about the API's, here is some to start with: https://thwack.solarwinds.com/resources/b/product-blog/posts/intro-to-api-sdk-swql https://www.youtube.com/watch?v=8pTQo8Oqk8c https://github.com/solarwinds/OrionSDK

Above picture is from "trigger action" page, when you create an alert. Not sure if it's there or not on any other page. Sounds like a feature request.. ;-)

I Think this one will do it. As an example will it look for all "cisco" devices that don't have an interface monitored called something like "loopback" SELECT N.Caption ,N.NodeID ,N.DetailsUrl FROM Orion.Nodes AS N LEFT OUTER JOIN Orion.NPM.Interfaces AS I ON N.NodeID=I.NodeID AND I.Caption LIKE '%Loopback%' WHERE…

That specific interface, is it a interface type or interfaces with something in it's name? Should we also only include devices from a specific vendor?

Similar GUI for choosing columns are available in several places around in the SolarWinds platform. On some of them there is a link to change object but not on all by far.

If I where to recommend which version to upgrade to, looking back one year, I would actually go to just that one - 2023.2.1. No version is perfect but this one seems pretty good. And as @"vinay.by" say, you need to upgrade very soon to be on a supported version.