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 kavyaa
kavyaa
Explorer
Member since:
06-23-2015
06-05-2020
Community Statistics
| Posts | 16 |
| Solutions | 0 |
| Karma Given | 5 |
| Karma Received | 1 |
| Member Since | 06-23-2015 |
Activity Feed
- Karma Re: How to get top 10 values in splunk search ? for martin_mueller. 06-05-2020 12:47 AM
- Karma Re: How to get top 10 values in splunk search ? for richgalloway. 06-05-2020 12:47 AM
- Karma Align results with time differences for crt89. 06-05-2020 12:47 AM
- Got Karma for Re: Splunk DB Connect 1: Where do I put the token name in a dbquery search string for a chart drilldown?. 06-05-2020 12:47 AM
- Karma Re: convert time format for kristian_kolb. 06-05-2020 12:46 AM
- Karma Re: Form input type=text alignment issues for araitz. 06-05-2020 12:45 AM
- Posted Re: How to apply dynamic visibility for table columns in splunk dashboards? on Dashboards & Visualizations. 07-10-2015 04:18 AM
- Posted Re: How to find yearlly,monthly, weekly wise data using single date value? on Splunk Search. 07-09-2015 10:14 PM
- Posted Re: How to apply dynamic visibility for table columns in splunk dashboards? on Dashboards & Visualizations. 07-09-2015 05:59 AM
- Posted How to apply dynamic visibility for table columns in splunk dashboards? on Dashboards & Visualizations. 07-09-2015 05:09 AM
- Tagged How to apply dynamic visibility for table columns in splunk dashboards? on Dashboards & Visualizations. 07-09-2015 05:09 AM
- Tagged How to apply dynamic visibility for table columns in splunk dashboards? on Dashboards & Visualizations. 07-09-2015 05:09 AM
- Posted Re: How to find yearlly,monthly, weekly wise data using single date value? on Splunk Search. 07-08-2015 10:54 PM
- Posted Re: How to find yearlly,monthly, weekly wise data using single date value? on Splunk Search. 07-08-2015 10:54 PM
- Posted How to find yearlly,monthly, weekly wise data using single date value? on Splunk Search. 07-08-2015 06:30 AM
- Tagged How to find yearlly,monthly, weekly wise data using single date value? on Splunk Search. 07-08-2015 06:30 AM
- Tagged How to find yearlly,monthly, weekly wise data using single date value? on Splunk Search. 07-08-2015 06:30 AM
- Tagged How to find yearlly,monthly, weekly wise data using single date value? on Splunk Search. 07-08-2015 06:30 AM
- Posted How to get top 10 values in splunk search ? on Splunk Search. 07-08-2015 05:58 AM
- Tagged How to get top 10 values in splunk search ? on Splunk Search. 07-08-2015 05:58 AM
Topics I've Started
| Subject | Karma | Author | Latest Post |
|---|---|---|---|
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 |
07-10-2015
04:18 AM
I have seen previously. In that dashboard examples, hide/ show selection option for number of rows for single column(source type)... Idid that one. My requirement is selection option for Table column names. not for rows. My query is
***| dbquery "WHCMB" "SELECT *business_date, company code , line_no , oracle_gl, contract_code, apl_code, customer_id, currency, balance,ccy_balance,product code, branch, asset_type from EFZ_VIEW_DWT__GL_BAL" limit=10****
I want to put check boxes for **business_date, company code , line_no , oracle_gl, contract_code, apl_code, customer_id, currency, balance,ccy_balance,product code, branch, asset_type** 13 column names . see above posted image. Please help me. Thanks in advance. A.kavya
... View more
07-09-2015
10:14 PM
Hi woodcock garu,
Yes.Thank you for you reply. I want exactly put the filter on year, month, day using transdate.
|dbquery "CENTRO" "SELECT TransDate , ShowRoomCode, Num_of_Customers FROM Centro_Customer_Visit | rex field=TransDate "(?\d{4})-(?\d+)-(?\d+)" | table date_year date_month date_mday ShowRoomCode Number_of_Customers
when i execute the above query in search, i am getting error like
Error in 'dbqury' command : command ="dbquery", java.lang.IllegalArgumentException:illegal string-escape sequence:"\d".
Please help me. Please resolve this issue.
Thanks in advance,
A.kavya.
... View more
07-09-2015
05:59 AM
As your wish, either dropdown or checkbox. But I want to hide& show cloumns dynamically . Please help me.
... View more
07-09-2015
05:09 AM
Hi,
I have created sample dashboard . In that 14 columns there. I want hide last 5 cloumns dynamically and I want show 5 cloumns dynamically. Is it possible?. How it will work?. My idea is same as below 2nd image . Please check it once. Please help me. Thanks in advance.
The query as follows
**| dbquery "WHCMB" "SELECT *business_date, company code , line_no , oracle_gl, contract_code, apl_code, customer_id, currency, balance,ccy_balance,product code, branch, asset_type from EFZ_VIEW_DWT__GL_BAL" limit=10**
... View more
07-08-2015
10:54 PM
Hi,
I have query as like this
**
|dbquery "CENTRO" "SELECT TransDate , ShowRoomCode ,
Num_of_Customers FROM Centro_Customer_Visit
**
The output is as follows
**
Transdate ShowRoomCode Number_of_Customers
2011-03-18 C01 26
2011-06-26 C02 43
2012-03-16 C01 18
2012-05-21 C03 14
2013-04-23 C02 27
2013-07-14 C01 13
2014-02-12 C03 45
2014-03-29 C02 23
2015-01-21 C01 12
**
I want to apply 3 filters for TransDate. First filter for Year, Second filter for month, third filter for day using the above transdate column. How its work?. When i click on particular year, particular month, perticular day that regarding showroomcode,total customers placed into chart
Please help me. Thanks in advance.......
... View more
07-08-2015
10:54 PM
Hi,
I have query as like this
**
|dbquery "CENTRO" "SELECT TransDate , ShowRoomCode ,
Num_of_Customers FROM Centro_Customer_Visit
**
The output is as follows
**
Transdate ShowRoomCode Number_of_Customers
2011-03-18 C01 26
2011-06-26 C02 43
2012-03-16 C01 18
2012-05-21 C03 14
2013-04-23 C02 27
2013-07-14 C01 13
2014-02-12 C03 45
2014-03-29 C02 23
2015-01-21 C01 12
**
I want to apply 3 filters for TransDate. First filter for Year, Second filter for month, third filter for day using the above transdate column. How its work?. When i click on particular year, particular month, perticular day that regarding showroomcode,total customers placed into chart
Please help me. Thanks in advance.......
... View more
07-08-2015
06:30 AM
Hi,
I have Transaction date format as below. I want to find yearlly,monthly, weekly wise data using single date value?.
Can we apply filters for that?. Please help me. Thanks in advance........
**2011-03-18
2011-06-26
2012-03-16
2012-05-21
2013-04-23
2013-07-14
2014-02-12
2014-03-29
2015-01-21**
... View more
07-08-2015
05:58 AM
Hi,
I want to get top 10 src_ip . I have selected descending order for recv_bytes column .
Please help me.
Query as follows
source="F:\Splunk_Log Files\*" status ="Allow" src_ip | stats sum(recv_bytes) by src_ip .
... View more
07-08-2015
03:05 AM
I have seen that post. I have tried . But i did nt get correct data regarding selected input time filter. The code is follows. Please help me. Timestamp column "TransDate" has no time , only date values
Trandate coulmn have data format like this
2011-03-18
2011-06-26
2012-03-16
2012-05-21
2013-04-23
2013-07-14
2014-02-12
2014-03-29
2015-01-21
xml code is as follow
**<form>
<label>sample_time</label>
<fieldset submitButton="false" autoRun="true">
<input type="time" token="TOKEN1" searchWhenChanged="true">
<label>Selct Date</label>
<default>
<earliest>1300645800</earliest>
<latest>1300905000</latest>
</default>
</input>
</fieldset>
<row>
<panel>
<table>
<search>
<query>| dbquery "CENTRO" "SELECT TransDate , ShowRoomCode as srcode , Num_of_Customers as totalcs FROM Centro_Customer_Visit WHERE TransDate='$TOKEN1$'"</query>
<earliest>1300645800</earliest>
<latest>1332527400</latest>
</search>
<option name="wrap">true</option>
<option name="rowNumbers">false</option>
<option name="dataOverlayMode">none</option>
<option name="drilldown">cell</option>
<option name="count">10</option>
</table>
</panel>
</row>
</form>**
... View more
07-08-2015
01:58 AM
I have checked. I have 2011 mar to 2015 mar data. What ever i selected value 2011or 2012 or 2013 , it showing all 5years data
... View more
07-07-2015
09:56 PM
Hi,
I have 2011 mar to 2015 mar data. I have applied time input filter on Transdate column in my database. In the time input filter, I have selected date range between 2011-03-21 to 2011-03-23. However, I am getting all data for 2011 to 2015. I am not getting correct results regarding selected value (2011-03-21 to 2011-03-23). Please help me. Thanks in advance. The code is as below. Please check it once.
<form>
<label>Fetch date based</label>
<fieldset submitButton="False" autoRun="true">
<input type="time" searchWhenChanged="true" token="tok1">
<label></label>
<default>
<earliest>1300645800</earliest>
<latest>1300905000</latest>
</default>
</input>
<input type="dropdown" token="tok1" id="field2">
<selectFirstChoice>true</selectFirstChoice>
<populatingSearch fieldForValue="TransDate" fieldForLabel="title">
<![CDATA[
| gentimes start=-1 | addinfo | eval title="between '".strftime(TransDate,"%d")."' and '".strftime(TransDate,"%dT")."'"]]>
</populatingSearch>
</input>
<html id="field3">
<style>
.input#field2
{
display:none;
}
</style>
</html>
</fieldset>
<row>
<panel>
<table>
<title>Showing report to period $title$</title>
<search>
<query>| dbquery "CENTRO" "SELECT ShowRoomCode as srcode , TransDate as '_time' , Num_of_Customers as totalcs FROM Centro_Customer_Visit "</query>
<earliest>$tok1.earliest$</earliest>
<latest>$tok1.latest$</latest>
</search>
<option name="charting.chart">bar</option>
<option name="charting.axisLabelsX.majorLabelStyle.overflowMode">ellipsisNone</option>
<option name="charting.axisLabelsX.majorLabelStyle.rotation">0</option>
<option name="charting.axisTitleX.visibility">visible</option>
<option name="charting.axisTitleY.visibility">visible</option>
<option name="charting.axisTitleY2.visibility">visible</option>
<option name="charting.axisX.scale">linear</option>
<option name="charting.axisY.scale">linear</option>
<option name="charting.axisY2.enabled">false</option>
<option name="charting.axisY2.scale">inherit</option>
<option name="charting.chart.bubbleMaximumSize">50</option>
<option name="charting.chart.bubbleMinimumSize">10</option>
<option name="charting.chart.bubbleSizeBy">area</option>
<option name="charting.chart.nullValueMode">gaps</option>
<option name="charting.chart.sliceCollapsingThreshold">0.01</option>
<option name="charting.chart.stackMode">default</option>
<option name="charting.chart.style">shiny</option>
<option name="charting.drilldown">all</option>
<option name="charting.layout.splitSeries">0</option>
<option name="charting.legend.labelStyle.overflowMode">ellipsisMiddle</option>
<option name="charting.legend.placement">right</option>
<option name="wrap">true</option>
<option name="rowNumbers">false</option>
<option name="dataOverlayMode">none</option>
<option name="drilldown">cell</option>
<option name="count">10</option>
</table>
</panel>
</row>
</form>
**
... View more
07-07-2015
01:41 AM
Hi,
I have connected to Splunk database. I have applied "dropdown input" filter on "Transdate column". When I click on "2011-03-22", it is showing "2011-03-22" data. Filter is working fine. Token name as "field1" & query is as below.
| dbquery "srdb" "SELECT TransDate as '_time', ShowRoomCode as srcode , Num_of_Customers as totalcs FROM Centro_Customer_Visit where Centro_Customer_Visit.TransDate
='$field1$'"
But I want to apply time range picker on "TransDate" column dynamically. I have tried, but I didn't get the date range.
I have data from 2011 to 2015. I want to fetch data from March 2011 to April 2011 using time range picker. Is it possible? How it will work? Please help me and send any documentation on this.......
Thanks in advance,
A.kavya.
... View more
06-30-2015
06:44 AM
Before click on host "SP", I want to put default host "SP" ..........
did you try for default value based on click value?
... View more
06-29-2015
12:27 AM
Hi,
I want to create a treemap in a Splunk dashboard with xml code. Please send tree map documentation with examples. Please help me.
... View more
06-24-2015
05:11 AM
1 Karma
Yes. Thank you verymuch. I have already got it. I have tried like that same process
... View more
06-24-2015
12:03 AM
Hi,
I'm using Splunk 6.2.3 and DB Connect 1. I have connected to an Oracle database. I have applied an input drilldown on a chart, but it is showing "error in dbquery command". this command must be in first search" . Please help me and share any document for this.
Thanks in advance,
A.kavya.
... View more
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
06-05-2020
02:03 AM
|
Karma given to
