Dashboards & Visualizations

Dashboard with a submit button so user can blacklist a server??

spluzer
Communicator

Hey Splunksters,

Noob here. Trying to build a dashboard with a submit button so user can blacklist a server?? Thinking I need to add a line to the lookup that no one can see, and then read and write to that area of the lookup. Incorporate into dashboard with a submit button. Here is the query portion my coworker was kind enough to get me started below. Any help is much appreciated. Also, any thoughts on how to creatively make sure that users aren't overwriting each others changes accidentally

| inputlookup alert_blacklist.csv
| streamstats count as count
| eval hidden_hosts = if(host = "SPLUNK ADMIN ONLY HOSTS ABOVE", 'count', 0)
| eventstats max(hidden_hosts) as hidden_hosts
| search count > 'hidden_hosts'

Thanks!!!

Tags (3)
0 Karma
1 Solution

woodcock
Esteemed Legend

You cannot do it with a row but you can do it with a column; the way to make a field that "nobody can see" is to name the field so that it starts with an underscore character ( _ ). So do this:

| inputlookup alert_blacklist.csv
| streamstats count as count
| search count > _hidden_hosts

You can see that the field is not visible by doing this:

| inputlookup alert_blacklist.csv

You can see that it really is there by doing this:

| inputlookup alert_blacklist.csv
| rename _hidden_hosts AS not_hidden_hosts

View solution in original post

woodcock
Esteemed Legend

You cannot do it with a row but you can do it with a column; the way to make a field that "nobody can see" is to name the field so that it starts with an underscore character ( _ ). So do this:

| inputlookup alert_blacklist.csv
| streamstats count as count
| search count > _hidden_hosts

You can see that the field is not visible by doing this:

| inputlookup alert_blacklist.csv

You can see that it really is there by doing this:

| inputlookup alert_blacklist.csv
| rename _hidden_hosts AS not_hidden_hosts

spluzer
Communicator

Thanks for the info on the hidden field Mr. Woodcock. I accepted as that will be useful. However, I've made some adjustments to the dashboard that I have a few more questions about if anyone is interested in. Here is the link to the new request.

https://answers.splunk.com/answers/777760/dashboard-can-add-value-to-lookup-through-submit-b.html

Get Updates on the Splunk Community!

Splunk Community Platform Survey

Hey Splunk Community, Starting today, the community platform may prompt you to participate in a survey. The ...

Observability Highlights | November 2022 Newsletter

 November 2022Observability CloudEnd Of Support Extension for SignalFx Smart AgentSplunk is extending the End ...

Avoid Certificate Expiry Issues in Splunk Enterprise with Certificate Assist

This blog post is part 2 of 4 of a series on Splunk Assist. Click the links below to see the other ...