Reporting

Can I use pivot without search processing language?

darshyakmk
New Member

Can pivot work without search processing languages? It will work only with the data models/data sets like that. Can anyone clarify this, please?

0 Karma
1 Solution

jkat54
SplunkTrust
SplunkTrust

The answer is both yes and no if you ask me... pivot requires a datamodel and a datamodel requires a root search or event... something like 'index=yourIndex error'. Or in its simplest form 'index=yourIndex"...

Technically that root search is SPL.

Also, once the root search is configured, additional SPL can be used to extract fields, inputlookups, etc ALL WITHIN the datamodel.

So typically someone who understands SPL will create the datamodel. Once the datamodel is created, the pivot functionality in Splunk doesn't require additional SPL. You simply go to /pivot in the UI (https://Splunk:8000/en-US/appName/pivot OR click on data models or data sets), open the appropriate datamodel and select options from drop down menus.

Of course there is a SPL command called pivot as well...

View solution in original post

lfedak_splunk
Splunk Employee
Splunk Employee

Hey @darshyakmk, if @jkat54 answered your question please "Accept" the answer to close the question and to award karma points to jkat54 🙂

0 Karma

jkat54
SplunkTrust
SplunkTrust

The answer is both yes and no if you ask me... pivot requires a datamodel and a datamodel requires a root search or event... something like 'index=yourIndex error'. Or in its simplest form 'index=yourIndex"...

Technically that root search is SPL.

Also, once the root search is configured, additional SPL can be used to extract fields, inputlookups, etc ALL WITHIN the datamodel.

So typically someone who understands SPL will create the datamodel. Once the datamodel is created, the pivot functionality in Splunk doesn't require additional SPL. You simply go to /pivot in the UI (https://Splunk:8000/en-US/appName/pivot OR click on data models or data sets), open the appropriate datamodel and select options from drop down menus.

Of course there is a SPL command called pivot as well...

Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...