"How are these transactions linked together... by a field called "ID"? If so.. just build them with the field ID, and then use one of the MV commands to extract a field with success or failure in it. Paste some samples and…"
The dojo of Splunk. Learn, share, teach, mentor.
Videos
Latest Activity
Nikita posted a discussionCount failures and success via transaction
Hi,I'm a new in Splunk so sorry for the stupid questions.I want to calculate failures in logs.For example we have request log and response log."request" OR ("fail" OR "response") |transaction startsWith=("request") endsWith=("fail" OR "response") maxpause=5s keepevicted=false maxspan=25s id |eval Failure=if(searchmatch("fail"),1,0)| eval Success=if(searchmatch("response"),1,0) | stats count(Failure) as FailureCount, count(Success) as SuccessCount | table FailureCount SuccessCountThat query…See More
Catpuring perfmon counters from sql default and named instances
Anyone out there had experience with this challenge?
Some of these counters vary per sql installation and I am wondering if anyone has solved this transformation magic.
E.g. SQL server instance 1 (default instance) has a perfmon counter called : \MSSQL$myservername:Databases(pubs)\Log File(s) Size (KB)
SQL server instance 2
\MSSQL$mynamedinstance:Databases(adventureworks)\Log File(s) Size (KB)
we are currently realing with this via a scripted input which captures the sql performance counters via typeperf. The reults are then assigned a column name via the transformation file.
Wondering if there are any other alternative solutions available?
Views: 110
© 2012 Created by Michael Wilde.
