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!

Enterprise Security Content Update (ESCU) | New Releases

In September, the Splunk Threat Research Team had two releases of new security content via the Enterprise ...

New in Observability - Improvements to Custom Metrics SLOs, Log Observer Connect & ...

The latest enhancements to the Splunk observability portfolio deliver improved SLO management accuracy, better ...

Improve Data Pipelines Using Splunk Data Management

  Register Now   This Tech Talk will explore the pipeline management offerings Edge Processor and Ingest ...