I'm logging data over to Seq that I want to chart on, but apparently can't unless it is coerced into the proper numeric type. I don't control the absolute source of the data so may have a hard time forcing numeric conversion. Is there a way that using a SQL select query from Seq I can coerce a string value to be interpreted as a number value so that I can properly chart it?
Posted by Norman Harebottle 4 years ago
There isn't a whole lot more than the the title question. Why are the @Timestamp values returned in a SQL query returned as Binary time values? I want to export the data as CSV, or at least be able to read it easily using the Seq table view which is challenging when it is in the binary format. Is there anything I can do to format that differently for CSV export?
Posted by Norman Harebottle 4 years ago
Hi, I know similar questions have asked before but the resolutions haven't seemed to work for my case so I was wondering if someone could shed some light on this for me. When installing seq and listening to an IP Address url on my server, it is easily accessible from both the server and networked machines. But when I try to install to a specific url, such as myseq.domain.com I get dns_unresolved_hostname. Also when using tracert, I get the message "Unable to resolve target system name...". I wonder if I'm doing something wrong, I also installed against an IP address and then added a rule to my hosts file for that IP address and the url but I get the same issue. What would be the best way to set this all up? Is there something I'm doing wrong. Where does the seq installation actually install when just supplying a URL, does it install to a specific IP address. I know it doesn't install to IIS, I do have other sites on that server in IIS, could that conflict in anyway? Thank you for your time!
Posted by Lloyd Powell 4 years ago
We were introducing Slack notifications into production today and ran into an issue when trying to achieve our desired state and what we are trying to do may not be possible. In our other platforms we have rules setup which alert (via PagerDuty, email, slack, etc...) when a certain number of errors (i.e. 10 fatal errors within 5 min timespan), alert the development team. Is something like that possible here? I can see that we can suppress a notification from resending more than every 10 minutes however as it stands it will send on the first fatal error every 10 minutes, not when the count exceeds X over Y.
Posted by James Legan 4 years ago
We've been using Seq with Active Directory authentication in our current environment. We're now moving to an environment that requires a smart card/PIN combo instead of a username/password to authenticate an Active Directory user. We use Kerberos in IIS for our own application, but can't tell if Seq supports this model. Have you encountered this use case before, and is it supported?
Posted by Brian Potocki 4 years ago
Hi, I have an Azure VM running Seq at the moment but want to move it to a new VM with SSD storage (the existing VM doesn't support Azure premium storage disks). I have tried copying the whole c:\programdata\seq folder across to the new machine but when I try to start the service, it fails with a fatal error in the seq log file: 2016-12-15 03:24:36.026 +00:00 [Fatal] An unhandled error occurred System.Security.Cryptography.CryptographicException: Key not valid for use in specified state. at System.Security.Cryptography.ProtectedData.Unprotect(Byte encryptedData, Byte optionalEntropy, DataProtectionScope scope) at Seq.Server.Cli.RunCommand.Run(TextWriter cout) at Seq.Cli.Command.Invoke(String args, TextWriter cout, TextWriter cerr) Any help in doing the migration would be appreciated. Appart from wanting to retain the log history, we currently have ~100 signals configured and at least 30 API keys that need to stay the same as well.
Posted by Eamon Hetherton 4 years ago
I had accidentally installed Seq on the windows disk on my Azure Machine. I tried to move the installation directory over to new disk through the Seq Service Administration. I didn't realize it was going to do a full install and wipe everything out. Is there a way to backfill the data to ensure I have the history?
Posted by Shawn Dillenbeck 4 years ago
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 4 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 4 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 4 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 4 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 4 years ago