# Unable to get total sql duration from aggregate filter example
**URL:** https://discuss.elastic.co/t/unable-to-get-total-sql-duration-from-aggregate-filter-example/161890
**Category:** Logstash
**Created:** [December 21, 2018, 6:56pm UTC](https://discuss.elastic.co/t/unable-to-get-total-sql-duration-from-aggregate-filter-example/161890 "2018-12-21T18:56:39Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Sanjeev7](https://discuss.elastic.co/u/Sanjeev7)
#### Post date: [December 21, 2018, 6:56pm UTC](https://discuss.elastic.co/t/unable-to-get-total-sql-duration-from-aggregate-filter-example/161890/1 "2018-12-21T18:56:39Z")
just run below aggregate filter url example unable to get total sql duration please find below output logs as i have same requirement . Please let me know if i missed anything
[https://www.elastic.co/guide/en/logstash/current/plugins-filters-aggregate.html](https://www.elastic.co/guide/en/logstash/current/plugins-filters-aggregate.html)
out put -
{"@version":"1","tags":["beats\_input\_codec\_plain\_applied"],"host":{"name":"02HW031471"},"@timestamp":"2018-12-21T03:46:28.173Z","offset":35,"taskid":"12345","loglevel":"INFO","fields":{"log\_type":"test-forum"},"logger":"SQL","input":{"type":"log"},"message":"INFO - 12345 - SQL - sqlQuery1 - 12","prospector":{"type":"log"},"source":"C:\ELK-Setup\RFT\_LT\sanju\aggregate-forum-log.txt","beat":{"hostname":"02HW031471","name":"02HW031471","version":"6.4.2"},"duration":12,"label":"sqlQuery1"}
{"@version":"1","tags":["beats\_input\_codec\_plain\_applied"],"host":{"name":"02HW031471"},"@timestamp":"2018-12-21T03:46:28.160Z","offset":0,"taskid":"12345","loglevel":"INFO","fields":{"log\_type":"test-forum"},"logger":"TASK\_START","input":{"type":"log"},"message":"INFO - 12345 - TASK\_START - start","prospector":{"type":"log"},"source":"C:\ELK-Setup\RFT\_LT\sanju\aggregate-forum-log.txt","beat":{"hostname":"02HW031471","name":"02HW031471","version":"6.4.2"},"label":"start"}
{"@version":"1","tags":["beats\_input\_codec\_plain\_applied"],"host":{"name":"02HW031471"},"@timestamp":"2018-12-21T03:46:28.193Z","offset":72,"taskid":"12345","loglevel":"INFO","fields":{"log\_type":"test-forum"},"logger":"SQL","input":{"type":"log"},"message":"INFO - 12345 - SQL - sqlQuery2 - 34","prospector":{"type":"log"},"source":"C:\ELK-Setup\RFT\_LT\sanju\aggregate-forum-log.txt","beat":{"hostname":"02HW031471","name":"02HW031471","version":"6.4.2"},"duration":34,"label":"sqlQuery2"}
---
### Author:  [@Sanjeev7](https://discuss.elastic.co/u/Sanjeev7)
#### Post date: [December 23, 2018, 5:27pm UTC](https://discuss.elastic.co/t/unable-to-get-total-sql-duration-from-aggregate-filter-example/161890/2 "2018-12-23T17:27:34Z")
any update . Please let me know its urgent
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [January 20, 2019, 5:27pm UTC](https://discuss.elastic.co/t/unable-to-get-total-sql-duration-from-aggregate-filter-example/161890/3 "2019-01-20T17:27:36Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.