Reporting

help on issue between a loadjob savedsearch and a

jip31
Motivator

hi

I called a scheduled from my dashboard

| loadjob savedsearch="admin:XX:Hardware - Battery cycle pie" 
| search Site=$tok_filtersite|s$

I have an issue with | search Site=$tok_filtersite|s$ because with it I have no results in my dashboard but if I delete it I have results

My search is this one :

| inputlookup tablet_host.csv 
| lookup toto.csv "Hostname00" as host OUTPUT CycleCount00 
| where CycleCount00 > 200 
| lookup titi.csv HOSTNAME as host output SITE 
| stats count as NbHostCycleSup300 
| appendcols 
    [| inputlookup host.csv 
    | stats count as NbIndHost] 
| eval NbHostCycleInf300 = (NbIndHost - NbHostCycleSup300) 
| eval NbHostCycleSup300=NbHostCycleSup300, NbHostCycleInf300=NbHostCycleInf300 
| table NbHostCycleSup300 NbHostCycleInf300 SITE
| rename NbHostCycleSup300 as "> 300", NbHostCycleInf300  as "< 300", SITE as Site
| transpose

So why when I add | search Site=$tok_filtersite|s$ I have no results?
thanks

1 Solution

richgalloway
SplunkTrust
SplunkTrust

You get no results with | search Site=$tok_filtersite|s$ because it's searching for something that doesn't exist. There is no tok_filtersite token defined.

---
If this reply helps you, Karma would be appreciated.

View solution in original post

0 Karma

richgalloway
SplunkTrust
SplunkTrust

You get no results with | search Site=$tok_filtersite|s$ because it's searching for something that doesn't exist. There is no tok_filtersite token defined.

---
If this reply helps you, Karma would be appreciated.
0 Karma

jip31
Motivator

I dont understant what you mean because I retrieve the fields Site like this:
| lookup titi.csv HOSTNAME as host output SITE
| rename SITE as Site

0 Karma

richgalloway
SplunkTrust
SplunkTrust

That gives you a field called 'Site', not one called 'tok_filtersite'. Try | search Site=$Site|s$.

---
If this reply helps you, Karma would be appreciated.
0 Karma

jip31
Motivator

tok_filtersite is the token value of a dropdown list
In this dropdown list I retrieve the field SITE from a csv file
So when i am doing | search Site=$tok_filtersite|s$ its for doing a search from the Site valuz i have selected in my dropdown list

0 Karma

richgalloway
SplunkTrust
SplunkTrust

Thanks for the explanation.
Have you looked at the output following transpose? I believe you will not have a Site field after that.

---
If this reply helps you, Karma would be appreciated.
0 Karma

jip31
Motivator

thanks for your help

0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud | Unified Identity - Now Available for Existing Splunk ...

Raise your hand if you’ve already forgotten your username or password when logging into an account. (We can’t ...

Index This | How many sides does a circle have?

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

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...