Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
×
Join the Conversation
Without signing in, you're just watching from the sidelines. Sign in or Register to connect, share, and be part of the Splunk Community.
- Find Answers
- :
- About harshavrath
harshavrath
Contributor
Member since:
02-19-2014
06-05-2020
Community Statistics
| Posts | 152 |
| Solutions | 1 |
| Karma Given | 68 |
| Karma Received | 3 |
| Member Since | 02-19-2014 |
Activity Feed
- Karma Re: Database Connection for richgalloway. 06-05-2020 12:46 AM
- Karma Re: Disk Space Error for MuS. 06-05-2020 12:46 AM
- Karma Re: Disk Space Error for MuS. 06-05-2020 12:46 AM
- Karma Re: Disk Space Error for MuS. 06-05-2020 12:46 AM
- Karma Re: Disk Space Error for MuS. 06-05-2020 12:46 AM
- Karma Re: Disk Space Error for MuS. 06-05-2020 12:46 AM
- Karma Re: Disk Space Error for MuS. 06-05-2020 12:46 AM
- Karma Re: Database Connection for kaufmanm. 06-05-2020 12:46 AM
- Karma Re: Database Connection for richgalloway. 06-05-2020 12:46 AM
- Karma Re: Disk Space Error for MuS. 06-05-2020 12:46 AM
- Karma Re: Database Connection for richgalloway. 06-05-2020 12:46 AM
- Karma Re: Getting Data from Database's for richgalloway. 06-05-2020 12:46 AM
- Karma Re: Getting Data from Database's for richgalloway. 06-05-2020 12:46 AM
- Karma Re: Getting Data from Database's for dart. 06-05-2020 12:46 AM
- Karma Re: Getting Data from Database's for Ayn. 06-05-2020 12:46 AM
- Karma Re: Splunk Forwarder,Installation for alacercogitatus. 06-05-2020 12:46 AM
- Karma Re: Installation for MuS. 06-05-2020 12:46 AM
- Karma Re: Splunk Installation for richgalloway. 06-05-2020 12:46 AM
- Karma Re: Disk Space Error for dmaislin_splunk. 06-05-2020 12:46 AM
- Karma Re: Delete/clean all the contents of splunk for chimbudp. 06-05-2020 12:46 AM
Topics I've Started
| Subject | Karma | Author | Latest Post |
|---|---|---|---|
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 |
04-04-2014
06:59 AM
I have attributes with VARCHAR2(4000 BYTE) & CLOB data-type.
... View more
04-04-2014
06:32 AM
If i edit the inputs.conf now will it make any difference or should i delete it & re-index it again.
... View more
04-04-2014
06:30 AM
I have multiple lines in my tables,There are 18 attributes in my table.
... View more
04-04-2014
06:27 AM
If i use DB-Query the data is displayed in the form of tables very clean & crisp,but after indexing its pouring all the data at once without any space.
... View more
04-04-2014
02:58 AM
the records are indexed into Splunk I'm able to Search them but they are not displayed in proper format as they are displayed when DB-Query is used.
... View more
04-04-2014
02:55 AM
the sourcetype is dbmon:kv
... View more
04-03-2014
07:55 AM
Thank you its indexing now,but its displaying in the form of paragraph's the field i selected in the settings page for Output Format = Key-Value Format
... View more
04-03-2014
07:36 AM
okay i will try that now,What is the clone button for.?
... View more
04-03-2014
07:33 AM
This is the Query By means of which I'm trying to index data into SPlunk
SELECT * FROM Table_NM WHERE TRUNC(CREATED_DT) BETWEEN to_date('04-03-2014','mm/dd/yyyy')
AND to_date('04-03-2014','mm/dd/yyyy')AND ROWNUM<=100
{{AND CREATED_DT > ?}}
ORDER BY CREATED_DT ASC
... View more
04-03-2014
07:31 AM
When i tried this query in DB_Query I'm getting results
SELECT * FROM Table_NM WHERE TRUNC(CREATED_DT) BETWEEN to_date('04-03-2014','mm/dd/yyyy') AND to_date('04-03-2014','mm/dd/yyyy') AND ROWNUM <= 100
... View more
04-03-2014
07:29 AM
In DB-Query I'm able to get proper results
... View more
04-03-2014
07:23 AM
I'm getting this Error in the Recent DB Errors
... View more
04-03-2014
07:22 AM
I'm getting an error as
Configuration Error: Invalid query "THE QUERY IS WRITTEN"
without proper {{ ... $rising_column$ > ?}} pattern!
... View more
04-03-2014
06:53 AM
what about the Question_Mark ? should we replace it with any field..?
... View more
04-03-2014
06:52 AM
the rising_column=DATE_FIELD attribute right
... View more
04-03-2014
06:49 AM
no in DB its an Date data-type
... View more
04-03-2014
06:47 AM
will it cause a problem as the date returned is Epoch format when i do a select * from Table_name
... View more
04-03-2014
03:25 AM
But I'm still unable to figure out what is the Select Query that I am supposed to use while Indexing a table into Splunk.
... View more
04-03-2014
03:24 AM
Hi,I'm getting results when i tried the below query
| dbquery DB_NAME limit=100 "SELECT * FROM TABLE_NAME WHERE TRUNC(DATE_FIELD) BETWEEN to_date('04-03 2014','mm/dd/yyyy') AND to_date('04-03 -2014','mm/dd/yyyy') "|fieldformat DATE_FIELD=strftime(DATE_FIELD,"%d-%m-%Y %H: %M: %S")
... View more
04-02-2014
11:38 PM
Hi,I'm getting this error when i tried the above query
command="dbquery", A database error occurred: ORA-01830: date format picture ends before converting entire input string
... View more
04-02-2014
07:31 AM
i tried I'm getting an Error as Invalid Month.
... View more
04-02-2014
07:25 AM
I deleted the previous Entry that i had created.I need the Query that I'm supposed to use.As there are some millions of Records in DB i can't index them all in Splunk becoz of 500MB limit,So i want to index some 1000 rows which fall in a said time frame.
... View more
04-02-2014
07:08 AM
I meant the query to be used for indexing shouldn't we use curly braces for where condition.
... View more
04-02-2014
06:52 AM
If i use dbquery Epoch time is returned i was able to convert it using fieldformat-strftime.
... View more
04-02-2014
06:50 AM
what I'm i supposed to include in a query if i want to index 1000 rows in a specified time range say Jan 14 to Mar 14.
... View more
