Reporting

reporting on db connect downloads

a212830
Champion

Hi,

Is there a way to show how long it takes db connect to complete each tail? I' like to graph this, so we can make adjustments as needed.

0 Karma
1 Solution

ziegfried
Influencer

Yes, the internal log of DB Connect contains that information. Here are a few search you can use:

Get aggregated information for the inputs for the selected timerange (Duration, Number of Invocations, Number of results):

index=_internal sourcetype=dbx_debug logger="Scheduler" input=* | stats count as number_of_invocations avg(duration) as avg_duration min(duration) as min_duration max(duration) as max_duration avg(resultCount) as avg_results_per_invocation sum(resultCount) as total_results by input | eval avg_duration=tostring(round(avg_duration),"duration") | eval min_duration=tostring(min_duration,"duration") | eval max_duration=tostring(max_duration,"duration") 

Or print duration of invocations over time:

index=_internal sourcetype=dbx_debug logger="Scheduler" input=* | timechart avg(duration) by input

Number of invocations over time (chart):

index=_internal sourcetype=dbx_debug logger="Scheduler" input=* | timechart count by input

Avg. invocations per minute per input:

index=_internal sourcetype=dbx_debug logger="Scheduler" input=* | bucket _time span=1m | stats count as per_minute by _time,input | timechart avg(per_minute) by input

Number of (indexed) results over time:

index=_internal sourcetype=dbx_debug logger="Scheduler" input=* | timechart sum(resultCount) by input

View solution in original post

ziegfried
Influencer

Yes, the internal log of DB Connect contains that information. Here are a few search you can use:

Get aggregated information for the inputs for the selected timerange (Duration, Number of Invocations, Number of results):

index=_internal sourcetype=dbx_debug logger="Scheduler" input=* | stats count as number_of_invocations avg(duration) as avg_duration min(duration) as min_duration max(duration) as max_duration avg(resultCount) as avg_results_per_invocation sum(resultCount) as total_results by input | eval avg_duration=tostring(round(avg_duration),"duration") | eval min_duration=tostring(min_duration,"duration") | eval max_duration=tostring(max_duration,"duration") 

Or print duration of invocations over time:

index=_internal sourcetype=dbx_debug logger="Scheduler" input=* | timechart avg(duration) by input

Number of invocations over time (chart):

index=_internal sourcetype=dbx_debug logger="Scheduler" input=* | timechart count by input

Avg. invocations per minute per input:

index=_internal sourcetype=dbx_debug logger="Scheduler" input=* | bucket _time span=1m | stats count as per_minute by _time,input | timechart avg(per_minute) by input

Number of (indexed) results over time:

index=_internal sourcetype=dbx_debug logger="Scheduler" input=* | timechart sum(resultCount) by input

a212830
Champion

Wow. Great stuff!

0 Karma
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 ...