Disk drives with less than 20 % free space

To query the Performance Store database for disk drives with less than 20 % free space, use:

select c.*
from dbo.v_capacity c
where c.post_time in
(
	select top 1 c1.post_time
	from dbo.capacity c1
	order by c1.post_time desc
)
and c.below_20_pct_full = 1

The alert will be visible on the Latest stats dashboard.

To exclude specific servers from this alert, see how to use the dbo.team_alert_exclude table in Alerting.