Can someone help me calculate the health score for a service in ITSI for three months?
It would be something like the picture below:
Something like this?
index=itsi_summary host= sourcetype=stash itsi_service_id== search_name=service_health_monitor itsi_kpi_id="SHKPI-" | timechart span=1mon avg(alert_value) AS AverageHealthScore | transpose header_field=_time
The health score calculation is based on the current severity level of service KPIs (Critical, High, Medium, Low, and Normal) and the weighted average of the importance values of all KPIs in a service.
Not sure what you mean by "for the past three months". But here are the docs on how service health scores are calculated in ITSI: https://docs.splunk.com/Documentation/ITSI/latest/Configure/HealthScores