Html Panel form: How to create a table with two co...

Deepz2612 · ‎04-30-2019

Hi,

My requirement is to:
Create a table with two columns with left column having static data and right having dynamic value
The right dynamic value - meaning I wanted to see only the result of a Splunk query.

I used the follow code but unable to achieve it.

 <row>
    <panel>
      <title>Sample Template</title>
      <html>
        <table border="1" width="1000" padding="10px">
          <th>
            <tr>
              <th width="200" align="left">Impacted time window(in EST)</th>
              <th width="800" align="left">
                <panel>
                  strptime($search_earliest$, "%Y-%m-%d %H:%M:%S.%3N") to strptime($cmd_time.latest$, "%Y-%m-%d %H:%M:%S.%3N")

                </panel>

                </th>
            </tr>
            <tr>
              <th width="200" align="left">Success rate(Total and Regionwise) during Impact Window </th>
              <th width="800" align="left">
                <row>
                <panel>$country$</panel>
                </row>
                </th>
            </tr>
            <tr>
              <th width="200" align="left">Impact to Customer</th>
              <th width="800" align="left">Row - 3 - 2nd column</th>
            </tr>
            <tr>
              <th width="200" align="left">Error code(incase of IOT)</th>
              <th width="800" align="left">Row - 2 2nd column</th>
            </tr>
            <tr>
              <th width="200" align="left">Analysis</th>
              <th width="800" align="left">Enter your analysis details</th>
            </tr>
            <tr>
              <th width="200" align="left">Action taken</th>
              <th width="800" align="left">SMS delay has been added in Canada RTS ticket</th>
            </tr>
            <tr>
              <th width="200" align="left">Next Steps</th>
              <th width="800" align="left">will continue to monitor for next 1 hour</th>
            </tr>
            <tr>
              <th width="200" align="left">Advisory</th>
              <th width="800" align="left"> N/A </th>
            </tr>
            <tr>
              <th width="200" align="left">L1POE bridge opened(Yes/No)</th>
              <th width="800" align="left">Row - 3 - 2nd column</th>
            </tr>
            <tr>
              <th width="200" align="left">L1POE bridge detail</th>
              <th width="800" align="left">Row - 2 2nd column</th>
            </tr>

          </th>
        </table>
      </html>
    </panel>
  </row>
  <row>
    <panel>
      <html>
        <div align="right">
          <b>Dashboard Version 3.7</b>
        </div>
      </html>
    </panel>
  </row>
</form>

In the above - if you could see,my out is not displaying the time for Impacted time window(in EST) instead it is displaying the entire string I have given ( strptime($search_earliest$, "%Y-%m-%d %H:%M:%S.%3N") to strptime($cmd_time.latest$, "%Y-%m-%d %H:%M:%S.%3N")).

Kindly help me with it.

Note : I do not have permissions and access to use Splunk dashboard app.

niketn · ‎04-30-2019

@Deepz2612 you can use JS to convert search result data to html table as per your need. Refer to my older answer:

https://answers.splunk.com/answers/662523/how-to-show-table-result-in-one-page-table-modific.html

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"

Deepz2612 · ‎05-02-2019

Thanks..
But my requirement is to put in a tabular format.

In the above code that i have share,whatever search query that i give is getting printed as as table value rather than printing the result of the query.

Could you kindly help

Deepz2612 · ‎05-03-2019

Hi,

Could you kindly help please

Html Panel form: How to create a table with two columns with the right column having dynamic value?

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Why Splunk Customers Should Attend Cisco Live 2026 Las Vegas

What Is the Name of the USB Key Inserted by Bob Smith? (BOTS Hint, Not the Answer)

Automating Threat Operations and Threat Hunting with Recorded Future

Join the Conversation