mharvey ✭✭✭✭✭

The table you are looking for is NodeIPAddresses in SQL or Orion.NodeIPAddresses in SWQL. You'll want to join via the interfaceindex, but this is the table that contains the ip and subnet information.

If you're doing a simulation, make sure that you are specifying the correct hardware sensor as one of the temp sensors on the box. By default the alert will pick a random node as the test. I had to set the test object while creating this and simulating it.

Done testing on the alerting side. I was able to get this to work: Temp: ${SQL: SELECT (${N=SwisEntity;M=Value}*9/5)+32} I did several simulations against Juniper Temperature Hardware values and each returned a value. The biggest issue I think with the article may be spacing and the characters in the string. Give this a…

I'm still playing with the variable functionality and SQL. Directly from SQL you'd need something like ((ColumnName * 9/5) + 32). It may be that you need to have it as: ${SQL: SELECT ((${N=SwisEntity;M=Value}* 9 / 5) + 32)} I'm currently running some test myself. It may also be that the SQL option may be limited to be…

What temperature value are you trying to convert regarding temperature? Is there an APC alert? A custom poller? If you don't add the conversion and simulate the alert, what is the value coming back? Just trying to get some information before writing a SQL conversion attempt to make sure it won't error out.

I updated this just a little as the message type was giving me a bit of a fit. I added node information to this to help group and limit: SELECT [Node].Caption, SUBSTRING([Log].Message, 2, CHARINDEX(':', [Log].Message) - 2) AS [MessageType] , [Log].[Level] , COUNT([Log].LogEntryID) AS [Quantity] FROM Orion.OLM.LogEntry AS…

This should work. SELECT TOP 10 ADDHOUR(-5,n.ObservationTimestamp) as DateTIme, n.AccountID, n.DisplayName FROM Orion.AuditingEvents n where (n.accountID <> 'admin' AND n.AccountID NOT LIKE 'website%') AND n.ObservationTimestamp like '%2024%' and ActionTypeId = 57 Order by n.ObservationTimestamp DESC

I updated this SWQL to the below and it seems to run for my environment. select i.FullName as Interface, i.DetailsUrl as [_linkfor_Interface], '/Orion/images/StatusIcons/Small-' + StatusIcon as [_iconfor_Interface], act.TriggeredDateTime from orion.npm.Interfaces i join orion.AlertObjects obj on i.Caption =…

Have you gone into Manage Views to see what all components/graphs charts, etc, and how many tabs are trying to load for those devices? I would make a test view, assign it to a specific node and see if that page loads up. Could be too much trying to load within the timeout window, or possibly and older component/gauge that…

For that piece, you may have to see about creating a script that would do that, then set an alert that fires an external program to run that script on the server.

The command is wrong. It needs to be winrm set winrm/config/client ‘@{TrustedHosts="IPAddress"}’ I realized that the ' were missing on either side of the trusted host portion. PowerShell needs that part. So on the SolarWinds Server winrm set winrm/config/client ‘@{TrustedHosts="*"}’ On the target winrm set…

I found a link for you of the dragon image. http://www.varbak.com/photo/horrible-dragon-head

Glad to have helped out.

If there is no description when you put in the OID then it means the MIB is not in the SolarWinds MIB Database, if the device still answers to it, that is ok, it doesn't have to be in the database. You'd need to research the OID to deteremine what the value is. The counter32 is the type of data that the MIB represents. In…

nicolasdiogo, Google image search.

I would recommend opening a case with support at this point. They will need to dig in and find out why the property isn't there. You can do this by going to Technical Support Ticket Submission Form | SolarWinds

You can put any of them in there such as 1.3.6.1.2.1.2.2.1.16.3. If there is specific information you are looking for, you'd need to web search for the specific OIDs, or just add in the OID to the Universal poller to see what the MIB is and a description of it.

Glad to be of assistance.

I notice in the notes, the hotfix seems to apply for those users who went from RC1 to RC2 and that RC2 users that didn't have RC1 didn't see this issue. My upgrade went straight from 6.1.1 to 6.2 RTM so would the same apply? I just want to ensure I'm applying something that will correct the issue.

Are you able to bring the Orion website up on the SCOM server and login with those credentials? Are ports 17777 and 17778 open from the SCOM server to the Orion server? Regards, Matthew Harvey

The timeout might not have been added until the recent build of 10.3. In regards to what identifies the values, it would be the response given back by the SNMP daemon on the device. The OIDs are sent by the SNMP walk to the device, and the SNMP daemon responds back with answers. To browse for vendor specific MIBs, such as…

In Manage Nodes, click Add New, put in the IP of the device, select to monitor the server with WMI, and provide credentials with administrative rights to the server. Once done, test to ensure the credentials pass, then continue to add the node. When you get to the point where it finds resources, then AppInsight should be…

the last two lines are merely comparing the Sysname in the Discovered Nodes table to the Caption and DNS fields in the nodes table and ensuring it doesn't match either in order to show up in the report. 

Just re-enabled to CPU with top 10 processes alert after the migration and found that the exe doesn't seem to be writing anywhere. The original variables with the action probably don't work after the upgrade. Are there different variables to use that anyone has found?

From what I can tell it doesn't look like the connection is being successfully made.

The page exists in both the additional webserver and the primary webserver. By marking the additional, that's in the DMZ, as the primary, the variables will link to it rather than the site on the primary server. Please note though, this will cause all link, and all variables that are supposed to go to the primary to go to…

Do just this winrm set winrm/config/client @{TrustedHosts="*"} And on the target server do winrm set winrm/config/client @{TrustedHosts="IP_ADDRESS"} where IP ADDRESS is the IP of your SolarWinds server.

Is the group showing down or in a warning state? If you look at the advanced features of the group within the group editor, do you have show best case or worst case? The email variable probably won't work unless you are doing a Group Member alert and not a Group alert. There would be nothing to tie the variable for the…

OK this is a permissions issue. You'll need to do the registration a different way. Find the command prompt in your start menu, then right-click on this and choose run as administrator. Once this is done use REGSVR32 "D:\Solarwinds\OrionNPM\SWAlertActions8.dll". If this still fails, then the dlls need to be repaired,…

You'd have to adjust which website is primary in the Websites table in order to point that variable to the webserver in the DMZ.