SELECT group_concat(rtrim(t),x'1f') FROM a SELECT max(iter), cx, cy FROM m GROUP BY cx, cy SELECT iter 1, cx, cy, x*x-y*y cx, 2.0*x*y cy FROM m SELECT 0, x, y, 0.0, 0.0 FROM xaxis, yaxis Yaxis(y) AS (VALUES(-1.0) UNION ALL SELECT y 0.1 FROM yaxis WHERE y<1.0), Xaxis(x) AS (VALUES(-2.0) UNION ALL SELECT x 0.05 FROM xaxis WHERE x<1.2), The following query computes an approximation of the Mandelbrot Set and outputs the result as ASCII-art: WITH RECURSIVE "C:\Program Files\Sophos\Live Query\SophosOsqueryExtension.exe" -verbose -socket \\.\pipe\sophososquery.sock "C:\Program Files\Sophos\Live Query\SophosOsquery.exe" -allow_unsafe -socket \\.\pipe\sophososquery.sock Some folks find it easier to develop queries from the cmdline as opposed to from central. Below shows how to launch the SophosOsquery.exe and the Extension we use for journal access. has both a great detailed explanation of the statements available in sqlite (Most are available in Live Discover but not all) and some excellent examples.įor this one to run with the output the way it wants I had to start SophosOsquery.exe from a cmdshell. For a good set of examples and explanation of what is possible with SQLite you can simply search the internet with your favorite search engine. You can see recursion used with the Process Tree queries we published and the WITH clause in a number of other queries where we want to build some sort of temporary table that another select statement will join with. Using the WITH and WITH RECURSIVE clause really opens up a lot of power.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |