Changing field name to tag columns and filed values to rows for windows logs

How to configure the telegraf using win_eventlog plugin for changing all field names to different columns and corresponding values displayed in rows?
If it is not possible using config file is there any way in influx flux to save all fields to columns?

Hi @Vidhya,
So there is a feature with InfluxDB Flux called pivot(): pivot() function | Flux 0.x Documentation

This will shape data into a columnar format. Note though these are still not considered tags. I would strongly advise turning every field into a tag. Tags can only be string values and are indexed. So you would see an explosion in cardanility. Pivot will do exactly what you need while avoiding this issue.

Hi @Jay_Clifford,
It worked!
Thank you so much for helping out :slight_smile:

1 Like