dgsmith80 · Monitoring Engineer · ✭✭✭✭✭

I changed mine to: JOIN (SELECT rec.NetObjectID, max(rec.timeloggedutc) as recent FROM Orion.AuditingEvents rec WHERE rec.AuditingActionType.ActionType = 'Orion.InterfaceUnManaged' GROUP BY rec.NetObjectID) mostrecent ON mostrecent.NetObjectID = i.interfaceidJOIN (SELECT ae.NetObjectID, ae.AccountID, ae.timeloggedutc FROM…

Try changing the JOIN Statement to a LEFT Join: left join orion.nodenotes nn on nn.nodeid=n.nodeid That should include entries where there is a NULL Value in the Notes field.

Watch out for the typo in that script I’m struggling to edit it as I’m using my iPad at the moment. Just add the AND interf.IsWanInterface LIKE ‘Yes’ on the end of the WHERE Statement.

Ok so the issue is your CO Format is Text with a Value of Yes. The script should look like this: SELECT (no.caption + ' - ' + interf.interfacename) as [Node Name], interf.interfacename as [Interface Name], it.datetime, it.in_averagebps as [Average BPS In], it.out_averagebps as [Average BPS Out] FROM…

 Thank-you again Caroline. Dave

Oh no ! - Are you in a position to be able to upgrade? So technically the SW Support were right it isn't supported as it was only added in 4.6!!

That was a customer environment that I no longer have access to, I will test it at my next opportunity - If anyone out there can validate if this is working in NPM12.1 we would appreciate it.

I'm not sure about the single license thing, if Kiwi forwards on data from 5 Nodes, that would consume 5 licenses in your LM.

Fantastic news, are you allowed to share the fix?

Thanks for your response Caroline, and I apologise for re-posting a dead thread, but I have a further question please. I am now at the stage where I have authorisation to purchase the SQL Server upgrade, but I am not to familiar with the CAL's terms etc. I was offered: SQL Svr Std Ed 2008 Single or Single 1 Proc? A…

Hi rajasekar can you show us a screenshot of your Custom Property settings so that we can make sure this is correct for you? Also if you remove the line related to the CP does the script work for you? SELECT(no.caption + ' - ' + interf.interfacename) as [Node Name], interf.interfacename as [Interface Name], it.datetime,…

Hey Deltona, Fair point. This is why if you have more than one connection route (ie dual WAN Routers etc) then you would put all access into your Group and set Group Status Rollup to Best Case so that only if all nodes were down would the Group be down and trigger the dependency. You can understand why because if you…

Good luck, let us know how you get on

The 30-day trials are fully functional with no restrictions, after 30 days you lose functionality.

SolarWinds doesn't support an Active/Active HA solution. The HA is a Primary / Standby setup with the ability to select a preferred active primary. There are some ways around the DNS such as Load balance etc. Sadly I don't have enough experience with F5 to inform you of the best way to configure them for use with an…

I mean I can see use cases, where maybe you're using Kiwi Syslog or some other type of aggregation/filter layer and only forwarding on the priority devices into Orion directly, but that isn't the most common of situations.

IsWanInterface is NOT a valid table in the Interfaces table. Are you trying to link to a custom property called IsWanInterface ?

No I can't say I've ever come across it before, and I am unable to replicate it in either my office system or in a test VM. Leave it with me I will take a look. I'd be happy to do a remote session with cs99772 after Xmas and I could try my Thwack credentials on your instance to see if that makes any difference and visa…

WPM? You didn’t list that on your original post did you mean NPM? If it was a new product installed it would be in evaluation mode until you activate it with a license key.

Feature Request Please!! Got my vote.

Can you show us an example of one that works vs one that doesn't as that sounds odd?

It doesn't have to be a WAN Router, but it's hard to simulate because the end devices need to be behind the Parent device. If SolarWinds can still ping the device directly then it will register the true status (as per your existing test). This is my alert trigger (ignore the Scope part as it's a Demo lab)

The delay could be coming from the Database what is the SQL server like?

Hey guys, Whilst I am not yet having any problems with my database, it is slowly creeping upto that size where I am starting to get worried, especially as we still need to grow our system to add more devices. So my question is this, as I currently have a dedicated Win 2k3 Server running the NPM with SQL Express. Can I…

If you use: ${N=Generic;M=Day} then it should come out as 09/11/2018

Ah yes I am able to replicate that issue. When I have less than 5 (As an example) and the "Number of Rows per Page" set to 5 then it works fine. If I then unmanaged some additional devices I get the following issue: But if I increase the page count to 10 it works fine. EDIT: I noticed this is also showing up in the…

Hi bharris I would suggest that you use the Polling Engine installer which can be downloaded from your Main Poller within All Settings > Polling Engines - Download Installer Now. This can then be copied over to your APE and it will make sure it installs all the same modules and more importantly module versions as your…

Yes, all SolarWinds software can be downloaded and installed for 30 days. I think there has been some confusion over your term of Orion Individual Account. I suspect you're referring to the Customer Portal Login, but SolarWinds NPM also allows you to create Local Orion accounts as well as Windows Accounts or AD Groups,…

You mean it's crashing out and not even finishing? It would normally fail with an error message of some description. Try checking the following log file: C:\ProgramData\SolarWinds\Logs\Orion\ConfigurationWizard.log (There might be a few versions of it depending on how long it took and how many times you've run it.

Done - Your welcome. Hope it helps.