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!

Federated Search for Amazon S3 | Key Use Cases to Streamline Compliance Workflows

Modern business operations are supported by data compliance. As regulations evolve, organizations must ...

New Dates, New City: Save the Date for .conf25!

Wake up, babe! New .conf25 dates AND location just dropped!! That's right, this year, .conf25 is taking place ...

Introduction to Splunk Observability Cloud - Building a Resilient Hybrid Cloud

Introduction to Splunk Observability Cloud - Building a Resilient Hybrid Cloud  In today’s fast-paced digital ...