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 Vijaikanth
Vijaikanth
Path Finder
Member since:
03-31-2015
06-05-2020
Community Statistics
| Posts | 16 |
| Solutions | 3 |
| Karma Given | 0 |
| Karma Received | 2 |
| Member Since | 03-31-2015 |
Activity Feed
- Got Karma for Re: How to sort Pivot "month-year" columns in ascending chronological order (ex: Nov-2014, Dec-2014, Jan-2015, etc)?. 06-05-2020 12:47 AM
- Got Karma for Re: How to sort Pivot "month-year" columns in ascending chronological order (ex: Nov-2014, Dec-2014, Jan-2015, etc)?. 06-05-2020 12:47 AM
- Posted Alternate ways of accessing Settings >> Data Inputs page on Getting Data In. 08-08-2016 10:45 PM
- Tagged Alternate ways of accessing Settings >> Data Inputs page on Getting Data In. 08-08-2016 10:45 PM
- Tagged Alternate ways of accessing Settings >> Data Inputs page on Getting Data In. 08-08-2016 10:45 PM
- Tagged Alternate ways of accessing Settings >> Data Inputs page on Getting Data In. 08-08-2016 10:45 PM
- Posted Re: 500 Internal Server Error after upgrading to 6.4.0 on Installation. 08-04-2016 01:00 AM
- Posted Re: 500 Internal Server Error after upgrading to 6.4.0 on Installation. 08-03-2016 11:37 PM
- Posted Re: Database Inputs - Importing Data from SQL to Splunk problem on All Apps and Add-ons. 06-24-2016 07:03 AM
- Posted Re: Database Inputs - Importing Data from SQL to Splunk problem on All Apps and Add-ons. 06-23-2016 08:49 AM
- Posted Database Inputs - Importing Data from SQL to Splunk problem on All Apps and Add-ons. 06-23-2016 08:46 AM
- Tagged Database Inputs - Importing Data from SQL to Splunk problem on All Apps and Add-ons. 06-23-2016 08:46 AM
- Tagged Database Inputs - Importing Data from SQL to Splunk problem on All Apps and Add-ons. 06-23-2016 08:46 AM
- Tagged Database Inputs - Importing Data from SQL to Splunk problem on All Apps and Add-ons. 06-23-2016 08:46 AM
- Tagged Database Inputs - Importing Data from SQL to Splunk problem on All Apps and Add-ons. 06-23-2016 08:46 AM
- Posted Re: How to display a details/information of the report in a scroll or text area before each report in a dashboard? on Dashboards & Visualizations. 06-17-2016 05:21 AM
- Posted Re: How can I access app's static content via Splunk endpoint? on Getting Data In. 06-17-2016 04:35 AM
- Posted Re: How to display a details/information of the report in a scroll or text area before each report in a dashboard? on Dashboards & Visualizations. 06-08-2016 03:53 AM
- Posted How to display a details/information of the report in a scroll or text area before each report in a dashboard? on Dashboards & Visualizations. 06-08-2016 03:32 AM
- Tagged How to display a details/information of the report in a scroll or text area before each report in a dashboard? on Dashboards & Visualizations. 06-08-2016 03:32 AM
Topics I've Started
| Subject | Karma | Author | Latest Post |
|---|---|---|---|
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 |
08-08-2016
10:45 PM
Data Inputs page throwing 500 internal server error in Splunk version 6.4.2 (Free license). What are the other alternate ways to access this Data inputs scheduled task, say
I want to change the sql query that populates the data into index or changing the cron expression or disabling a data input task or adding a new data input sql task
In which folder this information/settings/configuration will be present? If i directly modify the file that contains this data input configuration and restart the service will it work?
... View more
08-04-2016
01:00 AM
Thanks. But this problem also happens in 6.4.2 where the only page affected is Database Inputs (Using Free license)
... View more
08-03-2016
11:37 PM
Hi,
In which file we need to put the below code
echo $http{,s}_proxy
unset http{,s}_proxy'
or where we need to execute this code?
... View more
06-24-2016
07:03 AM
In my case, Splunk Split one event into multiple events because of the following parameter in props.conf
LINE_BREAKER = (\r\n)
So i removed the "\r\n" combination in the sql column by executing the below query in SQL table
/** Remove Carriage return and Line Feed **/
UPDATE ProblemTable
SET ProblemColumn = REPLACE(ProblemColumn, char(13), ' ' )
UPDATE ProblemTable
SET ProblemColumn = REPLACE(ProblemColumn, char(10), ' ' )
After corrected the SQL server column values, Splunk not created any multi level events and data loaded correctly.
... View more
06-23-2016
08:49 AM
Sample SQL Query Failing :
select * from xx s inner join xy d on s.id = d.id where s.code = 'Y' and s.desc = 'N' and s.total = 2 order by d.date desc
... View more
06-23-2016
08:46 AM
I have three columns in my SQL table "tblAudit"
Id SQL query ExecutedTime
1 select * from xxx where x= y Jan 1, 2016
2 Insert table xxx (select ....) Jan 30, 2016
3 Delete table.. Create trigger Jan 31, 2016
Now i need to input these details to splunk. Now Database Inputs >> Dump >> Specify SQL query >> Select * from tblAudit >> Save
Instead of 3 events there are 10 events displaying in Splunk and the problem is due to the column "SQL Query". It split the events somehow not sure if it is due to sql keywords and make it as 10 events. If the column "SQL Query" was not included in dump, it return exact 3 events. What is the problem here?
Tat column "SQL Query" is nVarchar(4000) in sql server.
... View more
06-17-2016
05:21 AM
Toggle functionality will be used to hide/show the section and i implemented in advanced XML by following the below link
http://blogs.splunk.com/2013/10/21/toggle-visibility-of-dashboard-components-with-jquery/
... View more
06-17-2016
04:35 AM
Correct. The above solution works fine. But if i create a folder inside appserver/static and place the css file inside, then how i will refer that in my dashboard.
eg) appserver/static/folder1/folder2/YourFancy.css
In Dashboard it should be like
form stylesheet="folder1/folder2/YourFancy.css"...
For me it is not working. Kindly suggest how to access a file if place inside a folder..
... View more
06-08-2016
03:53 AM
Yes we can use to put text. But we have to edit source and include the tag right.
Is that a way that you can add the content from front end or enter the details and click on submit it will save automatically.
Main thing is for small change also we need to edit the source and include the changes. is there a way to avoid this?
... View more
06-08-2016
03:32 AM
I created a dashboard report and now I need to give some details about the dashboard report (some 5 or 6 lines of text) like an interpretation to the user to know why and what purpose the report is used for. Now the requirement is:
One way of creating this Static text panel is to include tag in the xml. But for doing this, we need to edit source and change the text, right? Is there something like we enter the static text and click on submit it will save and shown in that panel?
Is there any Slider control available, because if the text lines go beyond 100 lines, it will occupy more space right? How we can show a static text if it has many lines?
... View more
07-16-2015
12:32 AM
2 Karma
Finally Solved the chronological order in the Format
Month = strftime(strptime(Date,"%d/%m/%Y"),"%Y-%m (%b)")
so the Result will be 2015-01 (Jan), 2015-02 (Feb).....
It Works fine for all year, all month...
... View more
06-23-2015
05:56 AM
Thanks Srinath. In case if the date is "July 1, 2015" then according to the above answer
earliest = -11mon ==> earliest = "Aug 1, 2014" .
so it will return 11 months right.. or it will return from "July 1, 2014" to "July 1, 2015" ?
... View more
06-23-2015
05:42 AM
Requirement is i need to fetch a Report for the last 12 months.
If today's date is Jun 23, 2015 10:12:20 AM then my
Latest Event = NOW,
Earliest Event = July 1, 2014 00:00:00 AM
What will be the expression i need to use to get that Earliest event?
If i specify "-y" or "-1y@month" it will give June 1, 2014 as Earliest event so usually i get 13 months in the result set (Starting from June 2014 to June 2015 - count 13 months) but any time if the report runs it should give 12 months data in column
... View more
05-31-2015
09:44 AM
Yes. If we set the Month as "04-2015" instead of "Apr-2015" we can able to sort it. But after that how to rename the value
"04-2015" to "Apr-2015".
Is it possible to apply wildcard characters in the column names? like Rename 04* as Apr (or) doing some substring on the Column name and rename ?
... View more
05-29-2015
12:44 AM
Here Month = strftime(strptime(Date,"%d/%m/%Y"),"%b-%Y")
so Month = "Apr-2015"
When i set Month = strftime(strptime(Date,"%d/%m/%Y"),"%m-%Y")
so Month = "04-2015" and it will sort the columns properly but again i need to rename the "04-2015" to "Apr-2015" like that for all dynamic columns for the month
... View more
05-29-2015
12:12 AM
Requirement: We need the order of Month column names to start with the three letter month followed by year in ascending order.
Request Name Nov-2014 Dec-2014 Jan-2015 Feb-2015 Mar-2015
Get 50 10 20 20 40
Post 15 5 45 23 34
However, while doing the Pivot, the columns are getting sorted by the string value in alphabetical order and the output is:
Request Name Dec-2014 Feb-2015 Jan-2015 Mar-2015 Nov-2014
Get 10 20 20 40 50
Post 5 23 45 34 15
How do i rearrange the columns to point in ascending order.
... View more
