This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

NTA4.4 Top Talkers

We just upgraded our servers to the latest Orion code. Top Talker alerts are again broken. This seems to have happened several times in past.versions, so it appears to be hard for developers to test.

We still get the email, and subject is properly populated, but no data is in the text. On the Trigger Actions window, on Configure Action:Email Action, in the Enter or Paste the Web Page URL window, we have:

${SQL:SELECT REPLACE(REPLACE(Macro, '$$Password$$','redacted123'),'$$User$$', 'Admin') FROM NetFlowAlertMacros WHERE ID='InWebMailInterfaceDetailsLink'}

Of course, we use complex passwords with possible metacharacters. We haven't had to escape them in the past.

In addition, there are typos in the NTA 4.4 Administrators Guide, where text is missing in the setup steps for Top Talkers on page 109. Step 10 is missing the code example, and Step 11 is missing the non-code text.

I've left feedback based on the feedback link at the bottom of NTA 4.4 Administrator Guide - SolarWinds Worldwide, LLC. Help and Support. When I see a correction, I'll try to post here. This leads me to believe that the calling method may have changed.

I'd appreciate it if anyone can confirm whether the method for calling and including user and password (is escaping necessary now?) have changed in 4.4, or whether the Admin user no longer has the necessary rights on Windows 2012R2. We do have a fairly secure setup with GPOs and such, but this all worked under 4.2.1 the day before the upgrade.

=foon=

  • That particular alert has been so buggy for me over the years, and I hate leaving my passwords anywhere they can be easily pulled up in plain text like that.

    I always completely ditched that way of doing it in favor of just sending a normal email with a link to the netflow page where they can see the top talkers for that interface.

    https://YOURSERVER/Orion/TrafficAnalysis/NetflowInterfaceDetails.aspx?NetObject=NI:${N=SwisEntity;M=InterfaceID};T:Last%2024%20Hours;FD:Both

    If you really want it to scrape a picture into the email you can just enter the username and password into the box below like so:

    pastedImage_1.png

    But I find that the whole including pictures in the email thing causes me more headaches than it solves.  Been too many problems with it over the years.  If I spent some time thinking about it I could probably just generate a sql query that included the top talkers info as text in a regular email as well, I feel like I've done that for a client once before.

  • Hi,

    In NTA 4.4.0 you will not receive the picture. Just a link and attached PDF in the email. Anyway the username and password are no longer used in the macro. New macro looks like this:

    ${SQL:SELECT Macro FROM NetFlowAlertMacros WHERE ID='InWebMailInterfaceDetailsLink'}

  • mesverrum -

    I agree about storing passwords. Developers have obviously worked on this a lot over the years. I remember when the username and password appeared in the alert the users received. We began to use DirectLink for that, and then disabled as many rights on DirectLink as possible.

    We have mandatory periodic password changes for all accounts, so having to enter and store credentials is a major operational issue in any case. So, I like the fact that the new method no longer requires it. I'm just waiting for it to fire to see the result.

    Has anyone done a white paper on securing Orion and its modules?

    =Foonly=

  • stibi -

    It's odd that this change was not mentioned in the Release Notes. I think it's an excellent change in theory. I'm now waiting for it to fire to see how it is in execution.

    The Administrators Guide is still waiting for the broken section on page 109 to get fixed as of this moment.

    =Foonly=

  • stibi -

    I made a typo when entering the macro. It does indeed work! .

    The PDF is automatically attached to the email - nothing needs to be done besides entering the recipients, subject, macro, and email server.

    For subject, we use:

    High RCV Util - Top Talkers - ${Interface.InPercentUtil}% ${N=SwisEntity;M=FullName}

    Thanks a lot for your help!

    =Foon=

  • mesverrum -

    The new macro results in the same web page as your method, without having to edit the name of the server.

    =Foon=