Fetching records from/before a particular date - SWQL

Hello,

I'm trying to fetch records of inbound traffic after a specified date using SWQL. I've tried using a where clause as so

SELECT DateTime, InAveragebps, OutAveragebps FROM Orion.NPM.InterfaceTraffic WHERE DateTime>'2016-04-04'

But I'm getting error at "DateTime>'2016-04-04'"

Is it that, we have to make use of a different method to use where clause with date in SWQL??
Thanks.

Find more posts tagged with

SWQL

swql_studio

You can do it by editing the SwqlStudio.exe.config file that is located in the same directory as SWQLStudio.

Look for the xml that looks like this

<setting name="OperationTimeout" serializeAs="String">
<value>2</value>
</setting>

and change the text in the value element from "2" to the number minutes you think you need.

This is a valid swql syntax. Can you provide the complete error details.

Screen Shot 2016-04-22 at 5.58.49 PM.png

I got this error.

Use the "Orion (v3)" server types in the SWQL Studio connection window.

@tdanner Hello, I tried the Orion (v3) server types. I'm getting this error.

Screen Shot 2016-04-25 at 10.51.39 AM.png

It says i've to increase the configured timeout. But SWQL studio does not have any option to increase the configured timeout.