All Apps and Add-ons

How do I search for tweets containing specific words?

m_vivek
Path Finder

Hi I am new to Splunk and have recently installed the 'App for twitter data' and set it up with my twitter account.
I want to do an analysis of the data obtained

Say i want to search for tweets containing "Game of Thrones" and "GOT" either in the hashtag or anywhere in the tweet, how should I write the search query ?

I tried this

index=twitter | rename entities.hashtags{}.text as hashtags | fields hashtags | mvexpand hashtags | search hashtags=GameOf* OR hashtags= GOT | stats count by hashtags

in Verbose mode , but of a million events only about 109 events were matched.

Can somebody guide me about how I can modify the search , or point me to proper resources?
Thanks

0 Karma

davidfstr
Explorer

You've got the right idea. You're already searching against the hashtag. You just need to search against the tweet text.

  • Use an additional rename to get the tweet text.
  • Have a single search command like (hashtags=GameOf* OR hashtags=GOT OR tweet=GOT).
Get Updates on the Splunk Community!

Introducing the Splunk Community Dashboard Challenge!

Welcome to Splunk Community Dashboard Challenge! This is your chance to showcase your skills in creating ...

Built-in Service Level Objectives Management to Bridge the Gap Between Service & ...

Wednesday, May 29, 2024  |  11AM PST / 2PM ESTRegister now and join us to learn more about how you can ...

Get Your Exclusive Splunk Certified Cybersecurity Defense Engineer Certification at ...

We’re excited to announce a new Splunk certification exam being released at .conf24! If you’re headed to Vegas ...