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!

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

Dive into our sizzling summer lineup for July and August Community Office Hours and Tech Talks. Scroll down to ...

Edge Processor Scaling, Energy & Manufacturing Use Cases, and More New Articles on ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Get More Out of Your Security Practice With a SIEM

Get More Out of Your Security Practice With a SIEMWednesday, July 31, 2024  |  11AM PT / 2PM ETREGISTER ...