Welcome to the Seq documentation hub. You'll find comprehensive guides and documentation to help you start working with Seq as quickly as possible, as well as support if you get stuck. Let's jump right in!
When I refresh my query to obtain events I seem to be not getting latest data and it seems to be limiting the amount of data returned. http://[MySeqServer]:5341/api/events/signal/signal-175?count=100 This is returning a json response which I'm happily consuming but... how do I tell it to get latest?... order by timestamp descending or pass in some date ranges? and when I remove the count... it seems to not return everything but is picking an arbitrary amount... like 146 records... I don't want all the records - I kind of wanted a certain amount of the latest records... maybe a days worth... ? What am I doing wrong? Help would be muchly appreciated :-) Thanks
Posted by Bob 3 years ago
Dear all, is there a way to concatenate a string to a query result? For example in the following query: select count(distinct(serial)) as Connections from stream where @EventType = 0xa427ae96 limit 1 which gives me the number of different devices which have contacted my webservice, I would like to add at the end of the number a string like this: " out of XX". While I am able to add a number, like this: select count(distinct(serial)) + 10 as Connections from stream where @EventType = 0xa427ae96 limit 1 I do not know how to add a simple string. With best regards
Posted by Daniele 3 years ago
Hello, We have a query using group by time(1d) in SEQ v4.1.7 . When we fill in the dates from 1/1/2018 to 1/2/2018, we get dates from 31/12/2017 to 30/1/2018 in the result set. It seems that there is a 1 day offset. How we can correct that. Thanks
Posted by Francisco 3 years ago
We are trying to restore a backup and receiving the following error: [17:27:42 INF] Restoring from d:\Temp\seq-Prod_20180207.seqbac Could not restore backup: Error converting value "Pie" to type 'Seq.Server.Data.Documents.Monitoring.MeasurementDisplayT ype'. Path 'Charts[1].Queries[0].DisplayStyle.Type', line 1, position 633. Both servers are v4.1.14 Any help is much appreciated. - n
Posted by Nathan 3 years ago
Hi, Sometimes we are experiencing weird situations with seq. Some of the events are sent to the seq server some not. I also developed simple unit test to check some formatting in seq and I don't see this logs in seq. Configuration is exactly the same like in application. Below I post my code: [SetUp] public void InitializeSequ() { LoggerFactory factory = new LoggerFactory(); factory.AddSeq("https://xxxxxxxxxl:5341/", "xxxxxxxxxxxx", LogLevel.Debug); _log = new LogService(); } [Test] public void ExecuteGeneric() { Action act = ()=> { try { InvokeExecuteGeneric(engine, formulaId, String.Empty, string.Empty, globals, compilationName); } catch (Exception e) { _log.Error(e); throw; } }; act.ShouldThrow<TargetInvocationException>(); } Can you tell me how to troubleshooting this type of issues? Check why we have not events on seq? Is there any seq log when error occur or something like that?
Posted by Marek Bigaj 3 years ago
Hi, Sometimes we are experiencing weird situations with seq. Some of the events are sent to the seq server some not. I also developed simple unit test to check some formatting in seq and I don't see this logs in seq. Configuration is exactly the same like in application. Below I post my code: [SetUp] public void InitializeSequ() { LoggerFactory factory = new LoggerFactory(); factory.AddSeq("https://xxxxxxxxxl:5341/", "xxxxxxxxxxxx", LogLevel.Debug); _log = new LogService(); } [Test] public void ExecuteGeneric() { Action act = ()=> { try { InvokeExecuteGeneric(engine, formulaId, String.Empty, string.Empty, globals, compilationName); } catch (Exception e) { _log.Error(e); throw; } }; act.ShouldThrow<TargetInvocationException>(); } Can you tell me how to troubleshooting this type of issues? Check why we have not events on seq? Is there any seq log when error occur or something like that?
Posted by Marek Bigaj 3 years ago
Hello, We're software reseller from Moscow, Russia. Our customer is interested in renewal Sec Business, Serial: SDES-01-3586495 Licensed-To: AO «Kaspersky Lab» Licensed-Users: 15 Enduser is Kaspersky Lab Please give me price and delivery information. Thank you in advance, Mikhail Kapyrin Systems 21 / Prodmag.ru email:[email protected] tel:+74996494952 tg:@mkapyrin http://www.prodmag.ru
Posted by Mikhail Kapyrin 3 years ago
If I run this: "SELECT mean(RTT) group by SubPacketType from stream" I get an error saying: "The query could not be executed. Syntax error (line 1, column 41): unexpected keyword `from`." But, if I check the docs they have an more or less identical example: https://docs.getseq.net/docs/aggregate-operators and the example there is: "select mean(ItemCount) group by ItemId from stream" Any ideas here? I wanted to upload a picture from the stream, but cant do it here when creating a post...
Posted by Ted 3 years ago
Hey, if I run a query, like: SELECT RTT from stream WHERE RTT IS NOT NULL where RTT is a prop I created ("round trip time"), Id like the results to be returned and look as the "signal" list does (with tags, clickable so I can view the rest of the properties etc), bit instead i get a plain text-list that I cannot work with at all. Question is - can it be done, to get a "normal" looking list?
Posted by Ted 3 years ago
I read that by default, seq should be using 90% of the server available memory, but I cannot seem to pass 70%. I had a 8gb RAM server, increased it to 16Gb, but even after many hours, Seq won't use more than 71%. I even tried to setup seq on the command line to use 95% or so, but it remain on 70. Is there any reason for this?
Posted by Natan Vivo 3 years ago
Is it possible to alias the grouped column in a SQL query? Its convenient that the grouped column is automatically included in the tabular output, but I dont see how we can rename it. Queries that group on expressions could benefit from an alias, for example: select count(*) as total from stream where IndexOf(UriStem, /\.[A-z]{2,4}$/) <> -1 group by SubString(UriStem, IndexOf(UriStem, /\.[A-z]{2,4}$/), 4) order by total desc
Posted by Nathan 3 years ago
Hi, I have received the SEQ "Professional License", how would I install this manually? Also I am interested in installing it via powershell, I've seen the previous posts "Provide license file during installing Seq using msi", and do not have a clear understanding of Step 4 in the reply: " This can be done using Powershell after the Seq service is installed and started, so: Install the MSI (assuming that you have automated this part) Start the service, using seq.exe start It may be necessary to wait a few seconds for the service to start up POST the license text to /api/licenses/license-server using a JSON body like: {"LicenseText":"Serial..."} "
Posted by MinhPham 3 years ago
Hi, I'm getting this error when I click over plus icon to add a new alert: vendor-1500420102219.min.js:2 TypeError: Cannot read property 'push' of undefined at e.value (seq-ui2-1500420102219.min.js:81) at e.value (seq-ui2-1500420102219.min.js:129) at fn (eval at compile (vendor-1500420102219.min.js:4), <anonymous>:4:194) at i (vendor-1500420102219.min.js:5) at p.$eval (vendor-1500420102219.min.js:3) at p.$apply (vendor-1500420102219.min.js:3) at HTMLButtonElement.<anonymous> (vendor-1500420102219.min.js:5) at Jt (vendor-1500420102219.min.js:1) at HTMLButtonElement.n (vendor-1500420102219.min.js:1)
Posted by Michel Ank 3 years ago
On the main screen: http://localhost:5341/#/events I type "something" and hit enter, URL changes to http://localhost:5341/#/events?filter=something and the UI updates to show the correct log entries. I hit the back button and the URL changes back to http://localhost:5341/#/events but the UI doesn't update at all and "something" still shows in the search box. Running Seq 4.2.476 on 64bit Windows 10 Enterprise (build 16299) using 64bit Chrome 63.0.3239.132.
Posted by James Gilberd 3 years ago
Hello, I'm trying Seq but I have problem about custom domain. I created windows server on Amazon EC2 and I installed Seq with http://seq.mydomain.com/ After I forwarded seq.mydomain.com to server IP on Amazon Route53. Now, when I ping subdomain, I'm getting corret server IP but I can not get respond from respond from seq.domainname.com. Best.
Posted by Ozgur 3 years ago