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!

Data Management Digest – December 2025

Welcome to the December edition of Data Management Digest! As we continue our journey of data innovation, the ...

Index This | What is broken 80% of the time by February?

December 2025 Edition   Hayyy Splunk Education Enthusiasts and the Eternally Curious!    We’re back with this ...

Unlock Faster Time-to-Value on Edge and Ingest Processor with New SPL2 Pipeline ...

Hello Splunk Community,   We're thrilled to share an exciting update that will help you manage your data more ...