mysql> mysql> use zabbixdb; Database changed mysql> select t.taskid,t.type,t.clock,t.ttl,c.command_type,c.execute_on,c.port,c.authtype,c.username,c.password,c.publickey,c.privatekey,c.command,c.alertid,c.parent_taskid,c.hostid from task t left join task_remote_command c on t.taskid=c.taskid where t.status=1 and t.proxy_hostid !=0 order by t.taskid; +---------+------+------------+-----+--------------+------------+------+----------+----------+----------+-----------+------------+-----------------------------------------------------+---------+---------------+--------+ | taskid | type | clock | ttl | command_type | execute_on | port | authtype | username | password | publickey | privatekey | command | alertid | parent_taskid | hostid | +---------+------+------------+-----+--------------+------------+------+----------+----------+----------+-----------+------------+-----------------------------------------------------+---------+---------------+--------+ | 4558088 | 2 | 1506518137 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py Average | 3621884 | 4558088 | 10505 | | 4558093 | 2 | 1506518142 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py Average | 3621887 | 4558093 | 10505 | | 4558109 | 2 | 1506518143 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py Disaster | 3621888 | 4558109 | 10505 | | 4558112 | 2 | 1506518144 | 600 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 4558122 | 2 | 1506518161 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py High | 3621889 | 4558122 | 10505 | | 4558124 | 2 | 1506518161 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py High | 3621892 | 4558124 | 10505 | | 4558172 | 2 | 1506518161 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py Average | 3621890 | 4558172 | 10505 | | 4558200 | 2 | 1506518286 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py High | 3621919 | 4558200 | 10505 | | 4558201 | 2 | 1506518286 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py Disaster | 3621923 | 4558201 | 10505 | | 4558203 | 2 | 1506518286 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py High | 3621933 | 4558203 | 10505 | | 4558241 | 2 | 1506518286 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py Average | 3621936 | 4558241 | 10505 | | 4558242 | 2 | 1506518286 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py High | 3621940 | 4558242 | 10505 | | 4558243 | 2 | 1506518286 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py Disaster | 3621932 | 4558243 | 10505 | | 4558247 | 2 | 1506518287 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py Disaster | 3621952 | 4558247 | 10505 | | 4558250 | 2 | 1506518287 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py High | 3621949 | 4558250 | 10505 | | 4558302 | 2 | 1506518287 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py High | 3621954 | 4558302 | 10505 | | 4558448 | 2 | 1506518289 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py Average | 3621955 | 4558448 | 10505 | | 4558492 | 2 | 1506518332 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py Average | 3621956 | 4558492 | 10505 | | 4558495 | 2 | 1506518332 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py High | 3621957 | 4558495 | 10505 | | 4558496 | 2 | 1506518332 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py High | 3621958 | 4558496 | 10505 | | 4558497 | 2 | 1506518332 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py Disaster | 3621959 | 4558497 | 10505 | | 4558499 | 2 | 1506518332 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py High | 3621961 | 4558499 | 10505 | | 4558500 | 2 | 1506518332 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py Disaster | 3621960 | 4558500 | 10505 | | 4558502 | 2 | 1506518332 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py High | 3621963 | 4558502 | 10505 | | 4558505 | 2 | 1506518332 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py Disaster | 3621962 | 4558505 | 10505 | | 4558617 | 2 | 1506518332 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py Disaster | 3621964 | 4558617 | 10505 | | 4558621 | 2 | 1506518332 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py High | 3621965 | 4558621 | 10505 | | 4558805 | 2 | 1506518334 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py High | 3621993 | 4558805 | 10505 | | 4558806 | 2 | 1506518334 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py High | 3621991 | 4558806 | 10505 | | 4558812 | 2 | 1506518332 | 600 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 4558817 | 2 | 1506518391 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py High | 3621996 | 4558817 | 10505 | | 4558819 | 2 | 1506518391 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py Average | 3621995 | 4558819 | 10505 | | 4558820 | 2 | 1506518391 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py High | 3621994 | 4558820 | 10505 | | 4558821 | 2 | 1506518391 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py Disaster | 3621997 | 4558821 | 10505 | | 4558824 | 2 | 1506518391 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py Disaster | 3621998 | 4558824 | 10505 | | 4558841 | 2 | 1506518392 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py Disaster | 3622005 | 4558841 | 10505 | | 4558942 | 2 | 1506518392 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py High | 3621999 | 4558942 | 10505 | | 4559001 | 2 | 1506518396 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py High | 3622028 | 4559001 | 10505 | | 4559331 | 2 | 1506518397 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py Disaster | 3622029 | 4559331 | 10505 | | 4559428 | 2 | 1506518392 | 600 | 0 | 0 | 0 | 0 | | | | | python.exe C:\Sources\zabbixsoundplayer.py Disaster | 3622001 | 4559428 | 10505 | +---------+------+------------+-----+--------------+------------+------+----------+----------+----------+-----------+------------+-----------------------------------------------------+---------+---------------+--------+ 40 rows in set (0.00 sec)