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!
Hi. I've added an enrichment property to my logs called 'runSession'. It is the ticks of the current time when my app starts. The idea was that it would be applied to all my logs so that I could quickly everything from the 'last run' (this is for dev time). I can read it in Seq with this query. select max(runSession) from stream I was hoping to create a signal that would run this query, get the result and then filter on that - thereby allowing a quick way to filter to logs from the last session. Is this possible? Thanks :-)
Posted by DAMIEN F SAWYER 2 years ago
Hi! I log the duration of different things to SEQ. And now I'm trying to create a dashboard that will show how many logs there are in different duration ranges. For example, I'd like to have a plot for the number of logs with duration 0-5seconds, one plot for logs with 5-10seconds, one for 10-30seconds, etc. Is this possible? I'm trying something like this, but I cant get it to work select COUNT(*) as NumberOfInserts, SUM(duration > 5000) as slow, SUM(duration > 10000) as slower from stream where EventId.Id = 99 group by time(1h) limit 10000 Would it be possible?
Posted by Joel 2 years ago
Hi I would love to be able to expose some Seq dashboards to people that is not users in Seq. To somehow be able to select a dashboard, or individual widgets from the dashboard to be made public. I would also like some way of creating mincharts or banners that could be embedded in other pages. E.g. i would like to write a query (connections per minute), and see the resulting number in a banner or small image in our TFS home page. This would be a bit like badges in sonarqube: https://docs.gitlab.com/ee/user/project/img/project_overview_badges.png
Posted by Henrik Jepsen Gering 2 years ago
Hi, We are looking at your software to integrate into our own programs to log errors and produce a dashboard of queue lengths etc. We have a present 15 Programs we would like to monitor. We are interested in the queue length of each program (sql query will get this information) and if it goes over a certain number an email alert is sent to a central email address, we also want to have the 15 programs listed on one dashboard with the queue length in real or near real time, detailing the program name queue length and last time checked and if possible a visual traffic light Green ok Amber getting close Red over queue threshold this dashboard would be shown on a 65 inch screen. is this possible with your software ? (more a dashboard question)
Posted by steve tasker 2 years ago
We are running Seq in a hosted environment where SSL is terminated at the network gateway and all traffic that are coming in to Seq is on http. The problem we are experiencing is that when you log with Azure AD it goes to http instead of https. How can we fix this? When we installed seq it was installed in http mode since ssl is terminated on the gateway.
Posted by Rune Synnevåg 2 years ago
Currently, Seq has Self Signed Certificate binded but I want to change it to CA-Signed Certificate. For that, I uploaded wildcard Certificate in Certificate Store on Server where Seq is installed and then executed following commands seq bind-ssl --thumbprint="THUMBPRINT OF CA-SIGNED CERT" seq config -k api.listenUris -v https://hostname (hostname= seq.test.domain.com) seq restart then I removed the self-signed certificate from the store. Seq updates the seq.json file to new api.listenUris above from http://localhost:5341. But it doesn't work. i.e the new hostname but I get an error saying "This site can’t be reached". Is there something I am missing please let me know or is there any other way to enable SSL for seq.
Posted by AP 2 years ago
Hi DataLust Team and contributors! We have a Seq server that prior to upgrading to 4.2, we used to provide analytical client usage data for our organization. Reports were updated and cached so that the entire time span was never requeried. In 4.2, we are seeing 30 day time span queried, which for 8GB of RAM on our Seq server, is not ever completing before the timeout expires. This has effectively disallowed us from using Seq for reporting and we have been using manual database queries instead. Is there any intuition into this situation you can provide for our organization?
Posted by Beshoy Hanna 2 years ago
I'm looking into the Sql query syntax for generating time series reports via Sql Queries over the Web Interface. If data is store as a string (i.e. a collation of named values via a Dictionary), is there a way to plot those values in Timeseries? I tried a few variations using the query (select @Timestamp, Telemetry.ValueName from stream where Telemetry.ValueName is not null): "ValueName": "0" => This did not plot "ValueName": 0 => This plotted as expected. Is there a way to tell Seq to convert a string value to numeric for reporting purposes?
Posted by Aaron Schnarr 2 years ago
 {"@t":"2018-07-18T19:05:34.5554422Z","@mt":"Error serving {RequestUrl} (token: {ErrorToken})","@l":"Error","@x":"System.OverflowException: Value was either too large or too small for an Int32.\r\n at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)\r\n at Seq.Server.Web.Api.DataModule.<Query>d__5.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Seq.Server.Web.Api.DataModule.<<-ctor>b__3_0>d.MoveNext()","RequestUrl":"http://evg-credoseq01:8080/api/data?q=select%20count%28%2A%29%20as%20count%0D%0Afrom%20stream%20%0D%0Awhere%20%28%40Timestamp%20%3E%3D%20DateTime%28%272018-07-18T19%3A00%3A30.000Z%27%29%29%0D%0A%20%20and%20%28%40Timestamp%20%3C%20DateTime%28%272018-07-18T19%3A05%3A34.342Z%27%29%29%0D%0Agroup%20by%20%40Level%0D%0Alimit%2010000%0D%0Afor%20window%285s%29%0D%0A&signal=&timeoutMS=40000000000000","ErrorToken":"e9cf1ba7899a4ab38b39540d19c7288a","RequestId":"6eaee67b-fc25-4d58-9517-8d9bb597535d"}
Posted by Beshoy Hanna 2 years ago
Is there a way to set an alert that allows for spikes? For example, say I'm processing messages in a queue from an external process I control. Messages are process extremely quickly from the queue and I have an alert set for count > 100 to ensure the process feeding the queue hasn't stopped (which it occasionally does). Periodically, an external process dumps 2000 messages to the queue, triggering the alarm, but these messages are processed quickly enough to clear the queue within twenty minutes. Is there a way to take the Max value across the timeslice window and compare that to the current value when setting the alarm?
Posted by Kevin Rich 2 years ago