Sorry, I am new to Splunk. Now I use a dynamic dropdown to generate all the results, like below:
index=dev-app host=hadoopdn* $importids$ $batchids$ $stages$ |stats count by groupName
Now the query result is like:
FileSystemCounters 10
*.FileType 14
*.StatsCounters 3
*$Counter 6
The problem is the prefix is too long to display.
Is there a way that can only display the latter part?
Like "StatsCounters" instead of "*.StatsCounters"
Maybe use an alias?
@lyf1995123,
If you have a pattern in the group name , you could use regex
to extract it.
For e.g. from your above examples
index=dev-app host=hadoopdn* $importids$ $batchids$ $stages$ |stats count by groupName
| rex field=groupName "\*?[.$]?(?<groupName >\w+)"
What I want is the result generated like this: stats count by groupName |rex field=groupName mode=sed "s/^\w.+./""/g"
Hi @lyf1995123 ,
Did you have a chance to check out an answer? If it worked, please resolve this post by approving it! If your problem is still not solved, keep us updated so that someone else can help you.
Thanks for posting!
@lyf1995123,
If you have a pattern in the group name , you could use regex
to extract it.
For e.g. from your above examples
index=dev-app host=hadoopdn* $importids$ $batchids$ $stages$ |stats count by groupName
| rex field=groupName "\*?[.$]?(?<groupName >\w+)"
Inspired by your answer, I think what I am looking for is like "stats count by groupName |rex field=groupName mode=sed "s/^\w.+./""/g"".
And it worked as I expected. But thanks still.