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!
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 about a year 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 about a year 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 about a year 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 about a year 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 about a year 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 about a year 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 about a year 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 about a year 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 about a year ago
Seq seems to be using a large amount of memory on my Windows 10 machine. I'm using Seq version 4.2. Here is a screenshot of my Task Mangaer: https://i.imgur.com/P6GTHuk.png. This screenshot was taken right after a reboot.
Posted by Ryan Buening about a year 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 about a year 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 about a year 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 about a year 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 about a year 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 about a year ago