# MSSQL Metrics - Configuration

**URL:** <https://discuss.elastic.co/t/mssql-metrics-configuration/223846>\
**Category:** Metrics\
**Created:** [March 17, 2020, 5:43am UTC](https://discuss.elastic.co/t/mssql-metrics-configuration/223846 "2020-03-17T05:43:56Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![c.tech.cpt](https://avatars.discourse-cdn.com/v4/letter/c/848f3c/32.png) [@c.tech.cpt](https://discuss.elastic.co/u/c.tech.cpt)\
**Post date:** [March 17, 2020, 5:43am UTC](https://discuss.elastic.co/t/mssql-metrics-configuration/223846/1 "2020-03-17T05:43:57Z")

</div>

Hi there,

We have our log files on a separate drive. How do I configure the beat to pick this up?  
I've tried to google and found nothing.

Thanks Charles

---

<div class="post-metadata">

**Author:** ![Kerry](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kerry/32/40330_2.png) [@Kerry](https://discuss.elastic.co/u/Kerry)\
**Post date:** [March 17, 2020, 3:07pm UTC](https://discuss.elastic.co/t/mssql-metrics-configuration/223846/2 "2020-03-17T15:07:00Z")

</div>

Hi, you can use Filebeat, and the MSSQL module, to collect your logs. [You can find documentation here](https://www.elastic.co/guide/en/beats/filebeat/7.6/filebeat-module-mssql.html). The **var.paths** setting specifies where the log files can be found.

---

<div class="post-metadata">

**Author:** ![c.tech.cpt](https://avatars.discourse-cdn.com/v4/letter/c/848f3c/32.png) [@c.tech.cpt](https://discuss.elastic.co/u/c.tech.cpt)\
**Post date:** [March 19, 2020, 5:15am UTC](https://discuss.elastic.co/t/mssql-metrics-configuration/223846/3 "2020-03-19T05:15:52Z")

</div>

Hi Kerry,

Thanks for the reply. The log files I’m referring to are .ldf files. Can this still be done using the mssql module?

![image005.jpg](https://us1.discourse-cdn.com/elastic/original/3X/3/f/3f72ddbc5a996a259b2c000d12124ba739192382.jpeg)

![image006.png](https://us1.discourse-cdn.com/elastic/original/3X/1/c/1c9bdfa18b1e9c25530be250ec8831aa632cc8d6.png)

![image007.png](https://us1.discourse-cdn.com/elastic/original/3X/2/3/2383e2e8183376c47c4dec98614924bf02aac15a.png)

![image008.png](https://us1.discourse-cdn.com/elastic/original/3X/3/8/3899bf5dff8285ec59b845fe52f7d7c0ac219360.png)

![120031907160100539.jpg](https://us1.discourse-cdn.com/elastic/original/3X/3/2/32a778b373911ef9a8c033c535fb5b57277dc20a.jpeg)

---

<div class="post-metadata">

**Author:** ![Kerry](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kerry/32/40330_2.png) [@Kerry](https://discuss.elastic.co/u/Kerry)\
**Post date:** [March 19, 2020, 1:26pm UTC](https://discuss.elastic.co/t/mssql-metrics-configuration/223846/4 "2020-03-19T13:26:32Z")

</div>

Yep - this should work fine, ensure **var.paths** is setup to use those files (e.g. /path/to/log/\*/\*.ldf)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [April 16, 2020, 1:26pm UTC](https://discuss.elastic.co/t/mssql-metrics-configuration/223846/5 "2020-04-16T13:26:34Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.