Hardware maintenance expiry date notification

[stevenfoo]

I would like to know whether zabbix 1.8 will have the Hardware maintenance expiry date notification function available.

I know that we could enter the Date HW maintenance expiry in the host extended profile.

How could we setup that zabbix could trigger an email?
There is no item to capture that expiry date.

I am using zabbix 1.6.4.

Please advice.

[alixen]

Hi,

This this the way I do it:
I have created an item of type 'external script' with key:

localquery.sh["select datediff(str_to_date(date_hw_expiry,'%d/%m/%Y'),curdate()) from hosts_profiles_ext p,hosts h where h.hostid=p.hostid and host = '{HOSTNAME}'"]

localquery.sh just runs the query on zabbix database:

#! /bin/sh
mysql -NBu XXXXX -pYYYYY -e "$2" zabbix

It would be nice if Zabbix could expose inventory data as items.
I have filled a feature request on bug tracker : https://support.zabbix.com/browse/ZBXNEXT-296

Regards,
Alixen
Regards,
Alixen

[stevenfoo]

1. Do I need to replace '{HOSTNAME}' with the actual hostname?

2. Will zabbix able to send a trigger email to alert the server administrator email?

Thanks.