topic Possible way to organize columns in logs in Log Analytics

Possible way to organize columns in logs

AlexisGND — Wed, 17 Jan 2024 15:35:27 GMT

Hi !
I am a beginner at making my first dashboard on Dynatrace.

Using an api, I create ingest logs on Dynatrace using custom attributes, as you can see.
Each line corresponds to fake data.
For the moment, I'm focusing on the columns "bmx.hip.execution.endtime", "bmx.hip.execution.starttime" and "bmx.hip.execution.scheduledtime".

My first question is: can I customize the column names?
My second question is: can I rearrange the column order (e.g. I want starttime to come before endtime)?

Thank you in advance, and have a nice day 🙂
Alexis GONNEAUD
Data Analyst & Dev Trainee

Re: Possible way to organize columns in logs

natanael_mendes — Wed, 17 Jan 2024 17:45:43 GMT

Yes, you can for both questions.

To rename the column name you can use

fieldsRename

Renames a field.

Syntax
fieldsRename fieldName = originalName, [,...]
and for you rearrange the order, you can select the fields and put the order that you want
Syntax
| fields fieldName [= Expression] [, ...]
You can see all these informations in this link here
https://docs.dynatrace.com/docs/platform/grail/dynatrace-query-language/commands

Re: Possible way to organize columns in logs

AlexisGND — Thu, 18 Jan 2024 09:41:33 GMT

Thanks a lot ^-^