Hello Everyone,
I am trying to record content from the result/output of the previous DQL query so that I can modify the output.
Example:
DQL query:
timeseries { count(`metric-A`), value.A = avg(`metric-A`, scalar: true) }, by: { message_vpn_name, client_user_name }, filter: { NOT matchesValue(client_user_name, “X=xyz.abc”) AND NOT matchesValue(client_user_name, “*12345*”) }
Sample Output in table format:
VPN client_user_name
EFGHI def-sit.com
JIKOL def-int.com
etc…
Now I want to record this output and then remove everything from ‘-’ in the output (ex: -sit.com, -int.com, etc).
I tried using “data record(content” metric command and then string function “replaceString” to modify the output which is not working.
Please suggest the right the metric command and string function or for loop if possible.
Thanks,