mwb

Any idea where the same would be accomplished at this point in time? There doesn't appear to be a view.master in the Orion website directory any longer.

OMG - why didn't I know about this sooner? Why was't this upvoted to the top immediately. This is exception as a custom charting solution!

I'll second this - the web report works fine for an output, but not to write a SWQL query or a Report Writer report to be displayed on a view somewhere. The data is in the database, it shouldn't be a big deal to reference it directly.

How in the world am I just now finding this?

Setting no longer exists at that location. Anyone know where it is presently?

Old post, but I stumbled across it. * WeekDay(d) - Returns the day of the week of d as a number, with Sunday = 0, Monday = 1, ..., Saturday = 6. Available in Orion Platform 2016.1 and later. SWQL Functions · solarwinds/OrionSDK Wiki · GitHub

Still ain't great or easy, but this helped a lot: Unable to add data series for a report's SQL-driven custom chart

Any solution here? I know its a conflict between the account limitation and the SQL query, but I'm at a loss as to where its actually checking or how/why.

I have not - I'm running SQL 2017 in two instances and while my main Orion nodes are still on Server 2016, I have more than a dozen APEs on Server 2019. I have had issues with the current version reporting into SQL in a timely fashion over slower connections, acknowledged by Support, but I believe that is independent of…

Strangely when I use this query below, it works perfectly in SWQL Studio, but plugged into an Orion Custom Query box for a dashboard exempts some entries for reasons I can't discern. Anyone able to explain?

Answered my own question with these threads: SWQL Query Integer Conversion Help convert SQL to SWQL The real issue was both SWQL use of CAST/CONVERT and the modifications for DATEADD. This will convert in SWQL (UTC in my case): ToUTC(AddSecond((0+<MYEPOCHTIME), DateTime('1970-01-01 00:00:00'))) as SyncTime_UTC

Silent release? my NTA is having issues displaying, I look at its on 4.2.0. But the version on the site listed as 4.2.4 is an install for 4.2.0-b1585, which is the same as I ran previously a week ago. I have to call support because something is up and I need it corrected.

I have the exact same issue. Long story short, I had to execute on an alert to send a report only if certain criteria were met. I pointed the alert email at the report URL and sent as HTML within the email. After recent Orion changes, this is no longer possible and I was told that it was no longer possible to send anything…

I've had a similar issue after upgrading my poller VM to Windows 2016.

I'm seeing the same scenario. Doesn't make much sense to me either.

This would be a great idea.

Vote here for another option! - https://thwack.solarwinds.com/ideas/2836

This seems to have busted fully in the sense that in SAM 6.3, the only way to email a webpage is now as an attachment - so there's not even a way to sent SWQL results on a page into the body of an email. I've opened another ticket.

I'm staring at the same thing currently. Rather than being emailed the page as it would display in SAM, I'm being emailed the text of the SWQL query.

I think I already answered my own question with SolarWinds timezones and SWQL differences striking again. SWQL GETDATE() returns the local time of the web user whereas SQL GETDATE() returns the time of the database. In my case, I'm looking at two windows of time that are two hours apart from each other. Sigh.

Additional difference sighted between SWQL Studio and EOC - for some reason, any query in EOC to touch Orion.HardwareHealth.HardwareInfo returns invalid. I don't know why it would be the schema in one place and not the other - EOC results in this even when I limit to the Site that I'm running the SWQL Studio command on…

The dual selection of value also fails when attempting to self-join to create columns (as PIVOT does not work with SWQL). This for example: select NodeID, v.Node.Caption, v.VolumeID, v.Caption, v.VolumeType, v.VolumeSize, ram.VolumeType, ram.VolumeSize from Orion.Volumes v JOIN (select NodeID, VolumeType, VolumeSize from…

Another strange difference is that FULL JOIN works for SWQL Studio, but for SWQL on EOC, FULL JOIN does not function. There's no simple way to look at what error the EOC is seeing...

Please vote on this feature request to allow users to mix polling options so we're not forced to choose between SNMP hardware details and WMI asset and disk information: https://thwack.solarwinds.com/ideas/2836

I believe this may be hard-coded. I've been looking for a way to change that file name formatting and haven't found it.

There also appears to be an error(?) where two values with the same column name cannot be selected, even if they are renamed: select NodeID, v.Node.Caption, VolumeID, v.Caption, VolumeType, VolumeSize from Orion.Volumes v This does not work on the EOC - it returns the last "caption" value twice. However, this works…

And even with this simple SWQL query running against one node, I'm returning TWO results on EOC set to query against just one Orion, instead of the one that returns on the SWQL Studio on the Orion instance itself. WHY? select n.Caption, IP_Address, TOSTRING (ram.VolumeSize/1024/1024/1024) + ' GB' as RAM, ram.VolumeType as…

It appears to be something with FULL JOIN versus JOIN - but again only on SWQL on EOC. I would welcome any thoughts.

Switch from ${CREDENTIALS} to ‘${CREDENTIAL}’ . I'm not clear how it altered when the OS of the APE updated from 2012R2 to 2016, but this seems to have done the trick.

It appears to be there currently. Unless I'm mistaken, it appears primarily to be for compatibility with NPM12 - but with SAM 6.3 in Beta 3, I wonder how much longer we'll have to wait for that update.