In sensu we are getting around 100 alerts in a day but only in mail box how can i get the historical data of these alerts like alerts report in one csv file
Sensu only keeps a fixed history (I believe it’s 20 check results, regardless of interval). If you’re using sensu go, look at their metric shipping https://docs.sensu.io/sensu-go/5.5/guides/extract-metrics-with-checks/#what-are-sensu-checks . This will send your metrics to an external system so you can retain those results as long as you need.