Email Notification for Low Disk Space (server)
I created a notification in SMA to email the IT team whenever servers reach 90%+ used space. But the email that is sent from Reporting > Notifications isn't the most useful. All it includes is System Description, MAC Address and IP Address.
I don't know SQL, although I can usually fiddle my way to getting some things I want, but this one is outside my wheelhouse. Any help would be appreciated.
I'd like to include the drives in the system that has low disk space, not just the C: drive.SELECT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, MACHINE.IP, MACHINE.MAC, MACHINE.ID as TOPIC_ID FROM MACHINE LEFT JOIN MACHINE_DISKS ON (MACHINE_DISKS.ID = MACHINE.ID) WHERE ((MACHINE_DISKS.PERCENT_USED > '90') AND (OS_NAME like '%Server%')) GROUP BY MACHINE.ID
When the email comes in, it gives a table Computer Name, System Description, MAC Address, IP Address.
I don't really need description, MAC, or IP. What I'd rather have is a table that includes:
Name, Drive, Space Left in GB.