mwb

On top of that, there is an acknowledged problem with the current 2019.2 HF1 where polling falls behind on any APE that is connected to the database over a slower connection (even when the APE worked just fine in previous versions). We're experiencing this issue on only four or five APEs out of 20+ on two Orion instances.…

Awesome! That let me query out exactly what I wanted. Using join with Component, Application and Node tables I was able to drop exactly what the client was looking for into a report. Thanks for the assist!

I'm curious if you ever made progress with this. I'm looking at some Emulex HBA cards that need monitoring, and while it makes sense that I would have to do a new poller for the OIDs specifically, this is the only Emulex OID that I can come up with and it returns nothing in the SolarWinds MIB browser. Thoughts?

No longer exists - not sure it ever did for SAM.

This helped tremendously. While this script was more involved than what I wanted, I was able to use it as a template and get to exactly where I wanted to be. One note, since I have so many polling engines, I set this up to be dynamic instead of hard-coded as it is in the query above - this pulls the EngineID from the…

I've just discovered that this still appears to be broken in SAM 6.3.

<!-- Some settings from appSettings/userSettings were moved to Centralized Settings https://cp.solarwinds.com/display/OrionPlatformRD/Migrated+settings --> Apparently the settings moved: Orion Platform - Advanced Configuration - SolarWinds Worldwide, LLC. Help and Support

Actually drop "ToUTC" at the start of that - it was scrambling it up more.

Boo frickin' ya! I have to do some clean up with nodes that are cluster IPs that I've removed CPU for - but this is sweet and potentially saves me thousands of component monitors polling those servers just to see if SNMP is still responding!

This was embarrassingly helpful.

Much faster than it was a year ago, but as a side question, how can we just ditch the legacy canned reports if we no longer want them? It seems like no matter where I remove them from, the come back and are queues to be imported again.

Could have something to do with it.

Worked like a charm - thank you.

Perfect! Tested and it works - thanks as always aLTeReGo, your assistance on these boards have often saved hours of frustration. I had no idea that WMI had that limitation.

Yes, oddly I looked at the Real-Time Event Log Viewer but could not manage to make the EventID appear there.

I've pointed out frequently to reps that this is a great value-added product that would appeal to very large organizations (we have four SAM, two NPMs, two VMANs, two SRMs). I understand that there is less development because the user base is smaller, but they're missing an opportunity here.

All sites are running Orion 2017.3.3 SP3. A thread in the EOC is open too and they made some suggestions. There's definitely differences between SWQL Studio and SWQL in EOC - the obvious being 'FULL JOIN' vs. 'JOIN'. That's easily demonstrable. How would I go about gathering SWIS EOC logs? You say ideally in SWQL Studio -…

How is AppInsight utilized to display multiple results from a custom query? It's a shame that this can't be done for simple data display a single component at a time.

Can anyone lend a hand getting this cleanly into SWQL format? Runs great as a SQL query for reports, but what I'd love to do is stick it on the dashboard with a custom SWQL query. I've tried my hand at it but something isn't formatted quite right. SELECTa.NodeID,a.Caption,a. Status,a.MachineType,MAX (c.DateTime) as…

Oddly the nested filter is not working in SWQL - when I return: JOIN (select NodeID, VolumeSize, VolumeType from Orion.Volumes where VolumeType='RAM') It is not in fact filtering the sub-query based on the VolumeType. It's returning both the entry for the RAM and a boot volume C: - despite C: being "fixed disk" in the…

As stated before, you should not be using SNMP and polling through the VMware API (via direct ESXi Host or via vCenter server), at least for NPM 12.2 which is when I first saw this information as a warning notice on the Edit Node settings page. They poll the same information and there are issues with how SolarWinds handles…

What if I am seeing the issue with new application monitors on an additional poller? Is there an expected delay before the data is fully processed into the database and becomes available to the web page?

Although, I will add for anyone reading this and wanting to accomplish the same, I was able to take my SQL query, pull it apart and rewrite it without PIVOT for SWQL by doing two JOINs for the ComponentStatisticData and selecting each as a different value. Ends up displaying on the dashboard view exactly the same as the…

Confirmed as bug. Tech is checking JIRA and will file if it's not already been reported.

I changed to just "join" instead of "left join" to exempt NULL Last_Polls for nodes like old ESXi boxes and cluster IP instances with no CPU polls.

Do you mind sharing the query? We've been facing similar issues and going in circles with Support for weeks.

there is a distinct time difference between the database values when querying through SQL or SWQL. These are from the same server desktop session - what would account for a four hour difference in the times returned by the queries in the screencaps below?

The only issue with that is that the MAX is absolutely required to return the latest DateTime instead of every datetime on every CPU poll. This is a modification on the technique that others use to measure SNMP polling failures by reporting on the last DateTime of a CPU poll and how far it differs from the current time.…

This is huge and thanks for sharing - saved me so much find and replace.

I'm looking for the same. I may be making an error, but just running through the example above doesn't seem to work with the asp page.