topic Re: Redirect to Custom URL in Multivalued Column in Dashboards & Visualizations

How can I Redirect to Custom URL in Multivalued Column

JaysonD123 — Fri, 10 Jun 2022 14:29:11 GMT

I have a table that looks like this:

Time	Host	User	Activity
2021-01-01 01:02:01	ABC	Test	CommandLine: C:/Users/Cool/cool.exe File: cool.exe Hash: yr3f7r98jkfd7y38ykry73
2021-01-01 01:02:02	ABC	Test	CommandLine: C:/Users/Lame/lame.exe File: lame.exe Hash: kf39utkuk0ulftu39uk30utk
2021-01-01 01:02:03	ABC	Test	CommandLine: C:/Users/Idk/idk.exe File: idx.exe Hash: 9l09uk8dtyjy4j4098tk48

The query I used to made the table looks something like this:

host=ABC User=Test | rename host AS Host | eval Time=strftime(_time,"%Y-%m-%d %H:%M:%S"),Activity=mvappend("CommandLine: ".CommandLine," ","File: ".File," ","Hash: ".Hash) | table Time Host User Activity | dedup consecutive=true Activity sortby Time

I am trying to use a drilldown to make it so when I click the hash in my Dashboard, it redirects me to a website. The issue I'm have is when I add the link and I click the Hash, instead of just giving me the hash: "9l09uk8dtyjy4j4098tk48", it will give me entire cell "Hash: 9l09uk8dtyjy4j4098tk48" which bugs out my URL.

Expected Output:

https://website.com/9l09uk8dtyjy4j4098tk48

Actual Output:

https://website.com/Hash: 9l09uk8dtyjy4j4098tk48

Another issue is no matter what cell I click they will all try to redirect me to the website:

Example:

https://website.com/CommandLine: C:/Users/Lame/lame.exe

How can I make it so I can only click the hash value to get my expected output?

Re: Redirect to Custom URL in Multivalued Column

ITWhisperer — Fri, 01 Oct 2021 06:22:42 GMT

In your drilldown, try eval a new token which has the first part of the clicked value stripped off and use that new token in the link.

Re: Redirect to Custom URL in Multivalued Column

JaysonD123 — Mon, 04 Oct 2021 21:09:54 GMT

That worked thank you

Re: Redirect to Custom URL in Multivalued Column

nikhil29 — Fri, 10 Jun 2022 12:07:31 GMT

Hi Team,

Actually i am also trying to open the each build url in jenkins but custom url in splunk taking me jenkins website but not in build.

Re: Redirect to Custom URL in Multivalued Column

ITWhisperer — Fri, 10 Jun 2022 12:24:30 GMT

It is hard to tell without specifics, but I suspect you haven't encoded the information in the drilldown correctly, so Jenkins can't find or doesn't recognise the build information you are passing so defaults to main website.

Re: Redirect to Custom URL in Multivalued Column

nikhil29 — Fri, 10 Jun 2022 12:30:54 GMT

what shall i use in drill down url , so it can take url value for each table rows ?
Please have a look below code

"eventHandlers": [

{

"type": "drilldown.setToken",

"options": {

"tokens": [

{

"token": "build_number",

"key": "click.value"

}

]

}

{

"type": "drilldown.customUrl",

"options": {

"url": "some jenkins host/view/Puppet%20(develoment)/job/Puppet/job/puppet-development/job/development/\".build_number.\"/",

"newTab": true

Re: Redirect to Custom URL in Multivalued Column

ITWhisperer — Fri, 10 Jun 2022 12:46:46 GMT

I have no idea about doing it in Studio, but this might work.

"url": "some jenkins host/view/Puppet%20(develoment)/job/Puppet/job/puppet-development/job/development/$click.value|u$/",

Note the |u to url encode the name token.

Re: Redirect to Custom URL in Multivalued Column

nikhil29 — Fri, 10 Jun 2022 12:53:47 GMT

we used to pass in classic dashboard like $row.url|n$

likewise i 'am looking to pass on click link to custom url

Re: Redirect to Custom URL in Multivalued Column

nikhil29 — Fri, 10 Jun 2022 15:09:04 GMT

Tried it's not working, Well Thanks for quick reply