topic How can I refer part of query as a table? in Splunk Search

How can I refer part of query as a table?

jonvijay1993 — Tue, 20 Jun 2023 16:02:32 GMT

I have a dbx query plus SPL commands that makes me a certain table, which I want to refer to via a table name, is it possible?

The present table needs some new columns and that's what the above query adds, but the schema for my final table for my bar chart is a little different from the source table and hence I can't build on top of the above query using |, or I don't know how. Hence I was wondering if I can just use this via a table name.

Re: Refer part of query as a table

ITWhisperer — Tue, 20 Jun 2023 15:06:19 GMT

There is a mixture of naming here - You can saved a search as a named search which you can execute in another search. Does this satisfy your usecase?

Re: Refer part of query as a table

jonvijay1993 — Tue, 20 Jun 2023 15:11:22 GMT

My use case is I want to change this

select * from (an entire query replacing a table name)

select * from a_table

normally I would add the query in the table name as an emergency solution but the query has dbxquery and join etc that makes splunk go crazy.

I shall look into named searches, thank you! Will get back to you!