host=cmhlpecomecm* EOMReservationService AND (started OR ended) | eval tmp=split(_raw,” “) | eval thread=mvindex(tmp,5) | transaction thread startswith=”started” endswith=”ended” | timechart span=1h avg(duration) median(duration) The query above results in the following output on the Events tab of the UI… …and the…
C# – Write file on client and read same file from inside the database
We had a job that an enterprise software vendor was running that failed on permissions denied. They asked us to open the file share to anyone without a password. Our awesome SQL Server DBA pushed back, thankfully. We came up…
Formatting netstat output
We had a need to ingest open sockets into Splunk so we could map our integration points across the enterprise. We came up with what is below. This will show if the host on which it is run is a…
JMeter AJAX example
I couldn’t find any complete AJAX examples. Most of them, including the one on blazemeter.com that provided the impetus for this post, don’t go far enough to include the cookies needed for the requests to work in most web application…
Powershell – Getting tables from a SQL Server database
c:\Users\adm-showard>powershell Windows PowerShell Copyright (C) 2009 Microsoft Corporation. All rights reserved. PS C:\Users\adm-showard> $sqlConn = New-Object System.Data.SqlClient.SqlConnection PS C:\Users\adm-showard> $sqlConn.ConnectionString = “Server=CMHWPSWSQL1201;Integrated Security=true;Initial Catalog=SWNetPerfMon” PS C:\Users\adm-showard> $sqlConn.Open() PS C:\Users\adm-showard> $sqlcmd = $sqlConn.CreateCommand() PS C:\Users\adm-showard> $sqlcmd = New-Object System.Data.SqlClient.SqlCommand PS C:\Users\adm-showard>…
nginx – passing request headers to upstream server as body
This example does two things: 1) Changes a GET request from the client to a POST 2) Captures the request headers from the client and converts them to a body for POST to the upstream server Note we have underscores…