Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- About kajolsharma
kajolsharma
Path Finder
Member since:
06-25-2021
11-23-2021
Community Statistics
| Posts | 20 |
| Solutions | 1 |
| Karma Given | 4 |
| Karma Received | 0 |
| Member Since | 06-25-2021 |
Activity Feed
- Posted Re: join query not returning result on Splunk Search. 11-22-2021 10:46 PM
- Posted Re: join query not returning result on Splunk Search. 11-22-2021 02:07 AM
- Posted Re: join query not returning result on Splunk Search. 11-18-2021 09:08 AM
- Posted join query not returning result on Splunk Search. 11-18-2021 07:21 AM
- Posted Re: adding a dummy row on Other Usage. 10-20-2021 12:29 AM
- Posted adding a grid to table on Dashboards & Visualizations. 09-08-2021 06:18 AM
- Posted adding a dummy row on Other Usage. 09-07-2021 08:31 AM
- Posted extract month from a date field on Reporting. 09-06-2021 07:02 AM
- Karma Re: How to change tables cells dynamically without showing the value in the cell? for ITWhisperer. 08-10-2021 09:15 AM
- Posted Re: How to change tables cells dynamically without showing the value in the cell? on Dashboards & Visualizations. 08-10-2021 08:39 AM
- Posted How to change tables cells dynamically without showing the value in the cell? on Dashboards & Visualizations. 08-10-2021 07:24 AM
- Posted Re: How to add a logo or image to a title header of a panel ? on Dashboards & Visualizations. 08-09-2021 01:49 AM
- Posted Re: How to place a panel drilldown on top of another panel on Dashboards & Visualizations. 08-04-2021 04:15 AM
- Karma Re: How to place a panel drilldown on top of another panel for bowesmana. 08-04-2021 04:12 AM
- Karma Re: How to add a logo or image to a title header of a panel ? for kamlesh_vaghela. 08-04-2021 04:06 AM
- Posted How to place a panel drilldown on top of another panel on Dashboards & Visualizations. 08-03-2021 07:05 AM
- Posted How to add a logo or image to a title header of a panel ? on Dashboards & Visualizations. 08-03-2021 07:00 AM
- Posted Re: Not able to apply dynamic image through JS on All Apps and Add-ons. 07-05-2021 01:42 AM
- Tagged Re: Not able to apply dynamic image through JS on All Apps and Add-ons. 07-05-2021 01:42 AM
- Posted Re: Not able to apply dynamic image through JS on All Apps and Add-ons. 06-27-2021 11:39 PM
Topics I've Started
| Subject | Karma | Author | Latest Post |
|---|---|---|---|
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 |
11-22-2021
10:46 PM
Output of first query: O/p of 2nd query: You can see I have ran the 2 queries separately in the snips above. And you can find that the searched job result is present in both the results. o/p of join query:[No result] o/p of join query by putting a filter on that jobname: [Its shows the result] I hope you get what I trying to say.
... View more
11-22-2021
02:07 AM
Hi, i have modified the query : index ="batch_monitoring"|search name=BPSP1060 |rex mode=sed field=name "s/ //g" |table "Activity Name",name,"job name",start,end,status,"Workstation Name _Job"|rename "Workstation Name _Job" as "Workstation" But still I see no results when i use it with join query .
... View more
11-18-2021
09:08 AM
Yes, we do have name field in both queries. Refer below screenshot:
... View more
11-18-2021
07:21 AM
Hi, I have a query below with a join condition .The issue is if I am hardcoding name value I am getting the result but when I'm removing it, not seeing any results plus I m getting this error in screenshot. Validated that it is not because of space issue .Can somebody suggest?
... View more
10-20-2021
12:29 AM
Here i m getting count as 0 .Wat if I want the actual count of below statuses :- query used - |inputlookup append=t Month_End_Tracker.csv|dedup "Activity Name"|stats count by Status|append [| makeresults | eval Status="Total" | eval count=0]|table Status count
... View more
09-08-2021
06:18 AM
Hi, I hav a table below to which I want to add the gridlines. It is controlled by the css code below: Can anybody suggest? table td > a,table td > a:hover,header{
color:#fff
}
/* [47] */
.table-chrome,.table-chrome .sorts a,.table-chrome .sorts a:hover{
color:white!important;
border:2px solid black;
}
/* [48] */
.table-chrome > thead > tr > th{
background-image:none;
background-color:transparent!important;
border:2px solid black;
font-size: medium;
text-align:-webkit-auto;
}
/* background colour for tables: Status volume & alert breaches */
/* [49] */
.table-chrome.table-striped > tbody > tr.odd > td,.table-chrome.table-striped > tbody > tr.even > td{
// background-color:#393a4b;
padding-top:1px;
border-color:transparent;
text-align:auto;
}
/* [50] */
tr.shared-resultstable-resultstablerow.odd, tr.shared-resultstable-resultstablerow.even {
background: none;
}
... View more
09-07-2021
08:31 AM
Hi , I want to add a row total=0 in the below table .Can somebody suggest? query used is: index="monthend" source="Period End Tracker_6Sep'21.csv"|rename "Activity Name" as Activity|dedup Activity|eval status_1=if(Activity=="Month End Closing for AP,AR & GL","Delay","On Track")|stats count by status_1
... View more
Labels
- Labels:
-
saved search
09-06-2021
07:02 AM
Hi, I hav a "Planned Start date" Field through which I am trying to extract month in the format (e.g January).Can somebody suggest? Below is what i have tried index="tier1" sourcetype="csv"| stats latest("Planned Start Date") AS Time| eval monthdisplay=strftime(strptime('Planned Start Date',"%m-%d-%Y"),"%B")|fields Time monthdisplay
... View more
Labels
- Labels:
-
scheduled search
08-10-2021
08:39 AM
Nope, it is making the table contents as blank .Wat I want is to hide the highlighted values.
... View more
08-10-2021
07:24 AM
I have a panel in which I want to apply 2 colors depending on the threshold something like below. However, I don't want to show the HIGH and LOW values inside the cell. Below is the codepiece that i've referred: <panel id="mon2">
<title>QUALITY MATRIX</title>
<html>
<div>
<div>
<p id="m2">
<div class="legend" style="float: down;height:30px;width:30px;border-radius:50%;background-color:#FF0000;display: inline-grid;margin-right:40px;font-weight: bolder;text-align: center">1</div>
</p>
</div>
</div>
</html>
<table id="master">
<search>
<query>index=highjump sourcetype=dbconnectsql source=*MaterialMaster-TotalCount* earliest=@d latest=now()
| rex field=source "^(?P<site>[^\_]+)"
| search site="Allentown"
| dedup _time
| stats sum(TotalCount) as "Total Material extensions [Today]"
| appendcols
[ search index=highjump sourcetype=dbconnectsql source=*MaterialMaster-ErrorCount* earliest=@d latest=now()
| rex field=source "^(?P<site>[^\_]+)"
| search site="Allentown"
| dedup _time
| stats sum(TotalCount) as "Unsuccessful Material Extensions [Today]"
]
| appendcols
[ search index=highjump sourcetype=dbconnectsql source=*MaterialMaster-ErrorCount* earliest=-1y@y latest<@d
| dedup _time
| rex field=source "^(?P<site>[^\_]+)"
| search site="Allentown"
| stats sum(TotalCount) as "Unsuccessful Material Extensions [Backlog]"
]
| table "Total Material extensions [Today]", "Unsuccessful Material Extensions [Today]","Unsuccessful Material Extensions [Backlog]"
| appendpipe
[ stats count
| where count==0]
| fillnull value=0 "Unsuccessful Material Extensions [Today]"
| fillnull value=0 "Total Material extensions [Today]"
| fillnull value=0 "Unsuccessful Material Extensions [Backlog]" | transpose
| rename "row 1" as "count"
| eval color =case(count>"0","HIGH",count="0","LOW") | foreach column [ eval <<FIELD>>=mvappend('<<FIELD>>',color)]
| fields - color| fields - count </query>
<earliest>-24h@h</earliest>
<latest>now</latest>
</search>
<format type="color" field="column">
<colorPalette type="expression">case (match(value,"LOW"),"#294E70",match(value,"HIGH"),"#D22B2B")</colorPalette>
</format>
<!-- <format type="color" field="count">
<colorPalette type="expression">case (match(value,"LOW"),"#294E70",match(value,"HIGH"),"#D22B2B")</colorPalette>
</format>-->
<option name="drilldown">none</option>
<option name="refresh.display">progressbar</option>
</table>
<html>
<style>
#mon2{
width: 25% !important;
align: center !important;
text-align: left !important;
padding: 0px !important;
margin: 0px 0px 0px 0px !important;
}
#master .table th, .table td {
text-align: left !important;
<!--font-weight: bold !important;-->
font-size:800% !important;
color: #FFFFFF !important;
<!--background-color: #48AAAD !important;-->
font-family: Arial, Helvetica, sans-serif;
font-variant: normal;
font-stretch: expanded;
}
</style>
</html>
</panel>
... View more
Labels
- Labels:
-
Dashboard Studio
-
panel
-
simple XML
-
table
08-09-2021
01:49 AM
How can i add a circular legend beside title ? Something like this ?
... View more
08-04-2021
04:15 AM
By on top I meant on top of existing panel ,both the panels should be visible but the second one should not completely overlap first. If that's possible???
... View more
08-03-2021
07:05 AM
Hi, I want to place a panel on top of existing panel on the click of a cell. First screen: Second Screen: Is this feasible through Splunk?
... View more
Labels
- Labels:
-
drilldown
-
javascript
-
panel
-
table
08-03-2021
07:00 AM
I am looking to add icon beside my panel title somewhat like this: However, I m getting like this .Can anybody suggest? <panel id="mon1">
<html>
<div>
<img height="50px" width="50px" src="/static/app/ERPTower/icons8-in-transit-96.png" style="float:left"/>
</div>
</html>
<title>SHIPMENT FULFILLMENT</title>
<table>
<search>
<query>|makeresults| eval name1="Ship Confirmation Request" |eval name2="Shipment Loads"|eval name3="Ready to be Shipped loads"|table name1 , name2, name3|transpose|fields - column|rename "row 1" as " "</query>
<earliest>-24h@h</earliest>
<latest>now</latest>
</search>
<option name="drilldown">none</option>
<option name="refresh.display">progressbar</option>
<format type="color">
<colorPalette type="sharedList"></colorPalette>
<scale type="sharedCategory"></scale>
</format>
</table>
<html>
<style>
#mon1{
width: 20% !important;
align: center !important;
text-align: center !important;
padding: 0px !important;
margin: 0px 0px 0px 0px !important;
}
</style>
</html>
</panel>
... View more
Labels
- Labels:
-
Dashboard Studio
-
panel
07-05-2021
01:42 AM
How can we implement tooltip for the below arrow ? Tooltip can include search query which gives results for which server is UP....For example: Webserver: Up
... View more
- Tags:
- dashboard
06-27-2021
11:39 PM
<panel id="sk1">
<title>ABILENE</title>
<html>
<head>
<style>
.down {
background-image: url('/static/app/ERPTower/downarrow.png') !important;
background-repeat: no-repeat !important;
background-size: 50px 50px; !important;
width: 280px; !important;
height: 100px; !important;
background-position: center; !important;
position: relative; !important;
}
.up {
background-image: url('/static/app/ERPTower/up2.png') !important;
background-repeat: no-repeat !important;
background-size: 50px 50px; !important;
width: 280px; !important;
height: 100px; !important;
background-position: center; !important;
position: relative; !important;
}
</style>
</head>
</html>
<html>
<div>
<img class="center" height="240px" width="220px" src="/static/app/ERPTower/warehouse2.png"/>
</div>
</html>
<table id="sample">
<search>
<!--<query>|makeresults | eval A ="UP"| eval B="DOWN" | fields B|rename B AS " "</query>-->
<query>index = *highjump_server*
| search Server_location=Abilene| stats sum(Status_Code) AS Status
| eval B=case (Status=0,"UP",Status=1,"DOWN") |eval _time=now()
| table B|rename B as " "</query>
<earliest>$time.earliest$</earliest>
<latest>$time.latest$</latest>
</search>
<option name="drilldown">cell</option>
<option name="refresh.display">progressbar</option>
<drilldown>
<link target="_blank">/app/ERPTower/high_jump_kpis_in_progress</link>
</drilldown>
</table>
<html id="alertbar">
<div>
<span class="fas fa-exclamation-triangle" style="color: red; margin-right: 5px; margin-left: 5px;"/>
<a href="batch_alert_analytics" target="_new" style="color: white; margin-right:5px;">Notifications: $sd$</a>
</div>
</html>
<html>
<style>
div#alertbar {
bottom: 0px;
background: #4d4e61;
border-radius: 0px 0px 5px 5px;
vertical-align: bottom;
position: absolute;
}
#sk1{
width: 20% !important;
align: center !important;
text-align: center !important;
padding: 0px !important;
margin: 0px 0px 0px 0p !important;
}
</style>
</html>
</panel>
... View more
06-27-2021
11:19 PM
Hi, I am not able to remove below scrollbar. Any suggestions?
... View more
- Tags:
- hi
06-25-2021
10:54 AM
I think there is a slight modification //List of table IDs to add icon
var tableIDs = ["sample", "sample1", "sample2", "samplen", "sample19"];
for (i = 0; i < tableIDs.length; i++) {
//var sh = mvc.Components.get("sample");
var sh = mvc.Components.get(tableIDs[i]);
if (typeof(sh) != "undefined") {
sh.getVisualization(function(tableView) {
// Add custom cell renderer and force re-render
tableView.table.addCellRenderer(new CustomRangeRenderer());
tableView.table.render();
});
}
}
}); correction
... View more
- Tags:
- I think
06-25-2021
10:11 AM
Thanks Kamlesh it worked. Meanwhile I hav got another issue ,the JS what i hav written works for single panel id. However i hav 19 such panels. How should i modify it ?Any suggestions. Below is JS which i am using : require([
'underscore',
'jquery',
'splunkjs/mvc',
'splunkjs/mvc/tableview',
'splunkjs/mvc/simplexml/ready!'
], function(_, $, mvc, TableView) {
var CustomRangeRenderer = TableView.BaseCellRenderer.extend({
canRender: function(cell) {
return cell.field;
},
render: function($td, cell) {
var value = cell.value;
if(value=="UP" )
{
$td.html("<div class='up'> </div>")
}
else if(value=="DOWN")
{
$td.html("<div class='down'> </div>")
}
else if(value=="UNKNOWN" || value=="N/A")
{
$td.html("<div class='unknown'> </div>")
}
else if(value=="WARN")
{
$td.html("<div class='warn'> </div>")
}
}
});
var sh = mvc.Components.get("sample");
if(typeof(sh)!="undefined") {
sh.getVisualization(function(tableView) {
// Add custom cell renderer and force re-render
tableView.table.addCellRenderer(new CustomRangeRenderer());
tableView.table.render();
});
}
});
... View more
06-25-2021
03:44 AM
Hi, Want to apply below arrow dynamically in my dashboard. Hav used custom JS and CSS for it. However, it is not working for my query : index = *highjump_server* | search Server_location=Abilene|rename Server_location as DC|table DC, Server_Msg,Server_type,Status_Code| stats sum(Status_Code) AS Status | eval B=case (Status=0,"UP",Status=1,"DOWN") |eval _time=now() |table B _time Whereas it is working for |makeresults | eval A ="UP"| eval B="DOWN" | fields B.Not able to understand y though. Can you guys pls help here urgently ?
... View more
Labels
- Labels:
-
dashboard
-
troubleshooting
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
11-23-2021
07:07 AM
|
