You'd be better to start a new thread and ask the community for help in that manner. Also, look at the Cisco IOS and ASA TA's that have all the extractions in place. You most likely can find the solution there.
... View more
thanks rich, for your brief explanation.
i got the result with the below search query
index=casm_prod sourcetype=smtrace "Center realm" | bucket _time span=1m |stats count(sso_id) as eventcount by _time, sso_id
thanks alot
... View more
It's more reliable to write $footoken|s$ than "$footoken$", as the former will deal with backslashes and quotes in the token value correctly.
... View more
Finally figured this out. Was filling out a support ticket on this "issue" and one of the answers they linked to was http://answers.splunk.com/answers/23321/field-regex-behaves-differently-for-field-extractions-and-for-rex.html. Apparently you need to add "(?m-s)" to keep "." from matching across newlines when using a regex in a transform. I just wish there was better documentation about the different behavior of regex's in different contexts within Splunk.
The following transform now works great for me:
[mv_localadmin]
REGEX = (?m-s)(.*\n|.*$)
FORMAT = LocalAdmin::$1
REPEAT_MATCH = true
MV_ADD = true
... View more
HI all,
thanks for your answers. For me the main problem was that all values was created in the field "value". It worked much better for me to extract the fieldnames using the <_KEY_1><_VAL_1> Fields. This fields extract the names of the values "dynamic" so i get fields with e.g. running=3 sleeping=105 ...
so creating a timechart is quite easy when using search | timechart avg(running) as running avg(sleeping) as sleeping
Thx and best regards,
Andreas
... View more
Hi @ppablo_splunk , I have checked the link. The drivers are for MySQL, Oracle, DB2 and Informix. My database is Microsoft SQL server. Is that require any driver ? If yes, which one should I download ? Please suggest.
... View more
add select command after update like "select Data1, Data2, Status from test_table1, test_table2 where Status='Closed' and Data2='test2' and Data1='test1' "
... View more
this search string doing the work for the following data
sample data:
partner cost
World T Plus 19000
Prix Mono 47500
Prix Mono 19000
Prix Mono 19000
World T Plus 19000
Prix Mono 19000
Prix Mono 38000
Prix Mono 19000
search string:
source="C:\tachiFlashDisc\test_firstAnswers.csv" |sort partner|table partner cost | dedup cost
result:
partner cost
Africa Telecom 9500
Africa Telecom 19000
Africa Telecom 47500
Africa Telecom 28500
B and C 0
B and C 4750
B and C 33250
B and C 14250
... View more
The field name for the tests need to by dynamic. A simple rename doesn't work, unless I can use the value of the field name. Splunk has confirmed that as of version 6.2 this cannot be done at search time.
... View more
take a look at this: http://answers.splunk.com/answers/129424/how-to-compare-fields-over-multiple-sourcetypes-without-join-append-or-use-of-subsearches.html to get an idea how to get this done a different way .... because join should be a last resort .... not the first option to use
... View more