Reporting

Your opinion on creating a common field name across all saved searches to be able to split results by 'saved search name'

ramgnisiv
Path Finder

Hi guys,

I'm building an app that collects metrics from various sources.
In the dashboard, all metrics will be shown with Trellis layout, categorised by source.

My current set-up of saved searches (about 100 saved searches across 8 sources with 1 summary index) does not yet follow a naming convention for the search result fields.
A lot of saved searches do not even have a defined result field.

I'm thinking of creating a common field across ALL of my saved searches (potentially this will grow from 100 to 1.000) where i would call this common field something like 'metric' or in other cases 'score'.

My theory behind this is that when i want to search across the output of my saved searches in my summary index, i could search with something like this:

index=summary_index_name search_name=* | stats avg(metric) by saved_search_name

In theory, this would make searching and splitting of data across all saved searches very easy.

Each summary index populating saved search would look a little something like this:

index=name_of_index | sistats avg(field_name) as metric by field_name_2

My questions:

  • What is your opinion about this set-up using a common field name?
  • What can go wrong when i use this type of set-up using a common field name?
  • What else could i do to make life easy when i have a lot of saved searches and i want easy maintenance and flexibility in dashboarding?

wmyersas
Builder

Sounds like you're describing something like CIM (Common Information Model) compliance:

ramgnisiv
Path Finder

Thanks, i think I am describing something like the CIM indeed.

If there was no CIM, would the approach described make sense to you?

0 Karma

wmyersas
Builder

If there was no CIM, yes ... you'd basically be reinventing the CIM 🙂

0 Karma
Get Updates on the Splunk Community!

Introducing the Splunk Community Dashboard Challenge!

Welcome to Splunk Community Dashboard Challenge! This is your chance to showcase your skills in creating ...

Get the T-shirt to Prove You Survived Splunk University Bootcamp

As if Splunk University, in Las Vegas, in-person, with three days of bootcamps and labs weren’t enough, now ...

Wondering How to Build Resiliency in the Cloud?

IT leaders are choosing Splunk Cloud as an ideal cloud transformation platform to drive business resilience,  ...