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

[spluzer]

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!!!

[woodcock · Accepted solution]

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]

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