About paulito123

paulito123 · ‎07-16-2020

Hello Experts. I'm trying to backup our kvstores with the well documented backup command in a windows batch file. I tried using CALL as well as START. CALL doesn't do anything. START will initiate another splunk cmd window but it closes after some seconds without any result. Is there a way to catch error from the Splunk cmd window? Here is what I tried, with a lot of combinations. set AppName=my_app set ArchiveName=What_ever cd %CorrectFolder% > verified by running echo %cd% CALL splunk.exe backup kvstore -archiveName %ArchiveName% -appName %AppName% START "title" "splunk.exe" backup kvstore -archiveName %ArchiveName% -appName %AppName% Thanks in advance Paul

paulito123 · ‎05-29-2020

Removing the whole thing and starting from scratch fixed this issue...

paulito123 · ‎05-29-2020

Hey experts! I'm relatively new to Splunk, so if this is a stupid question, mea culpa. That being said, I have a solid SQL background and I'm in need of a solution for this seemingly easy problem. I have indexed data and I would like to link it to a lookup. The purpose of this lookup is both to limit the final output, as well as enrich the final output with some extra fields. The key for linking the lookup with the indexed data, consists of multiple fields. I was thinking about something like this: index=ringelingdong sourcetype=ring | eval testfield=strftime(_time,'%Y%m%d%T')."#".some_id | where testfield=[| inputlookup lookup_csv.csv | eval LKPFIELD=strftime(_time,'%Y%m%d%T')."#".my_lkp_id | where checked!=0 | fields checked, changerequest | rename checked as ck, changerequest as CR] | table _time some_id ck CR This is what I came up with so far, but I'm still missing: how to link the lookup output with the indexed data on multiple keys how to have the lookup restrict the final output, so that only checked!=1 is shown how to add both checked and changerequest fields from the lookup in the result Many thanks in advance Paul

paulito123 · ‎02-10-2020

Hello experts I have a DB Connect connection to my DB that validates. The query that I send to the DB is displayed here: WITH "dte" as (SELECT * FROM "T_AUDIT_LOG_HISTORY" UNION SELECT * FROM "T_AUDIT_LOG" ) select * from "dte" where "UN_ID" > ? ORDER BY "UN_ID" ASC I use a rising value on column 10 ("UN_ID") which is a integer unique identifier that increases for every new record. This table is not updated. Only inserts arrive. The first column has a timestamp that I link to the _time internal field. What I would expect is that every unique id is imported just once, but this is not the case. Every 15 minutes it imports a full copy of the whole table... Here is my config file for this connector: [AUDIT_LOG_HIST] connection = Production disabled = 0 host = XXX_PROD index = xxx index_time_mode = dbColumn input_timestamp_column_number = 1 interval = */15 * * * * mode = rising query = WITH "dte" as (SELECT * \ FROM "T_AUDIT_LOG_HISTORY"\ UNION\ SELECT * \ FROM "T_AUDIT_LOG"\ )\ select *\ from "dte"\ where "UN_ID" > ?\ ORDER BY "UN_ID" ASC query_timeout = 60 sourcetype = audit:log tail_rising_column_number = 10 I would only need the new ids so I don't see any doubles in my index. Thanks in advance P

paulito123 · ‎02-04-2020

Yep thanks, it does the trick.

Posts	5
Solutions	1
Karma Given	1
Karma Received	0
Member Since	‎02-04-2020

Online Status	Offline
Date Last Visited	‎07-17-2020 05:15 AM

Is there a way to catch error from the Splunk cmd ...

How to inner join indexed data with lookup data on...

Rising column not working as expected

Is there a way to catch error from the Splunk cmd ...

Re: Rising column not working as expected

How to inner join indexed data with lookup data on...

Rising column not working as expected

Re: Search formatting in Splunk 6.5.0 for easier r...