monitoringlife · Monitoring Engineer · ✭✭✭✭✭

Thanks, I missed a bit when I cleaned up my custom properties.

you got this! Sure someone smarter has something. If not here is how to set it up. just copy/paste the WHERE clause into a 'custom SQWL alert' and see if it works for you. Alert logic WHERE Nodes.UnManaged = 0 --Node has not been unmanaged AND Nodes.Status != '2' --Node is not down. AND Nodes.LastSystemUpTimePollUtc <…

I set up an alert/dashboard to let me know when we were not getting monitoring data (cpu/disk/etc). Depends if you are doing agent or agentless. I do agentless and query on Orion.Nodes.LastSystemUpTimePollUtc. This is from my dashboard (minus bits I flavor in from custom properties). Alert works the same, just set to…

@"stevenstadel" is nicer, here is a copy of mine that is fairly simple and might be easier to read SELECT N.NodeName, N.UnManaged, tolocal(N.UnManageFrom) as UnManageFrom, tolocal(N.UnManageUntil) as UnManageUntil, N.DetailsUrl FROM Orion.Nodes N WHERE N.CustomProperties. Just need to fill the name of the custom property…

Sorry for the late reply. There was no workaround. I ended up using another authentication system (which is likely not an option for most organizations).

@"serena" was there any update on 'CORE-13349'? Is there any way for me to track those / self service looking for updates?

Sorry for the late reply. There is not a fix but a workaround. I wrote a custom reset condition. Copy the logic from the trigger and change the operator for the reset (trigger being greater than, change reset to less than).

@"tony.johnson"was there a resolution to this? We are still broken (case# 00684731).

Thanks for the update!

I feel the same, (sorry if this sounds bad) but I was excited to see a forum post and know I am not the only one. Interesting note, authentication to SWQL Studio thick client works and I get prompt results.

This will only work for single domain logins. If you have external (transitive trusts) it will not allow logins (only logins from the domain configured for LDAP).

@"sturdyerde"thanks for the reply. For anyone else interested the new template names are: * Orion Server 2020.2 - Main Polling Engine * Orion Server 2020.2 - Additional Polling Engine * Orion Server 2020.2 - Additional Website

@"danielleh"what is the resolution? I am still seeing the missing metrics.

Interesting update. We enabled 'automatic logins' and that does allow authentication (assuming fresh session and you have to login via the popup ntmlv2 box vs SolarWinds WebUI).

@"tony.johnson"your link is not working for me (tried in a few browsers).

Yes were blocking all outbound internet traffic.

Also got this error, ": ALTER TABLE SWITCH statement failed because column 'AvgIOPSTotal' at ordinal 3 in table '". A re-run of the configuration wizard worked.

Had to re-join all my SolarWinds servers to the domain, but MS-API login is working again. Recommend giving that a shot and seeing if it helps.

@"m_roberts"thanks for the list! Need to update to 'service-now'. Alertinghttps://<API-SubDomain>.servicenow.comIf using ServiceNow alert integration. Replace API-SubDomain with your configured API URL

I have been looking for checksums and even reached out to support about it (and preferably getting pgp signatures). Have not heard back yet. Thanks for linking that page, first I have seen it. Does not look like it includes the most recent updates HF1 and 2.

Also having login issues with AD (msapi) authentication. Local accounts still work.

What I linked is a dashboard, you can click on 'last login' to sort. If your using AD/SAML you would not see records until the user actually logs in. You would have to pull the AD group (powershell/cmd) and compare against who is missing from Orion DB.

aLTeReGo​ I use the 'offline installer' by default on my MPE that has internet access. I have several APE's that don't have internet access. It is my understanding that using the offline on the main will copy that to the additional servers and will be a smoother experience? Can you confirm best practice for mixed internet…

I understand the frustration. cdt_mueller wrote: having to go into Alerting and trying to figure out how to find that monitor. Frustrating. The alert wizard should help you auto complete the application/component name. I usually have the application monitor opened on a 2nd screen/tab and just paste in the name.

Try something like this

I am also on 2019.4. I would throw it in notepad++ and make sure no extra spaces/characters/or breaks got added in.

dark235 thanks for the info and your time explaining. I personally only use groups for state and suppression. All my alerting is custom property and NPM/SAM Template based. There are a ton of people on Thwack (many smarter than myself) that can likely help you get to where you want to be.

I would open a new thread as this question already has the answer set. Can you include a screen capture on what your trying get in the alert?

Support had us do this on two of the impacted APEs. Resolved the issue starting the service during the install. Interesting its only needed on some APEs and not others.

You ever figure this out?