Getting Data In

ServiceNow Inputs.conf Filter Data by field value

brdr
Contributor

We use the Splunk ServiceNow TA - both on collecting data from ServiceNow and creating incidents via the Splunk alert action.  

We have use case on the collection side. Within the inputs.conf there is attribute available call filter_data. This allows you to filter on the data you wish/not wish to collect from ServiceNow. The specific use case is where we do NOT want to collect events from sys_audit table if sys_created_by=user. System

The basic stanza attributes in inputs.conf within the Snow TA  is this:

[snow://sys_audit]
filter_data = sys_created_by!=user.system
table = sys_audit

This approach does not filter sys_created_by, that is, we still see user.system as sys_created_by in our events. 

Is there anything I'm doing wrong? Thx. 

 

 

Labels (1)
0 Karma

johnhuang
Motivator

The filter only support inclusion but not exclusion. That means you can specify it to only collect events matching the filter.

You can setup SEDMD to drop the event to prevent it from being indexed.

0 Karma

brdr
Contributor

Thank you Johnhua for the note about inclusion vs. exclusion. Although i think SEDCMD might work we have decided to go with dropping the event into null queue using props and transforms. Thanks again.

0 Karma
Get Updates on the Splunk Community!

New Year, New Changes for Splunk Certifications

As we embrace a new year, we’re making a small but important update to the Splunk Certification ...

Stay Connected: Your Guide to January Tech Talks, Office Hours, and Webinars!

What are Community Office Hours? Community Office Hours is an interactive 60-minute Zoom series where ...

[Puzzles] Solve, Learn, Repeat: Reprocessing XML into Fixed-Length Events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...