Splunk Search

need to calculate number of request in iis for each month.

nambir
New Member

I need to calculate number of request in iis for each month. I already stored the iis log in splunk.
i need to get the count for last 5 months need to compare.

Tags (1)
0 Karma

MousumiChowdhur
Contributor

Hi @nambir ,

Please use the below query and run the search for last 5 months.

index=<yourindex> | timechart span=1mon count by clientip

Thank You!

0 Karma

nambir
New Member

Hi,
Thanks for the response.
when i tried above query unfortunately it doesnt bring any result.

Query which i used till now:
host="PRODAPP1" sourcetype="iis"

Can you add on/append the query properly so it works for me.?
Whats the Index?

0 Karma

MousumiChowdhur
Contributor

Hi @nambir ,

Please use the below query:

host="PRODAPP1" sourcetype="iis" | timechart span=1mon count by c-ip

where c-ip is the client ip address from where you are getting hits to the web server.

Run the above query for last 5 months.

Thank you.

0 Karma
Get Updates on the Splunk Community!

September Community Champions: A Shoutout to Our Contributors!

As we close the books on another fantastic month, we want to take a moment to celebrate the people who are the ...

Splunk Decoded: Service Maps vs Service Analyzer Tree View vs Flow Maps

It’s Monday morning, and your phone is buzzing with alert escalations – your customer-facing portal is running ...

What’s New in Splunk Observability – September 2025

What's NewWe are excited to announce the latest enhancements to Splunk Observability, designed to help ITOps ...