topic Re: Count numbers of entry in a log in Grails in DQL

Count numbers of entry in a log in Grails

Raul_CL — Wed, 22 Nov 2023 09:55:22 GMT

I have a log ingested in Grails where I would like to count the number of entries of each user. The user name is the second column.
User names are dynamic, I mean new users could appear daily.

USER user1 20231121 12:11:27 95959595 12345
USER user1 20231121 12:11:29 95959595 12345
USER user5 20231121 12:11:31 95959595 12345
USER user8 20231121 12:11:33 95959595 12345
USER user1 20231121 12:11:35 95959595 12345
USER user5 20231121 12:11:37 95959595 12345

For this example, I would like to have something like this:
user1: 3
user5: 2
user8:1

Is it possible to do that?

Re: Count numbers of entry in a log in Grails

Miguel_RinconG — Tue, 21 Nov 2023 16:49:07 GMT

Yes, you can use Dynatrace patterm language: https://docs.dynatrace.com/docs/platform/grail/dynatrace-pattern-language

Re: Count numbers of entry in a log in Grails

stefan_eggersto — Wed, 22 Nov 2023 07:04:36 GMT

Hi @Raul_CL ,

This would be a query for parsing and summarizing such input:

data record(content = "USER user1 20231121 12:11:27 95959595 12345"),
  record(content = "USER user1 20231121 12:11:29 95959595 12345"),
  record(content = "USER user5 20231121 12:11:31 95959595 12345"),
  record(content = "USER user8 20231121 12:11:33 95959595 12345"),
  record(content = "USER user1 20231121 12:11:35 95959595 12345"),
  record(content = "USER user5 20231121 12:11:37 95959595 12345")
| parse content, "'USER ' word:user"
| summarize count(), by:user

Re: Count numbers of entry in a log in Grails

Raul_CL — Wed, 22 Nov 2023 13:47:53 GMT

Thank you both very much for responding. The solution proposed by stefan_eggersto worked perfectly for me.