Reporting

Why am I getting two different sets of data from the same report?

a212830
Champion

Hi,

I took a search that runs on the license manager, and moved it over to our search-heads, so that customers can have reports/dashboards available to them. On the license manager, it looks correct - showing 7 days of data. The license manager forwards it's data to our indexes (and it has for some time). We recently added a new license pool, and I'm adding some reports for this customer. On the license manager, I get 7 days worth of data, but on the search-head, it only shows 2 days. I have no idea why. My search is listed below. I also tried it without the "set_local_host" macro.

index=_internal [`set_local_host`] source=*license_usage.log* type="Usage" | eval h=if(len(h)=0 OR isnull(h),"(SQUASHED)",h) | eval s=if(len(s)=0 OR isnull(s),"(SQUASHED)",s) | eval idx=if(len(idx)=0 OR isnull(idx),"(UNKNOWN)",idx) | bin _time span=1d | stats sum(b) as b by _time, pool, s, st, h, idx  | search pool="PWI License" | timechart span=1d sum(b) AS volumeB by st fixedrange=false  | join type=outer _time [search index=_internal [`set_local_host`] source=*license_usage.log* type="RolloverSummary" earliest=-30d@d  | search pool="PWI License" | eval _time=_time - 43200 | bin _time span=1d | stats latest(poolsz) AS  "pool size" by _time] | fields - _timediff  | foreach * [eval <<FIELD>>=round('<<FIELD>>'/1024/1024/1024, 3)]
0 Karma

sbbadri
Motivator

index=_internal source=license_usage.log type="Usage" earliest=-7d@d latest=now | rest of the query.

0 Karma

sloshburch
Splunk Employee
Splunk Employee

Sounds like the Search Head may not be searching across the same data set (indexers). I would check this two ways:

  1. Run the search on both systems and look at the indexers called by the Job Inspector. Are the same dispatch.stream.remote.<indexername> listed?
  2. Check the permissions on the indexers. Does indexer for some reason have different permissions than the search heads? Does the user's role limit searches to two days perchance?
  3. Check the Search Peers on the different instances. Assuming it's a search head of the indexer cluster, does the SH traverse and return data (Job Inspector) from the same set of indexers?
0 Karma
Get Updates on the Splunk Community!

Built-in Service Level Objectives Management to Bridge the Gap Between Service & ...

Wednesday, May 29, 2024  |  11AM PST / 2PM ESTRegister now and join us to learn more about how you can ...

Get Your Exclusive Splunk Certified Cybersecurity Defense Engineer Certification at ...

We’re excited to announce a new Splunk certification exam being released at .conf24! If you’re headed to Vegas ...

Share Your Ideas & Meet the Lantern team at .Conf! Plus All of This Month’s New ...

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