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'd like to run a query that gives me the number of some particular events grouped by year and month. My resultset basically needs to have 3 columns: count, year number, and month number. If I was querying against SQLServer, I'd use a [DatePart operator] (https://msdn.microsoft.com/en-us/library/ms174420.aspx) - is there an equivalent to DatePart in Seq SQL? TIA!
Posted by Darren Bruning 3 years ago
We started getting the following error when the Email Digest app tries to send emails: System.FormatException: An invalid character was found in the mail header: ','. at System.Net.Mail.DotAtomReader.ReadReverse(String data, Int32 index) at System.Net.Mail.MailAddressParser.ParseDomain(String data, Int32& index) at System.Net.Mail.MailAddressParser.ParseAddress(String data, Boolean expectMultipleAddresses, Int32& index) at System.Net.Mail.MailAddressParser.ParseMultipleAddresses(String data) at System.Net.Mail.MailAddressCollection.ParseValue(String addresses) at System.Net.Mail.Message..ctor(String from, String to) at System.Net.Mail.MailMessage..ctor(String from, String to) at Seq.App.DigestEmail.DigestEmailReactor.SendBatch()
Posted by Ryan Adler 3 years ago
Hi, I received an alert stating that 5GB space left in the database and when I checked the logs I see that there are 3 folders exist [screenshot](http://screencast.com/t/154pYoF2M) The set the retention time to 2 hours in the settings but it looks like it doesn't affect old events. Then I tried to delete all events, it says deleting started but so far no change on disk size. 1. Can I delete those folders in the screenshot (at least old ones) 2. How can I make sure it deletes all the past events and gives me free space? Thanks in advance
Posted by Cengiz Ilerler 3 years ago
I have created two instances of seq, I use one for system log messages like info, warning, error etc. The other instance is only used to audit log messages .e.g. when a DB entry is added, updated or deleted. For the audit instance I would like to be able to generate complex reports. I can see that seq supports the ability to write simple sql queries and then present them in a graph/chart. However what if I want to run multiple queries and plot that on a pie chart. For example I have an event that has a property CardNumberDetails with a field status. And the status can have the values unassigned, assigned and failed. I want to see a pie chart with the number of events that have the each one of these status Is it possible?
Posted by Mudassar Jafer 3 years ago
Hi, A couple months ago I somehow subscribed for e-mail notification from SEQ on errors. Since then my account has been deleted & recreated, but I'm still getting those e-mails. I have no idea how to unsubscribe from those notifications. Also what used to be a couple e-mails a week now became thousands of e-mails daily. Thanks
Posted by Jakub Leśniak 3 years ago
We tried to clone-migrate our SEQ configuration to a faster server and restored a backup from slow server on the new one. Backup said - all was restored successfully, console shows that integration apps were restored too, but new server hasn't got any settings from old one - nor signals or backup settings neither users and app keys. What is actually included in the backup ?
Posted by Alexey Shcherbak 3 years ago
Would be nice to have "Backup now" button in backup section of SEQ, cause if new version was installed on the server and one want to explicitly have a backup in new format (as docs suggesting to have an exact version match for restore) - it's important to allow admins to do at least manual backup. Ideal scenario would be to automatically back up all settings in new version independently of the set up schedule e.g. - new version installed - new version of settings backup appear in /Backups on it's start. So in case of any issues - we can reinstall the latest version of SEQ and have a restore-ready .seqbac file.
Posted by Alexey Shcherbak 3 years ago
Hi, I'm currently having an issue when trying to import seqlog in Python. ``` Python 2.7.12 (default, Sep 1 2016, 22:14:00) [GCC 4.8.3 20140911 (Red Hat 4.8.3-9)] on linux2 Type "help", "copyright", "credits" or "license" for more information. >>> import seqlog Traceback (most recent call last): File "<stdin>", line 1, in <module> File "/usr/local/lib/python2.7/site-packages/seqlog/__init__.py", line 5, in <module> from seqlog.structured_logging import StructuredLogger, StructuredRootLogger File "/usr/local/lib/python2.7/site-packages/seqlog/structured_logging.py", line 8, in <module> from queue import Queue ImportError: No module named queue ``` I tried to install QueueLib but it didn't help. I didn't see similar issue in the already asked questions. Does someone have an idea for this dependency problem ?
Posted by thibault deheurles 3 years ago
How can I group by json collection? For example select count(*) as count from stream where RequestInfo <> null group by RequestInfo.Headers order by count desc limit 10 RequestInfo.Headers is key value collection I want to group by User-Agent key name. [{Key: "Cache-Control", Value: […], _typeTag: "KeyValuePair`2"}, {Key: "Connection", Value: […], _typeTag: "KeyValuePair`2"}, {Key: "Accept", Value: […], _typeTag: "KeyValuePair`2"}, {Key: "Accept-Encoding", Value: […], _typeTag: "KeyValuePair`2"}, {Key: "Accept-Language", Value: […], _typeTag: "KeyValuePair`2"}, {Key: "Host", Value: […], _typeTag: "KeyValuePair`2"}, {Key: "User-Agent", Value: […], _typeTag: "KeyValuePair`2"}, {Key: "Postman-Token", Value: […], _typeTag: "KeyValuePair`2"}, {Key: "MS-ASPNETCORE-TOKEN", Value: […], _typeTag: "KeyValuePair`2"}, {Key: "X-Original-Proto", Value: […], _typeTag: "KeyValuePair`2"}, {Key: "X-Original-For", Value: […], _typeTag: "KeyValuePair`2"}]
Posted by nemke 3 years ago
I have a set of logs that I am generating with a structured ApplicationInformation class that has a set of, well, application information properties. On a simple property there is an awesome "Show as Tag" feature which is perfect. However, I can't seem to find this on structured properties. To add to my confusion, when I mouse over one of the properties of my structured property (example: the Name of ApplicationInformation or ApplicationInformation.Name), my cursor turns into a hand symbol, indicating that it can be clicked on and/or navigated. However, when I do so, nothing happens. I tried to take a screenshot of this but the cursor is removed when the screenshot occurs. Hope this makes sense. Please let me know if you have any questions around this. Thank you, Michael
Posted by Michael DeMond 3 years ago
When saving without a max batch size, I get: Could not save app instance A value must be provided for the 'Maximum batch size' setting. Although the setting itself says: The maximum number of events to package into a single batch. If not specified, the default limit of 50 will be applied.
Posted by Ryan Adler 3 years ago
Is there a way to customize level bullet colors? If not, can you please make different those? Right now it looks like - Critical & Error have same color, - Warning is OK, Information has no color (or white), - Debug and Trace are gray which makes it no good for review process. Thanks in advance  and
Posted by Cengiz Ilerler 3 years ago
Hi, is there a full reference of operators available when using SQL queries? I have following query ```SQL select EventData.SubmissionId as Submission, EventData.Database, EventData.Schema, EventData.Table, round(DurationMilliseconds / 1000, 0) as DurationSeconds from stream where Has(EventData.Table) ``` which uses undocumented operator "/" and the "round" function - also undocumented. This is kind of cool, but I also need to concatenate Database, Schema and Table into a single string and cannot find a reference of allowed operators and functions anywhere. Cheers Dusan
Posted by Dusan Tkac 3 years ago
Hello Community, Well, I am happy to say that I am *finally* digging into Seq! :D It's really awesome. I have a few questions though: 1) Is there a way to color-code the EventType based on the level? I see that Warning appears to be yellowish, but debug and verbose are the same color? It would be nice to get this configured. 2) I see that there is an "Arrival" property? I am curious how I get this to display along with anything else when the results return. Thanks for any assistance! Michael
Posted by Michael DeMond 3 years ago
I'm seeing the following error repeated (daily) in our logs: 2016-11-14 23:49:56.542 +01:00 [Error] Unable to compact extent "4/27/2016" Seq.SeqException: Defragmentation of 4/27/2016 failed; ESENTUTL returned -1022 at Seq.Storage.Events.Extents.Extent.Compact(Boolean full) at Seq.Storage.Events.Extents.Extent.TryCompact(Boolean full) at Seq.Storage.Events.ExtentCompactor.Compact(ExtentMap extents, CancellationToken cancel) Is this something that will resolve itself?
Posted by Benjamin Wegman 3 years ago
I know you're not responsible for a 3rd party apps, but the one I use https://www.nuget.org/packages/Seq.App.HipChat/ started throwing exceptions yesterday (after updating HipChat server to 2.0.7). However, this caused Seq to fail and stop as well. I had to disable the plugin in order to make Seq working again, but in order to do so I had to turn it on first (sick cycle and I lost some logs due to that). Eventually I managed to sort it out by removing the content of the "Extents" folder, then launching Seq and quickly removing the HipChat extension. This is not right that an exception in an app kills whole Seq. As a suggestion of solving the issue: would it be painful to provide an option that allows to disable an App ? Can't see anything like this at the moment - If it's not a big deal then it might be worth going one step ahead and changing the current implementation: on a Seq App exception it gets disabled instead of killing whole service.
Posted by Alojzy Leszcz 3 years ago