topic Re: How do I place a hyperlink in a dashboard pdf report? in Dashboards & Visualizations

How do I place a hyperlink in a dashboard pdf report?

victorj405 — Wed, 08 Aug 2018 19:09:38 GMT

I am creating a splunk dashboard with a few reports.
On one report (outputted as a table), I want a long url to be replaced by a short number.
When clicking that number (VIA THE PDF DASHBOARD REPORT) , I want it to go to the external url.
Placing just the url works, but it's broken cause it's to long and wont open the full URL.

I followed the following guide:
https://answers.splunk.com/answers/542437/how-can-i-show-customized-hyperlink-text-on-a-dash.html

It works while viewing the dashboard in a browser except for I still don't know how to edit the link correctly.

  <row>
    <panel>
      <html>
        <style>
        </style>
      </html>
      <table>
        <title>Report</title>
        <search ref="Report"></search>
        <fields>Name, QueueTime, FinishTime, Result, BuildId</fields>
        <option name="count">10</option>
        <option name="drilldown">cell</option>
        <drilldown target="_blank">
          <condition field="BuildId">
            <link target="_blank">
              $row.URL$          # Not working . URL is the name of the filed with the long url that I want replaced by another field with a short number
              https://google.com # Works
            </link>
          </condition>
        </drilldown>
      </table>
    </panel>
  </row>

index="reports"
| where (source LIKE "%Report%")
| eval BuildId = Id + ""
| table Name, QueueTime, FinishTime, Result

Re: How do I place a hyperlink in a dashboard pdf report?

DalJeanis — Sat, 11 Aug 2018 03:59:56 GMT

Have you verified that the url works when pasted into the browser? Perhaps it has not been constructed correctly.

Re: How do I place a hyperlink in a dashboard pdf report?

jkat54 — Sun, 12 Aug 2018 12:47:48 GMT

What is broken about the link that it is putting into the PDF?

Does the link fail to word-wrap and doesn’t fit on the page?

Or is it not a valid hyperlink you can click on?

Re: How do I place a hyperlink in a dashboard pdf report?

victorj405 — Tue, 14 Aug 2018 14:09:20 GMT

I tried getting the $row.URL$ to work, but it doesn't. Not sure what I am doing wrong. The generated URL field itself is correct.

Re: How do I place a hyperlink in a dashboard pdf report?

victorj405 — Tue, 14 Aug 2018 14:12:47 GMT

If I just add the URL itself in a table, the link is clickable in the PDF, but it's to long and the browser will only open what hasn't went to the second line. The URL field itself is correct

Re: How do I place a hyperlink in a dashboard pdf report?

victorj405 — Tue, 14 Aug 2018 14:13:45 GMT

A powershell script gets the info and sends an html email and also sends this info into splunk. The html email's link works and looking at the dashboard in splunk on a browser, the link works.

Re: How do I place a hyperlink in a dashboard pdf report?

jkat54 — Tue, 14 Aug 2018 18:42:16 GMT

So if I gave you a custom search command that uses bit.ly service to shorten urls, would you be interested knowing that it’s giving bit.ly all your links but providing the short url and also statistics on their usage?

It would work like this

 ... | bitly urlfield=fieldWithLongURLs | eval url = bitly_output | table url ...