topic Re: Split unix commands in Splunk Search

Split unix commands

dwibedi03 — Thu, 06 Aug 2020 19:03:42 GMT

There is a command fields in my logs and consists of unix commands.

One value is

/usr/bin/ssh -q -o ConnectTimeout=5 -o BatchMode=yes zevsbdr66599.prodb.cally.org netstat -rn

I am looking to extract netstat -rn.

Can someone provide me a way to split ?

Re: Split unix commands

thambisetty — Thu, 06 Aug 2020 19:18:49 GMT

I am assuming all your commands at end of line.

| rex “(?<command>[\w]+\s[-\w]+)$”

Re: Split unix commands

dwibedi03 — Thu, 06 Aug 2020 19:22:35 GMT

@thambisetty tried your solution. It throws error.

Re: Split unix commands

mfasciano_splun — Thu, 06 Aug 2020 19:43:27 GMT

Are you looking to extract the field in a query through spl or are you trying to do a field extraction on ingest of the log data?

For the first you would add a field extraction in your props.conf file.

https://docs.splunk.com/Documentation/Splunk/8.0.5/Knowledge/Exampleconfigurationswithprops.conf

For the second you would use the rex command as suggested.

https://docs.splunk.com/Documentation/SCS/current/SearchReference/RexCommandExamples

The regex you would use depends on how consistant your logs are and if you could define a regex to match all of the logs you are concerned with. Here is an example of what might work if all of your logs had the command at the end of the line:

| rex field=_raw “(?<command>[\w]+\s[-\w]*)$”

The above regex is not perfect. You'll have to account for a command with and without arguments. The above regex isn't perfect if your command doesn't have -xyz arguments.

Re: Split unix commands

thambisetty — Thu, 06 Aug 2020 19:48:02 GMT

May be because of double quotes using in rex. Remove and input them from your keyboard.

Re: Split unix commands

dwibedi03 — Thu, 06 Aug 2020 19:45:22 GMT

Thanks for your reply. I will check it out.

Re: Split unix commands

dwibedi03 — Thu, 06 Aug 2020 19:46:12 GMT

Yes, i got to make it work. However it is not accounting for all the commands. I will improvise. Thanks.