test zabbix oracle query

Generate timestamps:
date +%s -d "7 DAY AGO"
Zabbix 4.0:
sqlplus64 'zabbix40user/zabbix@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.133.112.87)(PORT=49161)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=xe)))'

No comments: