jm_sysadmin · Sr System Engineer · ✭✭✭✭✭

I have seen something like this, and I can't remember if I fixed it with the Permissions checker or re-running the Configuration wizard. 

Are there events on your Orion server that match?

Now that I think about it you force it out of an int to a decimal by multiplling by a decimal like: Avg(([data].[ContainerStatus].PercentAvailability)*1.00) as [Average Percent Availability]That would need to be rounded to get 2 decimals to match your example. Round(Avg(([data].[ContainerStatus].PercentAvailability)*1.00),…

Yah, this made me scratch my head. It definitely wanted to use integers. So you wanted 2 decimal places, and multiplying, averaging and dividing by 100 made it happen. (Avg(([data].[ContainerStatus].PercentAvailability)*100))/100 as [Average Percent Availability]

Try checking your NCM profile(s) if set to auto detect it will try to evaluate servers during discovery. We wanted the auto detect, so we just cleared out the server on a regular basis. We also split up our discovery jobs, servers (with no profiles) and network devices are in different jobs. 

Windows Servers you can use: https://www.solarwinds.com/free-tools/snmp-enabler-for-windows Linux servers we use the same config deployment we use for everything else to install SNMP and configure it. Maybe something like: https://arkit.co.in/configure-snmp-using-ansible-playbook/ And if you are talking about other…

This is good advice from @"christopher.t.jones123" if you need to check that its not Orion, you can verify the SNMP using the SNMP walk utility: https://support.solarwinds.com/SuccessCenter/s/article/Run-SolarWinds-SNMPWALK?language=en_US It's a simple client to confirm that your community should also work in Orion. If you…

If its the default alert for node down, copy it, turn it off and edit the new one. Then head over to the reset actions of the alert. https://documentation.solarwinds.com/en/Success_Center/orionplatform/content/core-setting-reset-actions-sw1022.htm 

I can't test it, but it would be something like: SELECT [data].[DisplayName] AS [Site] , [data].[ContainerStatus].[PercentAvailability] AS [PercentAvailability] , [data].[InstanceSiteId] AS [InstanceSiteId] , Case When MONTH( DateTrunc('Month', [data].[ContainerStatus].DateTime) ) = 1 Then 'Jan' When MONTH(…

This should get you closer, just merge the two and I bet you get it done. SELECT ContainerID , Case When MONTH( DateTrunc('Month', DateTime) ) = 1 Then 'Jan' When MONTH( DateTrunc('Month', DateTime) ) = 2 Then 'Feb' When MONTH( DateTrunc('Month', DateTime) ) = 3 Then 'Mar' When MONTH( DateTrunc('Month', DateTime) ) = 4…

I don't think the changing of the thresholds is in the public API currently. I think the information to report from is located at: SELECT TOP 1000 EntityType, InstanceId, ThresholdType, ThresholdOperator, Name, CurrentValue, Level1Value, Level1Formula, IsLevel1State, Level2Value, Level2Formula, IsLevel2State,…

Don't select the VMware polling method, you want SNMP (Or just ICMP depending on your access)

Absolutely! I used the SWQL below to power a report that gets sent out Monday Morning before the recipients come in. This is the template I used for several that go out. Typically to get reports on entire teams, but you can trim it down to just one extension. Once you get it in a report the way you want it, just go to the…

I follow, and you will have to get the properties ahead of time I believe. So maybe do a query like: SELECT Field FROM Orion.CustomProperty Where TargetEntity = 'Orion.NodesCustomProperties' And use Javascript to build the query you need. 

what you have looks like it should be close to working, are you just hoping not to list all 100+ networks? Is there a way to filter on the name? Can you do like 'Ipam_network_name%' or something similar? We prefix our names for various uses. Below is just another way to do it that is a bit shorter? [Subnet].FriendlyName in…

I can think of 2 ways to get this done @frn First, use the 'Manage Custom Properties page'. You can export all the values in addition to just getting the fields. You can also update them in the exported file and import them back in if needed. Then there is SWQL studio in the SDK. When you use 'Generate Select Statment' it…

And the SWQL or SQL in them as text? 

I recommend using the api and powershell, although javascript could hit the rest interface directly https://github.com/solarwinds/OrionSDK

If the management IP isn't isn't discovered on the node' s primary IP inventory I have either switched to monitoring the management interface (sometimes it has all the devices information) or I just add a second node to handle it.

Try this: https://support.solarwinds.com/SuccessCenter/s/article/Using-WBEMTest-to-verify-volume-size-and-free-space?language=en_US

I have seen similar things that were fixed by support clearing out my subscriptions. This might be worth open a ticket with them.

Do you have an example of a trap that should trigger the alert? 

I like where your head is at, and I want to take up a similar task in the near future. Right now the best I have been able to do is import a new template with the component that I wrote into an xml file. That never turned into anything production ready but I basically took the xml export of stuff I wanted, say port…

Right, which is why I need the details on what they are, and what type of latency (network, writing to share, etc) Without details I can't help further. 

In NPM you have interface statistics and ICMP latency, and 'other' stuff too, but lets take a look more holistically. What Orion modules do you own? Is it just NPM? Next, what devices are you monitoring? Exact details help here, as different things have different abilities. What types of server, what brand of storage and…

You don't access the API with an SNMP credential, its likely either your account for the Orion website, or an account that you added just do to API work. If you can sign into SWQL studio, that account likely works From SWQL studio you can list the accounts, run something like: SELECT TOP 1000 ID, Name, Description,…

I currently run Netpaths from all 6 of my polling engines (3 active and 3 on my passive HA nodes) and 2 non-Orion windows servers. Additional probes shouldn't be an issue. 

Today Netpath needs to run from a windows machine with the Agent, but you have one already, your Orion Server. SolarWinds Orion agent requirements It self limits how many probes you can assign a server based on the resources (CPU and Ram) the server has, but I have not seen performance impact from running a Netpath probe.…

I can't test it since I don't have your custom poller but I would try the Case statement I added below. When you name a column [_IconFor_OtherColumnName] the icon you set will be the image added before that column's data. If you want a dedicated column, you can just add it to an empty result like '' SELECT cp.UniqueName ,…

Yup, I agree "If the number of users logged in simultaneously is close to 50, add an additional web server." Optimize the performance of the Orion Web Console (solarwinds.com) If you aren't near 50, you may want to look at any custom resources, or resources that pull a lot of data on your pages.