jameslindsay · IT Operations Engineer V · ✭✭✭✭✭

Got this from support SELECT e.EngineID, Count(ccs.ApplicationID) as Components FROM [dbo].[APM_CurrentComponentStatus] ccs JOIN [APM_Application] ap ON ccs.ApplicationID = ap.ID JOIN [Nodesdata] node ON ap.NodeID = node.NodeID JOIN [Engines] e ON node.EngineID = e.EngineID JOIN [Engines] ae ON ae.EngineID = e.EngineID…

From the poller using PS ISE to the CIF Still working on the log. AppID should be 5655 but, I'm not finding it on the poller Found the log (some data removed for privacy) and I'm wondering if that's not a clue in and of itself as it was on the poller used to poll the poller where the template is deployed. POLL4 polls…

$cred = New-Object -typename System.Management.Automation.PSCredential -argumentlist $username, $Securepassword $swis = Connect-Swis -Credential $cred -Hostname $hostname $nodeid = Get-SwisData -SwisConnection $swis -Query 'SELECT NodeID FROM Orion.Nodes WHERE SysName = @s' @{s=$sysname} Write-Host "Updating the Node ID: "…

Thank you for your response. I am speaking of the World Map. None-the-less, I will use the information you provided for work I'm doing in Network Atlas.

I Didn't see that message and the result set was fairly small...I've seen larger. My SWQL showed 30 and the summary shoed 18. I accounted for the missing 12 as duplicate volume labels despite being on a different server.

Yes, this was finally resolved by insuring all of my pollers had the same MS patch levels and .Net 4.7. I was at .Net 4.6.2 so I updated that first, nut it had no effect. I had one APE missing two patches compared to my other three and the Primary was missing one compared to the other three. I'm running on MS Server 2016…

I'm having more of an intermittent problem on 2019.2 HF2 and a bit different. Because reopening a "Resolved" incident was really messing with our SLA calculations, we switched to Reset State "Closed". However, I find from time to time with no explainable reason, some tickets of various types do not close. There is a note…

Thanks for the informative response. In this case, this is the poller trying to communicate with the Orion Db Server. There are no Db's monitored from this poller that I can find. I have no issue connecting to the Database from the poller using DB Manager and there is no indication that the poller is in distress.

Please do.

I have this same issue and I think even the accepted solution has issues. As was said, when using an advanced condition how can you be sure the alert is not tripping when Device 1 int A and Device 2 int B are down as opposed to the intended Device 1 int A and Device 1 int B? Groups are useful when dealing with a small…

Ok, so then that seems to indicate that I am over thinking it. It seems in some cases you don't have to join to get to a field, for example E0.[SqlServer].[Node].[Caption]. How did Orion.APM.SqlDatabase get joined to Nodes to pull the caption?

Just curious if you have the SQL for this as well?

It's not OK to remove any of them? Given I'm on Orion 2019.2 and all my modules are current, is there a date for which anything older can go? Short of that, is there a way to move everything under C:\ProgramData\Solarwinds to D:\?

I'm trying to implement this but for the life of me I cannot find any kind of data point that tells me a new node has been discovered. I would have expected to find an event, or a "firstDiscovered" datetime stamp somewhere?

No, it fails because a CIF share is not a Windows host.

@Steven Carlson, I hope you didn't mind that I unmarked your answer correct as it did not address the actual question. While it is helpful to know that the component provides more detailed information, it does not provide the information I am looking for. Again, thank you for your detailed response. I am sure it will be…

Thank you for your detailed response. It seems there are other needed values that are missing to help identify the actual cert on the host. For example: Subject: CN=my.site.com, OU=Domain Control Validated It strikes me odd that I can get this data when I use the target host as a component test target but not get the data…

Nothing specific. I believe I got the profile Id from the Orion Web log and then looked in [SolarWindsOrion].[dbo].[DiscoveryProfiles]

Thank you for the reply. When applying this template, it wants you to select a node from the node list and doesn't give an option for selecting an IP address. IP3 doesn't appear to be a node and when I try to add it, I get nothing. FWIW, this cluster is an Active Active SQL configuration. Interestingly, I found that Host1…

Correct. I need some metric or value that indicates that it is passive that I can use in the alert to suppress the trigger. I can't really be chasing which is active and which is passive with a custom property unless that value is set automatically when the switch occurs.I would have hoped I could pick that up with…

I see there is an RC out that provides this, when do we expect that to be GA?

Where are you finding documentation that describes all of the functions you can use with the API?

Doesn't seem to save the setup as you have suggested. Each time I have to go in and reelect all the interfaces before importing...doing a one time discovery. Maybe its different if I schedule it?

Appreciate your input and I agree that DirectLink may create more issues then it solves. As for disabling it and using the service account with windows pass through. I need this screen to go right to that NOC view when its rebooted. If I require a login screen, even with pass through enabled, I'm prompted by the browser to…

I had a DBA ask me if I could tell him what queries were running on a host 2 to 3 hours earlier. The best I could do is go back 1 hour. I get why...I turns into a lot of data when multiplied over 200 SQL servers.

Does adding DPA provide that ability?

That of course was the first thing I tried but, that doesn't seem to work. The alerts sit in my Active alert list with a green dot indicating the the Primary condition interface A is Up. I've also tried a simple primary trigger with mixed results. with reset condition

I'm wondering if you have anymore detail on configuring an alert from the SQL Error Log you displayed in your post? I can;t seem to figure out what component or item this alert would be built from?

Let me guess, if you try to install the patches on the secondary, its says the patches are not applicable? These are the patches I have on my core and my secondaries KB3186568KB3192137KB3211320KB4013418KB4023834KB4035631KB4091664KB4132216KB4457127KB4457131

Some have found that removing this KB4103720 helped.