- [DEV-140] Heartbeat alerts configuration

   [added support of zabbix[proxy,<proxyname>,lastaccess]]


git-svn-id: svn://svn.zabbix.com/trunk@5594 97f52cf1-0a1b-0410-bd0e-c28be96e8082

1 files changed, 28 insertions, 0 deletions

diff --git a/src/libs/zbxdbhigh/db.c b/src/libs/zbxdbhigh/db.c
index a58662fc..7610cc83 100644
--- a/src/libs/zbxdbhigh/db.c
+++ b/src/libs/zbxdbhigh/db.c
@@ -1536,6 +1536,34 @@ int	DBget_queue_count(void)
 	return res;
 }
 
+zbx_uint64_t DBget_proxy_lastaccess(const char *hostname)
+{
+	zbx_uint64_t	res;
+	DB_RESULT	result;
+	DB_ROW		row;
+
+	zabbix_log(LOG_LEVEL_DEBUG,"In D()");
+
+	result = DBselect("select lastaccess from hosts where host='%s' and status in (%d)",
+			hostname,
+			HOST_STATUS_PROXY);
+
+	if (NULL == (row = DBfetch(result)) || SUCCEED == DBis_null(row[0])) {
+		zabbix_log(LOG_LEVEL_ERR, "Proxy \"%s\" not exists",
+				hostname);
+		zabbix_syslog("Proxy \"%s\" not exists",
+				hostname);
+		DBfree_result(result);
+		return FAIL;
+	}
+
+	res = zbx_atoui64(row[0]);
+
+	DBfree_result(result);
+
+	return res;
+}
+
 int	DBadd_alert(zbx_uint64_t actionid, zbx_uint64_t userid, zbx_uint64_t eventid,  zbx_uint64_t mediatypeid, char *sendto, char *subject, char *message)
 {
 	int	now;