Activity Feed
- Posted Re: display a dashboard without login on Dashboards & Visualizations. 06-10-2022 01:44 PM
- Posted Re: display a dashboard without login on Dashboards & Visualizations. 01-12-2022 05:00 PM
- Posted Re: Search 1 dashboard panel - Search 2 dashboard panel = third dashboard panel difference between two searches. on Splunk Search. 08-14-2021 02:25 PM
- Karma Re: Search 1 dashboard panel - Search 2 dashboard panel = third dashboard panel difference between two searches. for richgalloway. 08-14-2021 02:25 PM
- Posted Search 1 dashboard panel - Search 2 dashboard panel = third dashboard panel difference between two searches. on Splunk Search. 08-14-2021 11:44 AM
- Posted Re: display a dashboard without login on Dashboards & Visualizations. 06-28-2021 09:49 PM
- Posted Re: Bypassing Splunk Authentication to load dashboards on Security. 06-28-2021 09:28 PM
- Posted Re: Need help with a custom source type on Getting Data In. 06-28-2021 09:20 AM
- Karma Re: Need help with a custom source type for kamlesh_vaghela. 06-28-2021 09:19 AM
- Posted Re: Need help with a custom source type on Getting Data In. 06-28-2021 09:10 AM
- Posted Re: How to set SHOULD_LINEMERGE = false as default when using monitor to upload data? on Monitoring Splunk. 06-28-2021 08:51 AM
- Posted Re: Need help with a custom source type on Getting Data In. 06-27-2021 01:37 PM
- Posted Re: Need help with a custom source type on Getting Data In. 06-27-2021 08:58 AM
- Karma Re: Need help with a custom source type for kamlesh_vaghela. 06-27-2021 08:13 AM
- Posted Re: Need help with a custom source type on Getting Data In. 06-27-2021 08:03 AM
- Posted Re: Need help with a custom source type on Getting Data In. 06-27-2021 07:17 AM
- Posted Re: Need help with a custom source type on Getting Data In. 06-26-2021 08:48 PM
- Posted Need help with a custom source type on Getting Data In. 06-25-2021 04:05 PM
- Posted Re: I need help from you guru's! Split custom json array. on Getting Data In. 06-24-2021 06:39 PM
- Posted Re: How to split a json array into multiple events with separate timestamps? on Getting Data In. 06-24-2021 06:35 PM
Topics I've Started
Subject | Karma | Author | Latest Post |
---|---|---|---|
0 | |||
0 | |||
0 | |||
0 | |||
0 | |||
0 | |||
0 | |||
0 | |||
0 | |||
0 |
06-10-2022
01:44 PM
Here is what I did, probably a cleaner way to do it.. 🙂 I removed my domain and replaced my specific items with XXXXXX my splunk is on port 8000 locally server {
listen [::]:443 ssl http2;
listen 443 ssl http2;
server_name dashboard.yourdomain.com;
access_log logs/dashboard.log default;
ssl_session_timeout 10m;
ssl_protocols TLSv1.2 TLSv1.1 TLSv1;
ssl_certificate ssl/XXXX.pem;
ssl_certificate_key ssl/XXXX.pem;
ssl_session_cache shared:SSL:10m;
location ^~ /en-US/account {
return 302 https://dashboard.yourdomain.com;
}
location ^~ /en-US/app/search/search {
return 404;
}
location ^~ /en-US/app/launcher {
return 404;
}
location ^~ /en-US/app/search/reports {
return 404;
}
location ^~ /en-US/app/search/datasets {
return 404;
}
location ^~ /en-US/app/search/alerts {
return 404;
}
location ^~ /en-US/app/search/dashboards {
return 404;
}
location = / {
proxy_pass http://127.0.0.1:8000/en-US/account/insecurelogin?return_to=%2Fen-US%2Fapp%2Fsearch%2Fdashboard__historical_html?loginType=splunk&username=YOURUSERNAME&password=YOURPASSWORD;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header Host $host;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
sub_filter ':8000' '';
## SECURITY SETTINGS ##
add_header Referrer-Policy "same-origin";
add_header Feature-Policy " ";
add_header Strict-Transport-Security "max-age=31536000; preload" always;
add_header X-Frame-Options "SAMEORIGIN" always;
add_header X-Content-Type-Options "nosniff" always;
add_header Content-Security-Policy "default-src * data: blob: 'unsafe-inline' 'unsafe-eval'; script-src * 'unsafe-inline' 'unsafe-eval'; connect-src * 'unsafe-inline'; img-src * data: blob: 'unsafe-inline'; frame-src *; style-src * data: blob: 'unsafe-inline';font-src * data: blob: 'unsafe-inline';" always;
}
location / {
proxy_pass http://127.0.0.1:8000;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header Host $host;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
sub_filter ':8000' '';
## SECURITY SETTINGS ##
add_header Referrer-Policy "same-origin";
add_header Feature-Policy " ";
add_header Strict-Transport-Security "max-age=31536000; preload" always;
add_header X-Frame-Options "SAMEORIGIN" always;
add_header X-Content-Type-Options "nosniff" always;
add_header Content-Security-Policy "default-src * data: blob: 'unsafe-inline' 'unsafe-eval'; script-src * 'unsafe-inline' 'unsafe-eval'; connect-src * 'unsafe-inline'; img-src * data: blob: 'unsafe-inline'; frame-src *; style-src * data: blob: 'unsafe-inline';font-src * data: blob: 'unsafe-inline';" always;
}
}
... View more
01-12-2022
05:00 PM
yes..... ish...... was not ideal, but I used nginx as a reverse proxy.. I let nginx send the basic auth in the url to the actual splunk server... then nginx proxies the splung pages back to the user.. then i use nginx to block access to any other page that the dashboard user didnt need access to just to be extra safe. It's not idea or clean, but it works.
... View more
08-14-2021
02:25 PM
Here is what I had to change for anyone else looking, had to add " " to the token=XXXX value, and had to put the <done> block within the <search> blocks. Thanks Rich. <row>
<panel>
<single>
<title>Server Pending Payout</title>
<search>
<query>index="signa_pool" name!="Pir8Radio"| stats sum(pendingBalanceNum) as PendingBalance</query>
<earliest>-2m</earliest>
<latest>now</latest>
<done>
<set token="Panel1Value">$result.PendingBalance$</set>
</done>
</search>
<option name="drilldown">none</option>
<option name="numberPrecision">0.000</option>
<option name="rangeColors">["0x53a051","0x0877a6","0xf8be34","0xf1813f","0xdc4e41"]</option>
<option name="refresh.display">progressbar</option>
<option name="unit">SIGNA</option>
</single>
</panel>
<panel>
<single>
<title>Pool Account Balance</title>
<search>
<query>index="signum_node" | stats latest(guaranteedBalanceNQT) as PoolBal | eval PoolBal=round(PoolBal/100000000,4)</query>
<earliest>-2m</earliest>
<latest>now</latest>
<done>
<set token="Panel2Value">$result.PoolBal$</set>
</done>
</search>
<option name="drilldown">none</option>
<option name="height">114</option>
<option name="numberPrecision">0.000</option>
<option name="rangeColors">["0x53a051","0x0877a6","0xf8be34","0xf1813f","0xdc4e41"]</option>
<option name="refresh.display">progressbar</option>
<option name="unit">SIGNA</option>
</single>
</panel>
<panel>
<single>
<title>Pool Excess</title>
<search>
<query>| makeresults | eval Excess=$Panel2Value$ - $Panel1Value$</query>
<earliest>-2m</earliest>
<latest>now</latest>
</search>
<option name="drilldown">none</option>
<option name="height">111</option>
<option name="numberPrecision">0.000</option>
<option name="rangeColors">["0x53a051","0x0877a6","0xf8be34","0xf1813f","0xdc4e41"]</option>
<option name="refresh.display">progressbar</option>
<option name="unit">SIGNA</option>
</single>
</panel>
</row>
<row>
... View more
08-14-2021
11:44 AM
Search 1 dashboard panel - Search 2 dashboard panel = third dashboard panel difference between two searches. Here is my first search: index="signa_pool" name!="Pir8Radio"| stats sum(pendingBalanceNum) The result of the above is : 595.3440 Here is my second search: index="signum_node" | stats latest(guaranteedBalanceNQT) as PoolBal | eval PoolBal=round(PoolBal/100000000,4) The result of the above is: 1,904.5167 I need the third dashboard panel to take 1,904.5167 - 595.3440 = 1,309.1727 MY QUESTION: How can I either create my end search that equals 1,309.1727 or how can i store previous search results as a variable to use in the third panel? I'm stuck lol, tried for about an hour, so any help would be greatly appreciated.
... View more
06-28-2021
09:49 PM
embedded reports are not the same as dashboard. OP wanted a way to display a DASHBOARD without login. Embedded reports are just that, reports, you can not display live real time data. SO, how do you display a dashboard without having to login?
... View more
06-28-2021
09:28 PM
the URL you couldn't reach was a url you posted. its broken. is what he was saying. your message: Hi Arun_N_007,
this is possible if Splunk is configured for integration with Active Directory: it's possible to configure browser to execute automatic login using users account for authentication.
In othe words: user does logon to AD domain when open his own computer ( “joined” to the domain).
When user will connect to Splunk using own browser (configured as described in the following URL), he will not have to type his credentials again.
https://prdsoftware.com/helpmasterlive/KnowledgeBase/kbarticle.aspx?view=107
Obviously this functionality runs only with a Splunk Enterprise License, it doesn't run with a free license
... View more
06-28-2021
09:10 AM
it will not let me set "should_linemerge=true" with line_breaker set to }(\,){\"address\"
... View more
- Tags:
- Reply
06-28-2021
08:51 AM
Then please include instructions how to do that in windows splunk.
... View more
06-27-2021
08:58 AM
I am using splunk REST plugin to grab json data. Plugin may strip raw info i am not sure. But here is the real API json data: https://signapool.notallmine.net/api/getMiners @kamlesh_vaghela If you can make input work with raw json i can just write a script that grabs json and puts it into a text file every 2 mins and not use REST plugin.
... View more
06-27-2021
08:03 AM
This is how i have it configured today, but it only grabs the first user "Pir8radio" ignores the rest. And this is result, but result is only the first array item. not the rest of them.
... View more
06-25-2021
04:05 PM
Hi, starting fresh. maybe I can explain a bit better here.. I found another similar issue to mine here: https://community.splunk.com/t5/Getting-Data-In/How-to-split-a-json-array-into-multiple-events-with-... I need it to break out the 20+ items in the string. For some reason setting up my source type like in this post, just gives me the first user worth of info. It doesnt break them all out.. Here is a dump of one of the raw json requests. its truncated at then end, looking into that. But i basically need to break out each user in this list with their stats just like that previous post above talks about. any help would be appreciated.
... View more
Labels
- Labels:
-
sourcetype
06-24-2021
06:39 PM
this post, almost addresses what i'm trying to do, but it only supplies me with the first user record.. https://community.splunk.com/t5/Getting-Data-In/How-to-split-a-json-array-into-multiple-events-with-separate/m-p/139855/highlight/false#M28742 I need it to break out the 20 items in the string, not just give me the first one
... View more
06-24-2021
06:35 PM
I am in need of this exact solution, except it appears to stop after the first match in a json string? How do i prevent that? for example if you look at the original post there are multiple "TEST" in that single json string. I need to break these out into three records... your response works but only on the first record. any ideas?
... View more
06-24-2021
04:03 PM
So each user has stats, in the original post that shows just my user "pir8radio" (shown below) I need to be able to create dashboards off of the user stats. Below the address and addressRS represent one user.. Everything else is his data. So my user S-GJ9C-T2EF-C82A-8EZPD is also know as 7338594461977886954 or by name: Pir8Radio, has a pending balance of 0 Signa, a total capacity of 80.xxxxx etc etc.. This data is grabbed by splunk every 2 mins. I need to chart based on this data. filtered however i filter it on the dashboard. normal splunk usage.. my issue is that there are multiple users data polled every 2 mins in one json response.. so i need to tie all of the info below as one record, then the next user as another record, then i can break out the fileds per record. {
"address":"7338594461977886954",
"addressRS":"S-GJ9C-T2EF-C82A-8EZPD",
"pendingBalance":"0 SIGNA",
"totalCapacity":80.04373488882364,
"totalEffectiveCapacity":64.44006329147014,
"commitment":"2467.564 SIGNA",
"committedBalance":"159010 SIGNA",
"boost":0.4127924541887127,
"boostPool":0.6147618784432624,
"sharedCapacity":64.44006329147014,
"sharePercent":100,
"donationPercent":1,
"nConf":120,
"share":0.4091681714251888,
"minimumPayout":"10 SIGNA",
"currentRoundBestDeadline":"511",
"name":"Pir8Radio",
"userAgent":"signum-miner/1.8.0"
} So when you poll that url, you get like 20 of the above all back to back in a single JSON response. i need to break them out into 20 records not one record with 20 users in it.. Not sure im explaining well.. copy paste the above 20 times back to back and that is what splunk ingests every 2 mins. So in splunk i see this: Instead of one record with 1 result each for each item miners{}.address , miners{}.addressRS , pendingBalance etc...
... View more
06-24-2021
03:07 PM
Ok, anyone else? 🙂
... View more
06-24-2021
02:09 PM
here is the actual json request as it gets logged in splunk. https://signapool.notallmine.net/api/getMiners
... View more
06-24-2021
02:03 PM
I have an index, and im ingesting json using the REST plugin. so every poll i get a big json chunk with all the users... SPluk can id the different fields but not associate each stat with each user.. so right now my index has big chunks with all users as one entry. I can wipe out the stored data and start over.. that is fine. i just started logging. If that makes sense. so if thats just a search i'll give it a go
... View more
06-24-2021
01:42 PM
Using windows... so don't laugh but how do I add this in.. Most of you guys edit configs directly.. get me started and ill make it happen lol. Thank you for the fast response by the way.
... View more
06-24-2021
01:15 PM
{
"miners":[
{
"address":"7338594461977886954",
"addressRS":"S-GJ9C-T2EF-C82A-8EZPD",
"pendingBalance":"0 SIGNA",
"totalCapacity":80.04373488882364,
"totalEffectiveCapacity":64.44006329147014,
"commitment":"2467.564 SIGNA",
"committedBalance":"159010 SIGNA",
"boost":0.4127924541887127,
"boostPool":0.6147618784432624,
"sharedCapacity":64.44006329147014,
"sharePercent":100,
"donationPercent":1,
"nConf":120,
"share":0.4091681714251888,
"minimumPayout":"10 SIGNA",
"currentRoundBestDeadline":"511",
"name":"Pir8Radio",
"userAgent":"signum-miner/1.8.0"
},
{
"address":"632........... REPEATS FOR EACH USER So my json output looks like the above, but there are anywhere from 1-1000 users.. I'm not quite sure how to break up each user and have each of the stats per user? Any help would be greatly appreciated guys.. thanks!!
... View more
Labels
- Labels:
-
JSON
06-30-2020
10:29 AM
Did not work 😞 Seems to be an issue here somewhere: | stats sum(eval(if('usage_info.d_w'>=0,1,0))) as d_samples sum(eval(if('usage_info.solar_w'>=0,1,0))) as solar_samples as samples sum(usage_info.d_w) as d_watt_sum sum(usage_info.solar_w) as solar_watt_sum by _time
... View more
06-23-2020
05:22 PM
So i have this search: index="sense_power_monitor" | where 'usage_info.solar_w'>=0
| bin _time span=1h
| stats count as samples sum(usage_info.solar_w) as watt_sum by _time
| eval kW_Sum=watt_sum/1000
| eval avg_kWh=kW_Sum/samples
|stats sum(avg_kWh) which returns: 47.56 And i have this search: index="sense_power_monitor" | where 'usage_info.d_w'>=0
| bin _time span=1h
| stats count as samples sum(usage_info.d_w) as watt_sum by _time
| eval kW_Sum=watt_sum/1000
| eval avg_kWh=kW_Sum/samples
|stats sum(avg_kWh) which returns: 74.73 I know i can get the percentage difference between these two search results by 47.56/74.73*100 = 63.64% How can I do one search that gives me that final percent?
... View more