Splunk Search

transaction too complex?

Yarsa
Path Finder

Hi, I'm trying to create a report that does the same search for two different dates, the regular search uses a transaction:

(sourcetype="bi_log" "join room success")  OR (source="analyticsreport" eventDescription concurrentUsers>0) | transaction eventId | stats  dc(userId) as "Visitors"   count(sessionId) as "Visits" dc(roomId) as "Total rooms"  by eventDescription

For the current report I want to run it for today and 24h X DAYS AGO.
The finale report I will categorize by eventDescription as before but also by "day"

I tried several different times with no success, here is one of them:

(sourcetype="bi_log" "join room success" | append  [search sourcetype="bi_log" "join room success" earliest="-5d@d" latest="-4d@d"] | convert timeformat="%m/%d/%y" ctime(_time) as "new_t") OR (source="analyticsreport" eventDescription concurrentUsers>0  | append  [search source="analyticsreport" eventDescription concurrentUsers>0  earliest="-5d@d" latest="-4d@d"] | convert timeformat="%m/%d/%y" ctime(_time) as "new_t") |  transaction eventId |  stats  dc(userId) as "Visitors"  count(sessionId) as "Visits"  dc(roomId) as "Total rooms" by eventDescription,new_t

I'll appreciate if any of you has suggestions, thanks!!

Tags (2)

lpolo
Motivator

If you provide a log event sample for each source log I will be able to help you.

0 Karma

meishar
New Member

I have the same problem!!
anyone?

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Accelerate Splunk App Development with AI

  Learn how to automate the repetitive parts of your build cycle.   Watch On-Demand   Replay the Accelerate ...

Splunk Agent Observability: Measuring AI Value with Splunk Tokenomics on AWS

The AI landscape is moving faster than ever, and our latest 2026 State of Observability report provides the ...

Enterprise Security Watch Party: What’s New in 8.8 - Recap

Splunk Community HQ hosted a Splunk Enterprise Security Watch Party: What’s New In ES 8.8 last Thursday. I had ...