narzsa ✭✭✭✭

Hi All,We think we may have gotten to the bottom of itWith the agent failing we were able to dig a little deeper. Looks like it was a hub policy on the firewall. We created a new policy, and it looks like that resolved the issue. Despite ports being open on both side and communication being there, it appears the old policy…

Alas, that's already done, as i've seen that issue before, so prepped for it. The APE has all the host file entries for the MPE etc and the MPE includes the APEs NAT IP for it's reference

There's articles regarding it such as the below. So my understanding is it will work so long as you a) use the host names as you say and b) the NAT supports bidirection https://thwack.solarwinds.com/resources/b/product-blog/posts/orion-distributed-deployments-672181452 Presently it's not even getting that far. I've got the…

We can see it land via wireshark on the MPE, so if there is something it must be local to the box?

Also as a control, i tried to deploy the agent, which i know 100% does support NAT as it references it for the remote collector When i tried to connect it i get 

Hi, using port tcp/17774 (Orion (v3) over HTTPS) we get; An error has occurred while making the http request to [https://URL]. This could be due to the fact that the server certificate is not configured properly with http.sys in the https case. This could also be caused by a mismatch of the security binding between the…

Cheers Vinay, that looks to do it

Cheers Rich, that'll do it thanks

Also does round robin work from a dns perspective for Solarwinds in this fashion?

Hi Mapujece, it is set to DNS, and you can see in SW it is resolving to an IP. However, MS do not support connections over IP, the connection needs to be via FQDN, hence the issue. There doesn't appear to be an option for a SQL Server User Experience Monitor to override this, since there is no ip field in it, only port,…

And this is even better as it gives me the days remaining. Cheers @"bobmarley" SELECT [Components].Name AS [Certificate], cp.ComponentStatisticData AS [Days Till Expiration] -- Statistic data from CurrentStatistics FROM Orion.APM.Application AS [Applications] JOIN Orion.APM.Component AS [Components] ON…

you did give me an idea though. Using the above i drilled down and found that the field that seems to hold the value is cp.errormessage. Amending my script to the following then brings back a list of the certs added and includes the expiration date :D SELECT [Components].Name AS [Certificate], cp.ErrorMessage AS [Error…

Cheers, the above didn't error but came back with anything I even tried to remove the qualifier of ComponentStatisticData < 100 --displays only 100 days or less No luck

That did it, using a custom property to key on, worked fine. Cheers Adam

Cheers Adam, i'll give it a test as i think powershell may work. The issue isn't the ip per say, its the fact MS don't support calls to SQL through the IP and thus block it. So so long as the Powershell calls it via the dns name it should work DPA doesn't have the problem and calls it correctly so we can get monitoring…

Yeah that appears to be the issue as i found this - learn.microsoft.com/.../connectivity-architecture-overview 'When connecting to a private endpoint, always use the domain name since connecting to Azure SQL Managed Instance via its IP address isn't supported yet.' This implies, and i can confirm from testing, that a SQL…

Cheers Mark. The link is for a SAM template for stats, but it won't resolve the SQL query issue, since that appears to be a problem using the node in SAM We actually have dpa, which brings those stats into SAM, but the SQL query template still has to be latch to a SAM node, not a dpa one

Hi Adam, Yeah no problem, so i used the following…

i think i resolved it using template 9.5 and the following reg entry. Will monitor to confirm Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\PowerShell\1\PowerShellSnapIns\VeeamPSSnapIn] "PowerShellVersion"="2.0" "Vendor"="Veeam" "Description"="This is a PowerShell snap-in that includes the…

One thing of note, snap ins have been superseded for veam it seems? https://www.veeam.com/kb1489

Cool, so you can manipulate the data in the poling editor? That is the part i can't seem to find?

Cheers Bogdan, that looks like it checks for the same object to be down across the entire environment Is there a way to define it so it will only trigger if they are all down on objects in the same group?

Ah ok, so the raw capacity in this case is more of a guess based upon the scatter pot analysis? Fingers crossed it'll be a more accurate in the next release as its quite the useful tool

So effectively if the data-store latency is low but the vm latency is high this would indicate high contention?

Hey Michal.hrncirik Is there any time line with regards to this? We are trialing the software presently, and this is the feature that is make or break for us as we could then use it to enforce and charge clients base on how much of our ISP bandwidth they are consuming Kind Regards

I'm trying to find out the very same