Reporting

Can I use Pivot to show daily indexed data from Sample data model?

melonman
Motivator

Hi
I am playing with Splunk 6, and trying to learn Pivot.
Now I am seeing a few data model for internal logs, but is there any useful case of pivot for those data model?
It seems very user friendly, but I am not just familiar with the data model of internal logs.

I would really appreciate if anyone could give me a sample of pivot use for internal logs or data models.

Thank you in advance..

Tags (2)
0 Karma
1 Solution

davebrooking
Contributor

From my limited knowledge, the following produces quantity indexed over time by sourcetype

  1. Using the Quota Usage object from the Splunk’s Internal Server Logs – Sample Data model

  2. For the Split Rows select _time and the appropriate size bucket you want from the Period picker

  3. For the Split Columns select Sourcetype

  4. In Column Values select GB indexed, and for Value select Sum

Dave

View solution in original post

0 Karma

davebrooking
Contributor

From my limited knowledge, the following produces quantity indexed over time by sourcetype

  1. Using the Quota Usage object from the Splunk’s Internal Server Logs – Sample Data model

  2. For the Split Rows select _time and the appropriate size bucket you want from the Period picker

  3. For the Split Columns select Sourcetype

  4. In Column Values select GB indexed, and for Value select Sum

Dave

0 Karma
Get Updates on the Splunk Community!

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

💌 Keep the new year’s momentum going with our February lineup of Community Office Hours, Tech Talks, ...

Preparing your Splunk Environment for OpenSSL3

The Splunk platform will transition to OpenSSL version 3 in a future release. Actions are required to prepare ...

Incident Response: Reduce Incident Recurrence with Automated Ticket Creation

Culture extends beyond work experience and coffee roast preferences on software engineering teams. Team ...