0

Is it possible to write logs in SQLCLR procedure to ElasticSearch (EFK or ELK stacks)? If it is where are any examples?

Improve this question
2
  • 1
    What type of logs do you want to write, or rather where do the logs originate from? I would strongly suggest you write to Elastic from where the logs originate, (unless the logs are SQL Server, in which case I wonder why you would like to store them in Elastic). I am a big proponent of SQLCLR, but if you can do whatever you want to do from outside of SQL Server, you should do so. Commented Jul 11, 2021 at 5:25
  • Yes, it is right. First of all it is interesting how to ;-). My situation: I have multiple clients and one database. I'd like to add to SQLCLR functions to send logs to ELK, EFK stack. I have already made SQLCLR proc which writes to GrayLog. It uses pure c# classes. Btw, I have used your article about how to add SQLCLR fun and avoid db trustworthy. Thank you. Commented Jul 11, 2021 at 5:43
Related questions
61
How to log all executed elasticsearch queries
2
How to print the logs of logstash execution
0
Logstash extracting values from sp_executesql
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.