I want to list what commands in the search language are being used. I think its possible in the same _audit index and I want to be able to do is count the number of times each command is used in search
Example :
stats used 2 time
eval used 5 times
rex used 7 time
timechart used 10 time
There is a REST endpoint, /services/search/v2/parser, you may be able to use to parse queries into the commands used. It requires the POST method so it will have to be used from a script (not from the UI). See https://docs.splunk.com/Documentation/Splunk/9.1.1/RESTREF/RESTsearch#search.2Fv2.2Fparser
You could start with something like this:
index=_audit
| rex max_match=0 field=search "\|\s*(?<command>\w+)"
| stats count by command
However, you may get some false results if pipes are used in the search where they are not delimiting commands. Also, you may find that macros hide the use of some commands.
Thank you, I am getting the result but unwanted fields are coming like jira, macro, filename. How to get rid of this from result
| where command!="jira" AND command!="macro" AND command!="filename"