Splunk Search

Stats Count in InputLookup?

zward
Path Finder

Hello,

I am working on a dashboard panel and I am at my wits end on how I can create a table entry for the eventcount or stats of the number of events. I am able to display my entire dashboard minus the eventcount (I need a full count of the number of events for the specific host), however when I attempt to use eventcount, it fails as it is not the first entry into the search, and stats dc(index) is not populating the search either and it ends up blank. Any thoughts on how I can get an event count for the particular host to display in my inputlookup dashboard? I am hoping it is an easy fix, but something just isn't adding up.

Thank you.

:

<panel>
  <title>Results</title>
  <input type="dropdown" token="fields" searchWhenChanged="true">
    <label>Field Selection:</label>
    <choice value="table host, sourcetype, index, firstTime, lastTime, recentTime, lastUpdated | sort - host">All</choice>
    <choice value="dedup index, sourcetype | table index, sourcetype">Indexes, Sourcetypes Only</choice>
    <choice value="table host, sourcetype, index">Indexes, Sourcetypes, Hosts Only</choice>
    <default>table host, sourcetype, index, firstTime, lastTime, recentTime, lastUpdated | sort - host</default>
  </input>
  <table>
    <search>
      <query>| inputlookup MCInventory  where index=$index$ sourcetype=$sourcetype$ host=$host$ | $filter$  | convert ctime(recentTime) ctime(firstTime) ctime(lastTime) ctime(lastUpdated) | $fields$</query>
      <earliest>-24h@h</earliest>
      <latest>now</latest>
    </search>
    <option name="wrap">true</option>
    <option name="rowNumbers">false</option>
    <option name="dataOverlayMode">heatmap</option>
    <option name="drilldown">row</option>
    <option name="count">50</option>
  </table>
</panel>
0 Karma

cmerriman
Super Champion

how are those tokens in the search query created? are all the tokens working properly? and where are you looking at dc(index) or calculating an eventcount? I think the whole xml might be more helpful

0 Karma
Get Updates on the Splunk Community!

Last Chance to Submit Your Paper For BSides Splunk - Deadline is August 12th!

Hello everyone! Don't wait to submit - The deadline is August 12th! We have truly missed the community so ...

Ready, Set, SOAR: How Utility Apps Can Up Level Your Playbooks!

 WATCH NOW Powering your capabilities has never been so easy with ready-made Splunk® SOAR Utility Apps. Parse ...

DevSecOps: Why You Should Care and How To Get Started

 WATCH NOW In this Tech Talk we will talk about what people mean by DevSecOps and deep dive into the different ...