The most recent content from our members.
Does SWQL allow for temporary views to be created using the WITH command? If so, is it used in a similar way to SQL?
Hi guys! Since SW still can't provide a convenient way to use sql/swql-queries with email actions, we have to use hacks like that (thank you, mesverrum) both issues were solved #1 So we had this SWQL query to gather some components info: SELECT n.Caption AS Node, ccs.ApplicationID, a.Name AS AppName, ccs.ComponentID,…
This is an overly simplified guide for "Keep the lights on" SQL to "Expert" SQL users wanting to jump into SolarWinds Query Language (aka Orion API) as fast as possible. Who can use SWQL? * Any user that has web credentials to the web console can use those credentials to run scripts. What is SWQL? * Orion SWQL or…
I have a advanced alert in which we are firing off an external application. What I want to do is send some additional data to this external application by running a SQL (or SWQL...which ever works), how can I make this happen? Here is the query: SELECT Syslog.Hostname_UNICODE, Syslog.Message FROM Syslog where…
Can any one helpme convert below sql query to SWQL. Basically this query give output in chart for custom time period.(exclude daily maintenance period 01.00am to 03.00am) DECLARE @StartDate DATETIME, @EndDate DATETIME SET @StartDate = dateadd(mm, -1, getdate()) SET @StartDate = dateadd(dd, datepart(dd, getdate())*-1,…
I wrote a query in SQL that provides bandwidth usage of interfaces during a specific time of day. We have multiple people manage different devices so we use account limitations for ease of use but the SQL report did not take into consideration these account limits. Because of this, I rewrote the query in SWQL, which did…
Hi, Is there any information/documentation about the relationships between SWIS object and SQL tables and columns? For example, Orion.NPM.Nodes => dbo.NodesData and dbo.NodesCustomProperties, Orion.NPM.Interfaces => dbo.Interfaces. At least, I think it should be for some specific table and objects.
I've been trying to convert the SQL for the availability report in report writer to SWQL for close to week. I'm not having much luck, beyond my current skill level. Anyone have time to help? I've pretty much determined that DECLARE and SET startements are out. The "WITH (NOLOCK)" also causes SWQL to choke. From what I can…
It looks like you're new here. Sign in or register to get started.