k1gaudineer · Sr. Network administrator · ✭✭✭✭✭

Leon Adato Interesting result...... I tested the SQL statement you suggested and the email body shows this when the CircuitID field is NULL Circuit Number: ${SQL:Select ISNULL(CircuitID, 'no circuit found') From Interfaces WHERE Interfaces.NodeID = $@NodeID@ AND CircuitID IS NOT NULL} In the statement above notice the part…

Interesting..... What device are you using? I am working with Brocade and Avaya.... With the view I see It looks like SolarWinds is putting 2 different names together If I don't specify a name... I am going to try an past a screen shot below....... The image below shows what happens... When I insert a new card 2 names are…

I tried the following SQL Query in the Database manager with the interfaces table selected. SELECT Interfaces.NodeID AS NodeID, Interfaces.InterfaceID AS InterfaceID, Interfaces.Caption AS Interface_Caption, Interfaces.InterfaceType AS Interface_Type FROM Nodes INNER JOIN Interfaces ON (Nodes.NodeID = Interfaces.NodeID)…

I thought the nodes and interfaces were stored in 2 different tables. Can I create a report in report writer and then show the 'SQL'. And paste that query in the database manager?

I see what the trouble is..... In your example you have IP address ' MATCHES ' then your expression... In my query window I had IP address ' Contains ' then the expression. I wanted to add a screen shot but I keep receiving the message that the image type is forbidden. Don't know why.... Once I changed my query to '…

Here is the report with the NewCust Records showing.... Interestingly enough I noticed that the new customer does have an IP range that is unique to them so if I change the second line of the report query to be Select records where IP Address CONTAINS 10. The report will display correctly.... I still don't understand why I…

I got it from user "Buttons" Has anyone found out how to report this to the TWACK team?

sum_giais, Thank you for your reply. Thats the understanding I was missing. You are spot on... the entire column is being summed and for every row that was part of that sum the ColumnSum shows up in a separate column next to every row. (that's a lot to say).... That's not what I was expecting but at least the sum is there.…

chenash, Thanks for the reply, but the example I gave is just one UnDP. In my actual scenario, I have 10 UnDp's that return tables that I need to sum the value column. I am wanting to use this transformed value as the basis for an alert trigger not in a dashboard chart or resource. It would be a lot easier if the ColumnSum…

@"jblankjblank" - Thank you for the response. The first part of my scenario is that my world (In Orion) is spinning out of control and the root cause is Maps 2.0. So far in our 20 year history with SolarWinds this is the worst thing I have seen the developers bring to the table. Maps 2.0 doesn't work it doesn't work any…

@"jblankjblank"- Thank you for the response. The Contextual Map sub-views don't populate in our Orion environment. the reason for this we are always told is because our environment is very large and the NPM topology can't run. (We are hoping this will be addressed in future update to Orion.) Here's the scenario:, An…

Wluther Thank you for the response. What version of Orion are you running? During one of the WebEx sessions with support I remember talking about making the edits you suggest, I may have been referencing your solution during that conversation, in any event, the file you mention is not in that folder location with (2018.4…

No... the only options I can choose are: is not begins with ends with contains matches

Thanks for the suggestions.. I tried them both and I still have no luck. The screen shot below is my list of exclusions. I still need to enable the _Brocade Test #4 for the exclusions to work but that will exclude both 'username lines'. Interestingly enough while working with SolarWinds Support we had to add the ( ^! ) in…

Thank you for the suggestion... I changed the expression and downloaded a new running and startup config. But this expression still does not work. Its like NCM is forcing me to make sure that both username lines are matched. I have also tried omitting the username and just going with ^.*admin.* that does not work either.

Why is there a limitation on this resource? Especially a limitation with such a small number. The other resources do not have a limitation on them. These resources would be Nodes - Table and Nodes - Tree resources. They display well over 100. I just don't see the logic in placing a limit on the Custom - Table. This is…

Perfect Answer...... Thanks you very much.... Especially pointing out the two different folders (directories) where the created files are kept.

Unfortunately there are many different types of devices being used in the remote offices. It looks like the only way around this issue is to use the network atlas and manually assign the view (under hyperlink) instead of letting it stay as a logical page (automatically generated)......

Yes we are moving away from Report writer. The plan as we understand it now, is that SolarWinds wants to do away with Report Writer and all reporting will need to be down with the new web based report tool. So far I'm not a fan of the web report tool it is extremely hard to use and very difficult to manage. Report writer…

mmmmm.... This is interesting... Instead of using NCM I tried this using my favorite SSH Client and a TFTP server running on my laptop. I used the exact same command that I have in the NCM config change template plus I tried one other command. The first command I used ran was delete /force /recursive flash:/update... This…

Good Morning everyone, and thanks for all of the replies. HolyGuacamole and Leon Adato are corect I need to use a SQL variable. I tried the one that Leon Adato recomended but that did not work.... So I watched the SolarWinds Lab #7 video and dug through a few more post that were linked from that video site and so far I…

Thank you for the suggestion. I have tried the query both ways (using the <> and then using the !=) unfortunately the result is not correct. The down interface resource still displays all interfaces that are down for the 3 nodes. I am beginning to wonder if I have the correct understanding of the Down Interface resource...…

We do that now. That is where the name that is highlighted in yellow comes from and also the name that appears in interface alias. However, Orion is still forcing 2 different names to be concatenated together to create 1 name.... 

Yea..... I went through those examples before starting this thread. I have tried the query with and without the quotation marks. Replace the ' * ' with a ' ? ' as the online help suggest but nothing works. The only difference I can see here is that all of the examples shown use the 3rd octet of the IP address... I am…

Good morning HolyGuacamole, The reason for the renaming is because I don't like the way the caption appears in SolarWinds. Especially for the multislot network chassis where a number of different kind of cards can be used. As an example without making any edits a new 24 port 1 gig fiber card added to one of my chassis will…

Yes, I have tried that and that is what I am trying to avoid using. The problem with that procedure is.... It only list the interfaces. you still have to click the interface,,, Then go into the interface edit screen, edit the interface.... scroll all the way to the bottom of the screen,,, click submit.... Then go back into…

The answer to your question is 'YES'. Here is how I explain how to do this to my techs... Especially if they need to reload a config and want to TFTP that config across the network... By default NCM will store configs it backs-up into the following folder structure.... (C:\ProgramData\SolarWinds\NCM\Config-Archive) The…

Thank you Chris T... Your answer was spot. I needed to add the 2nd condition correctly Forgot the curly brace ( { ) before and after the line and I also needed to add the extra text before 'Version V12.2'. The only other thing I needed to change was the beginning of the match... I had to remove the '@node' and replace it…

This is exactly what we are looking for to use with a lot of our Report Writer Reports... We have tried several times to get this to work in the Web report writer but like all of our other reports the web version fails... Our steps are to Create a new Report... Select Reports..... Then Make sure Custom Table is…

Thanks for the reply... I tried making the changes but the report is still blank.... When I convert my report to SQL this is what it looks like...... Select NodeName, IP_Address, Status, Status_Icon, Cast(Cust As nvarchar(250)) as Cust From ( SELECT Nodes.Caption AS NodeName, Nodes.IP_Address AS IP_Address, Nodes.Status AS…