# How can I monitor MSSQL with network traffic the same time with packetbeat?

**URL:** <https://discuss.elastic.co/t/how-can-i-monitor-mssql-with-network-traffic-the-same-time-with-packetbeat/49038>\
**Category:** Beats\
**Tags:** packetbeat\
**Created:** [May 3, 2016, 10:17am UTC](https://discuss.elastic.co/t/how-can-i-monitor-mssql-with-network-traffic-the-same-time-with-packetbeat/49038 "2016-05-03T10:17:04Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kennedy\_Kan1](https://avatars.discourse-cdn.com/v4/letter/k/cc9497/32.png) [@Kennedy\_Kan1](https://discuss.elastic.co/u/Kennedy_Kan1)\
**Post date:** [May 3, 2016, 10:17am UTC](https://discuss.elastic.co/t/how-can-i-monitor-mssql-with-network-traffic-the-same-time-with-packetbeat/49038/1 "2016-05-03T10:17:04Z")

</div>

I would wonder how can I do that.

Is it a must for me to install logstash in order to do that or I can just directly communicate with elasticsearch?

The folowing is my json file for packetbeat

> {  
> "mappings": {  
> "_default_": {  
> "\_all": {  
> "enabled": true,  
> "norms": {  
> "enabled": false  
> }  
> },  
> "dynamic\_templates": [  
> {  
> "template1": {  
> "mapping": {  
> "doc\_values": true,  
> "ignore\_above": 1024,  
> "index": "analyzed",  
> "type": "{dynamic\_type}"  
> },  
> "match": "_"  
> }  
> }  
> ],  
> "properties": {  
> "@timestamp": {  
> "type": "date"  
> },  
> "client\_location": {  
> "type": "geo\_point"  
> },  
> "params": {  
> "index": "analyzed",  
> "norms": {  
> "enabled": false  
> },  
> "type": "string"  
> },  
> "query": {  
> "doc\_values": true,  
> "index": "analyzed",  
> "type": "string"  
> },  
> "request": {  
> "index": "analyzed",  
> "norms": {  
> "enabled": false  
> },  
> "type": "string"  
> },  
> "response": {  
> "index": "analyzed",  
> "norms": {  
> "enabled": false  
> },  
> "type": "string"  
> }  
> }  
> }  
> },  
> "settings": {  
> "index.refresh\_interval": "5s"  
> },  
> "template": "packetbeat-_"  
> }

---

<div class="post-metadata">

**Author:** ![steffens](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/steffens/32/79630_2.png) [@steffens](https://discuss.elastic.co/u/steffens)\
**Post date:** [May 3, 2016, 11:58am UTC](https://discuss.elastic.co/t/how-can-i-monitor-mssql-with-network-traffic-the-same-time-with-packetbeat/49038/2 "2016-05-03T11:58:20Z")

</div>

packetbeat does not support MSSQL protocol yet. [Related ticket](https://github.com/elastic/beats/issues/149). With packetbeat v5.0 you still can collect flow information (connections made + packets/bytes transferred on network). The default elasticsearch template shipped should be ok.

---

<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:** [July 5, 2017, 9:52pm UTC](https://discuss.elastic.co/t/how-can-i-monitor-mssql-with-network-traffic-the-same-time-with-packetbeat/49038/3 "2017-07-05T21:52:29Z")

</div>