All Apps and Add-ons

A dynamic lister based on a static lister

ddarmand
Communicator

Hello everybody,

I want to create a dashboard with two listers, the first will be a static lister with differents source i use on Splunk, the second will search every hosts on the selected host.

I tried this but it don't work :




index=main



source="SPP"
SPP


source="RTH"
RTH


RMS
RMS


source="RMS"
RMS2


Reseau :
source

source

addterm

$target$



True
index=main sourcetype=syslog source | dedup host | table host
Value:
host_setting


host
host



host_setting

addterm

$target$







Thanks for the help !

0 Karma
1 Solution

ddarmand
Communicator

OK thanks to your apps i found the solution, here is the code :







*
2
False


index=main sourcetype="syslog"
-1h
now

source
source
source="$value$"
left
dedup $name$ | sort $name$
$name$

host
host
host="$value$"
search $source$ | dedup $name$ | sort $name$
$name$

option
Option :
$name$="$value$"


| transaction host
OSPF


| test
test


RMS
RMS



index=main sourcetype="syslog" $host$ $source$ $option$
-1h
now

results




<![CDATA[ Source: $source$
Host: $host$
soit la reqûete : $search$]]>






Thanks you very much !!!

View solution in original post

0 Karma

ddarmand
Communicator

OK thanks to your apps i found the solution, here is the code :







*
2
False


index=main sourcetype="syslog"
-1h
now

source
source
source="$value$"
left
dedup $name$ | sort $name$
$name$

host
host
host="$value$"
search $source$ | dedup $name$ | sort $name$
$name$

option
Option :
$name$="$value$"


| transaction host
OSPF


| test
test


RMS
RMS



index=main sourcetype="syslog" $host$ $source$ $option$
-1h
now

results




<![CDATA[ Source: $source$
Host: $host$
soit la reqûete : $search$]]>






Thanks you very much !!!

0 Karma

sideview
SplunkTrust
SplunkTrust

Well, you're using an addterm intention, and possibly the addterm is tacking it's term on after the dedup and table, which would result in

index=main sourcetype=syslog source | dedup host | table host | search source="foo"

which obviously wouldn't work. I would use the firebug addon to Firefox, and watch in the NET tab what search actually gets POST'ed to splunkd.

Using core UI, the answer would be to use the thornier stringreplace intention. There are examples in the "UI examples" app and also in its replacement the "dashboard examples" app.

If you want to make life easier for yourself, you should switch to using Sideview Utils. The same view can be rewritten far more simply and you wont have to think about intentions ever again.

<view autocancelinterval="100" ispersistable="true" issticky="true" onunloadcanceljobs="false" template="search.html">
  <label>aaaaaaa</label>
  <module name="SideviewUtils" layoutPanel="appHeader" />
  <module name="Search" layoutpanel="mainSearchControls" autorun="True">
    <param name="search">index=main</param>
    <module name="Pulldown">
      <param name="name">source</param>
      <param name="label">Reseau :</param>
      <param name="template">$name$="$value$"</param>
      <param name="staticOptions">
        <list><param name="value">SPP</param></list>
        <list><param name="value">RTH</param></list>
        <list><param name="value">RMS</param></list>
        <list><param name="value">RMS2</param></list>
      </param>
      <module name="Search">
        <param name="search">index=main sourcetype=syslog $source$ | dedup host | table host</param>

        <module name="Pulldown">
          <param name="name">host</param>
          <param name="label">Host</param>
          <param name="valueField">$name$</param>

        </module>
      </module>
    </module>
  </module>
</view>

ddarmand
Communicator

thanks you 😉 but i fixed it as you can see in my new code 🙂 but your answer is very usefull

0 Karma

sideview
SplunkTrust
SplunkTrust

Oops. I accidentally omitted the SideviewUtils module, which is required. Rookie mistake! I'll update my code. Glad you figured it out though.

0 Karma

ddarmand
Communicator

I am trying to use sideview utils with your code but it doesn't work, there is only a loading green bar at the top of the dashboard 😕

ok i fixed it by using template="dashboard.html" instead of search.html but the host pulldown is stuck on "loading".

I try to use firebug but i dont know where can i see the request in the network windows

0 Karma
Get Updates on the Splunk Community!

How to Monitor Google Kubernetes Engine (GKE)

We’ve looked at how to integrate Kubernetes environments with Splunk Observability Cloud, but what about ...

Index This | How can you make 45 using only 4?

October 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this ...

Splunk Education Goes to Washington | Splunk GovSummit 2024

If you’re in the Washington, D.C. area, this is your opportunity to take your career and Splunk skills to the ...