mwb

Any thoughts to add that color customization? SWQL custom queries are very useful for where the SolarWinds default doesn't quite get it done. I've been using the icons and links for a long while, but especially as the sizing of the columns is difficult to control, it would be nice to simply highlight data as "warning" or…

Also this is a puritanical to censor "d---ed".

This is a sample of what I've done in the past - joining multiple queries and then wrapping the whole thing in another select query. select c.NODE ,'/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N%3a' + ToString(c.NodeID) AS [_LinkFor_NODE] , c.ComponentStatisticData as Total ,…

Dell OpenManage is limited over WMI. https://thwack.solarwinds.com/ideas/2836 is a suggestion to allow SAM users to mix polling options to get both hardware and WMI asset information, disk performance, etc.

I've duplicated this issue with two different 12.1 or 6.4 updates so far.

There's still something odd going on with the UTC timing - this alert showed itself as ahead of UTC somehow. 

Thanks - yes, UTC occurred to me, but I didn't understand that SWIS was adjusting values to UTC even when they were server local to begin with - however, this only makes sense with the SWQL query if 'getdate' is returning local server in server time with no adjustment, leading to my MinuteDiff taking four hours and thirty…

SWQL (at this point in time, I know this is an old thread): WHERE DateTime > ADDDATE('day', -30, GETDATE()) AND WeekDay(DateTime) >= 2 AND WeekDay(DateTime) <= 6 ## (or WeekDay(DateTime) not in (0,1,7) AND HOUR(DateTime) >= 8 AND HOUR(DateTime) <= 16

The issue appears to have been UTC and SWQL and Custom Query treating 'GetDate' differently: Re: Re: Difference between SWQL Studio and Orion Custom SWQL Query

Good instincts, but I'm logged in as the admin account in both places, no Account Limitations. There's no View Limitations either. I'm distinctly under the impression that there is something different with how SWQL Studio and the Custom Query process the query. I've opened another thread to that end: Difference between…

Which would access via WMI and have the same issue that aLTeReGo pointed out above - but helpful definitely for anything that would work via WMI for sure.

Curious if you ever got a resolution on this? I stumbled across it again trying to send a very specific list of data through an alert on a trigger. Can't send a web report on a trigger, should be able to send a web page - one with my SWQL query resource, but again I'm seeing this email as just the text of the query itself…

My issue was that I didnt have root CAs for 2012. Don't know if that will help. Where to get root CA certificates for Windows Server now that Microsoft no longer updates them? - Server Fault

Perhaps this is where my confusion is - when writing SWQL for a report for EOC, you include the SWQL query and select which Orion instances you want to run on. I'm working from an assumption that EOC is simply running on each of the Orion instances returning the results, running as a UNION between the results sets and then…

Presuming that the custom property of "d01_Customer" is set up, try this 1=1 WHERE Nodes.CustomProperties.d01_Customer Like 'dcf*' I don't really know what the 1=1 does but SolarWinds Support had me add it to this resource previously.

SWQL query for those that may want to add this to a dashboard: Assistance with SWQL Query for Node UP/SNMP DOWN

No longer valid from what I can see.

"2) Avoid duplicated column names in select statement: "select v.Node.Caption, v.Caption from Orion.Volumes v" would be rewritten to "select v.Node.Caption as NodeCaption, v.Caption as VolumeCaption from Orion.Volumes v" - well I'll be damned. I swear that I labeled in the select statement and still ended up with a mess.…

Unless I'm completely mistaken, this appears to be possible now! I imagine it was with the database schema update where SolarWinds split the Nodes table to NodesData and NodesCustomProperties. At any rate, I added the resource and tested with a non-admin user and it seemed to work fine! now if i can just get the same on…

I am running into this exact same problem with the Orion GUI - however it strangely seems to be limited to a few pollers. Even odder, the same error appears in the Edit Template screen EVEN when the script was previously established and is currently polling fine!

From this link: VMware Polling / SNMPv3 It is correct/safe/useful to have ESX polled via vCenter and managed as SNMP node.

The actual issues are far more with the font sizing and white space taking up extra screen real estate. The gray on white is more an aesthetic choice, I can live with it and it's not causing real problems. The monochromatic look changed from colors (for instance the left-hand view tab icons) is just not a choice I would…

Support commented to me during troubleshooting that the jobtracker doesn't exist any more (SAM 6.3, Orion core 2016.2.100 currently), so that part of these instructions would be moot at this point.

Thanks for the feedback - it makes perfect sense that reducing the polling would cut down on the amount of data being passed and the amount queuing up. I'll have to look at getting the team to make some improvements on the SQL performance - its funny that everything works fine with the except of AppInsight for SQL. Didn't…

Conversely you can also add an entry to your hosts file on the primary Orion server to always resolve the name and IP together. http://www.howtogeek.com/howto/27350/beginner-geek-how-to-edit-your-hosts-file/ I did this and it seemed to work wonders. No need to edit websites table within the Orion database (unless you want…

Thanks @"tdanner", but it wasn't it - it was actually a character in the column names that I was establishing in the brackets (but hid from the public forum). The SWQL studio would let me name a column with a period ([text.txt] for example), but the the Orion engine - at least the SWQL in the web report builder, would not…

Well, technically CASE can be used to replace the volume names - it just won't have the dynamic properties in the same way. I'm already doing it with volume that I know are /opt<x> - it's just not as easy with volumes that may be /<x>opt<x> - because the first variable can be random strings of characters. So multiple CASE…

Sure, but there is no conversion being done on GetUtcDate() however it is displaying differently in the two examples above. The UTC time should be the same regardless if the web console is running on an EST machine or a PST machine.

My own dashboard resource for the same: SELECT Caption, '/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N%3a' + ToString(NodeID) AS [_LinkFor_Caption], EngineID as Poller, TOLOCAL(NextPoll) as NextPoll, MINUTEDIFF(NextPoll, GETUTCDATE()) as Poll FROM Orion.Nodes WHERE (UnManaged<>1 and Status<>11) and MINUTEDIFF(NextPoll,…