Splunk Search

splunk query slow.......

DTERM
Contributor

Is there a way to take a query, run it in the background, save the results to a file, and then reference that file in another query? I have a few queries that take too long to run. Can I run those in the background (say maybe one or twice a day), and reference the output?

A sample query would be like....

index=whatever | top 15 hosts

A lookup table is close but that doesn't quite accomplish the objetive.

Thanks...

Tags (1)
0 Karma
1 Solution

ziegfried
Influencer

You could use the loadjob command:

| loadjob 1346168165.751

It will emit the results of the previously executed (and saved) search.

View solution in original post

ziegfried
Influencer

You could use the loadjob command:

| loadjob 1346168165.751

It will emit the results of the previously executed (and saved) search.

DTERM
Contributor

Great. Thanks!!

0 Karma

sdaniels
Splunk Employee
Splunk Employee

There are a few commands that start with the pipe and nothing before it. You'll see examples here.

http://docs.splunk.com/Documentation/Splunk/latest/SearchReference/SearchCheatsheet

0 Karma

DTERM
Contributor

That sounds perfect. However, I'm confused about the pipe before the command. In the following example, what would I place before the "|" if anything?

| loadjob savedsearch="admin:search:MySavedSearch"

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...

Kubernetes Alerts That Work Out of the Box with AutoDetect detectors in Splunk ...

A deployment rolls out slowly, one pod sits not ready for a few minutes, and whoever is on call gets an alert ...

Observability at Your Fingertips Directly From Splunk Platform—for Free

At .conf, we announced our roadmap to bring observability foundations to Splunk Platform. Bringing metrics and ...