# Fetch logs from MSSQL using logstash input plugin

**URL:** <https://discuss.elastic.co/t/fetch-logs-from-mssql-using-logstash-input-plugin/365807>\
**Category:** Logstash\
**Created:** [August 30, 2024, 8:15am UTC](https://discuss.elastic.co/t/fetch-logs-from-mssql-using-logstash-input-plugin/365807 "2024-08-30T08:15:46Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Shivam\_Goyal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/shivam_goyal/32/137170_2.png) [@Shivam\_Goyal](https://discuss.elastic.co/u/Shivam_Goyal)\
**Post date:** [August 30, 2024, 8:15am UTC](https://discuss.elastic.co/t/fetch-logs-from-mssql-using-logstash-input-plugin/365807/1 "2024-08-30T08:15:46Z")

</div>

Hello,  
I am using Logstash to fetch logs from MSSQL. We need to use domain account which can be used for authentication and to fetch the logs.  
Can anyone please help how we can use it in input plugin?

---

<div class="post-metadata">

**Author:** ![ashishtiwari1993](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ashishtiwari1993/32/135241_2.png) [@ashishtiwari1993](https://discuss.elastic.co/u/ashishtiwari1993)\
**Post date:** [September 3, 2024, 2:58pm UTC](https://discuss.elastic.co/t/fetch-logs-from-mssql-using-logstash-input-plugin/365807/2 "2024-09-03T14:58:53Z")

</div>

Hi Shivam, Welcome to the Elastic community

You need to use [jdbc input plugin](https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html) and set [schedule](https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html#_scheduling_2) to pull data periodically.

---

<div class="post-metadata">

**Author:** ![Shivam\_Goyal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/shivam_goyal/32/137170_2.png) [@Shivam\_Goyal](https://discuss.elastic.co/u/Shivam_Goyal)\
**Post date:** [September 3, 2024, 3:19pm UTC](https://discuss.elastic.co/t/fetch-logs-from-mssql-using-logstash-input-plugin/365807/3 "2024-09-03T15:19:59Z")

</div>

Thanks for your response Ashish.

This is I am aware of, I want to understand how we can use domain account to fetch those logs from DB instead of using local SQL account.

Using local SQL account, i had extracted logs from custom table, but i am facing authentication issues while using domain joined account