Splunk Search

WIndows Software Installation: Extract from Message Field

rmsit
Communicator

Hello, everone. I am new to regular and perl expressions and attempting to extract the Product Name, Product Version and Product Language from the following Message field:

Windows Installer installed the product. Product Name: Java 7 Update 71. Product Version: 7.0.710. Product Language: 1033. Installation success or error status: 0.

What would be the best way to extract so I can search by Product, Version or Language? Thanks.

Tags (2)
0 Karma
1 Solution

musskopf
Builder

Try to create a field extraction for your source type and use the following expression:

^Windows Installer.+\. Product Name: (?P<productName>.+)\. Product Version: (?P<productVersion>.+)\. Product Language: (?P<productLanguage>.+)\. Installation.+$

One thing I normally do, is to open the site http://regex101.com/ and try the expression there. It's very helpful to understand what you're selecting.

View solution in original post

0 Karma

musskopf
Builder

Try to create a field extraction for your source type and use the following expression:

^Windows Installer.+\. Product Name: (?P<productName>.+)\. Product Version: (?P<productVersion>.+)\. Product Language: (?P<productLanguage>.+)\. Installation.+$

One thing I normally do, is to open the site http://regex101.com/ and try the expression there. It's very helpful to understand what you're selecting.

0 Karma

rmsit
Communicator

Thank you! Greatly appreciated.

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Community Content Calendar, September edition

Welcome to another insightful post from our Community Content Calendar! We're thrilled to continue bringing ...

Splunkbase Unveils New App Listing Management Public Preview

Splunkbase Unveils New App Listing Management Public PreviewWe're thrilled to announce the public preview of ...

Leveraging Automated Threat Analysis Across the Splunk Ecosystem

Are you leveraging automation to its fullest potential in your threat detection strategy?Our upcoming Security ...