in Education by
I'm completely new in logging but familiar in SQL queries. I'm now experimenting with Serilog and Seq. I managed to make JSON lines log file with Serilog and could import the file into Seq by the seqcli ingest -i command. I can query my stream but in a very limited way. E.g. select * from stream works as shown on the screenshot below (the example file is Seq's own log): I can also query the @Timestamp, @Arrived and @Data colums as select @Timestamp, @Arrived, @Data from stream but I don't know how can I reach the properties inside @Data. I expect something like select @Timestamp, @Arrived, @Data.@[email protected] from stream but this doesn't work. How can I list for example the @Data.@[email protected] values? UPDATE Interesting that Seq shows something else than the original content of the file. This part: looks in the original file simply as this: {"@t":"2022-03-30T14:24:49.0999009Z","@mt":"Creating default workspace for {UserId}","UserId":"user-admin"} so, regarding this, I would expect select @mt.UserId from stream or some similar query work. JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

1 Answer

0 votes
by
When importing using seqcli ingest, you need to specify --json, e.g.: seqcli ingest -i ./some.log --json

Related questions

0 votes
    In Python 2.6, the str.format() has been introduced and has a slightly different syntax than existing % operator. ... %s" % some_info) Select the correct answer from above options...
asked Jan 22, 2022 in Education by JackTerrance
0 votes
    How is seq_along(5) different from seq(5)?...
asked Oct 16, 2020 in Technology by JackTerrance
0 votes
    How can we write JSON data to a file?...
asked Jan 11, 2021 in Technology by JackTerrance
0 votes
    Can We use comments inside a JSON file? If so, how?...
asked Jan 11, 2021 in Technology by JackTerrance
0 votes
    I'm trying to query two JSON files that I put in a src/data directory. I installed gatsby- ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked May 4, 2022 in Education by JackTerrance
0 votes
    I'm trying to query two JSON files that I put in a src/data directory. I installed gatsby- ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 24, 2022 in Education by JackTerrance
0 votes
    Can we use JSON instead of YAML while developing docker-compose file in Docker?...
asked Jun 21, 2021 in Technology by JackTerrance
0 votes
    I have a JSON File with database environment configuration called env-config.json like this: { "LATEST":{ ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 17, 2022 in Education by JackTerrance
0 votes
    I have a json file contains a icons object like this: "icons" : { "logo" : "fa fa-caret-down ... , JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 9, 2022 in Education by JackTerrance
0 votes
    My code is about bookStore with list of books. I need to extract all data(books) from a JSON file and put them in a ... console.log(e); } } function bookToHTMLRow(book) { return `...
asked May 14, 2022 in Education by JackTerrance
0 votes
    So, I wanted to run the local Swagger UI with respect to Local Json. And for that I am following ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 17, 2022 in Education by JackTerrance
0 votes
    Syntax to create a DataFrame based on the content of a JSON file 1. spark.textfile("examples/src/main/resources/data. ... 4. spark.json("examples/src/main/resources/data.json")...
asked Oct 22, 2020 by JackTerrance
0 votes
    I am working on my first Android Application. What I am trying to do is a POST request to a REST ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 13, 2022 in Education by JackTerrance
0 votes
    I would like to take a list of names (e.g. john, mary, paul) and create a SQLite "select" ... , JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 7, 2022 in Education by JackTerrance
0 votes
    Using the WCF web programming model one can specify an operation contract like so: [OperationContract] [WebGet ... for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 11, 2022 in Education by JackTerrance
...