Splunk Search

using the collect command with file option

imosquera
Explorer

I have a search command that looks like:

| mysqlquery spec="users" query="select * from users" | collect index="new_users_idx" file="new_users_$timestamp$"

But when I use the file option it never goes into "new_user_idx" index. It always goes into the "main" index. I'm currently using Splunk 4.3

Am I doing something wrong?

Tags (2)

MarioM
Motivator

i have tested and it seems that you need to add .stash_new or .stash then it goes to the right index:

| mysqlquery spec="users" query="select * from users" | collect index="new_users_idx" file="new_users_$timestamp$.stash"
0 Karma
Get Updates on the Splunk Community!

AppDynamics Summer Webinars

This summer, our mighty AppDynamics team is cooking up some delicious content on YouTube Live to satiate your ...

SOCin’ it to you at Splunk University

Splunk University is expanding its instructor-led learning portfolio with dedicated Security tracks at .conf25 ...

Credit Card Data Protection & PCI Compliance with Splunk Edge Processor

Organizations handling credit card transactions know that PCI DSS compliance is both critical and complex. The ...