Splunk Search

How to show comparison graph of jenkins pipelines steps between two builds

khandelwaly
Explorer

Hi Team,

I want to show comparison graph of jenkins pipeline steps between two jenkins build. How can i get it?
i am able to get the table with all duration, stage name with following queries.

index="jenkins_statistics" (host=jenkins.com/test) event_tag=job_event type=completed "stages{}.name"="" "stages{}.children{}.exec_node"="" |rename stages{}.duration as stageduration | rename stages{}.name as stageName | rename "stages{}.children{}.exec_node" as pipeline_nodes| eval exec_nodes=mvdedup(pipeline_nodes)
| eval build_on_node=coalesce(exec_nodes, node) | table build_on_node, job_name, stageName, stageduration

0 Karma

to4kawa
Ultra Champion
index="jenkins_statistics" (host=jenkins.com/test) event_tag=job_event type=completed "stages{}.name"="" "stages{}.children{}.exec_node"="" 
| rename stages{}.duration as stageduration 
| rename stages{}.name as stageName 
| rename "stages{}.children{}.exec_node" as pipeline_nodes 
| eval exec_nodes=mvdedup(pipeline_nodes) 
| eval build_on_node=coalesce(exec_nodes, node) 
| table build_on_node, job_name, stageName, stageduration
| eval stage=build_on_node."_".job_name."_".stageName
| chart sum(stageduration) as stageduration by stage

| table build_on_node, job_name, stageName, stageduration
If you provide the results, we could create query.

0 Karma
Get Updates on the Splunk Community!

Splunk Training for All: Meet Aspiring Cybersecurity Analyst, Marc Alicea

Splunk Education believes in the value of training and certification in today’s rapidly-changing data-driven ...

Investigate Security and Threat Detection with VirusTotal and Splunk Integration

As security threats and their complexities surge, security analysts deal with increased challenges and ...

Observability Highlights | January 2023 Newsletter

 January 2023New Product Releases Splunk Network Explorer for Infrastructure MonitoringSplunk unveils Network ...