SQL queries for zabbix

[pantera]

I need sql queries for:

1. add hosts
2. add value mappings
3. delete history/trends/..
4. other you recommend

[kloczek]

I need sql queries for:

1. add hosts
2. add value mappings
3. delete history/trends/..
4. other you recommend

If you are thinking that you need this you are 100% right ... you are only thinking that you need this.
Please try start again from problem which caused that you concluded that you need above.

[richlv]

please consider api :

https://www.zabbix.com/documentation/3.0/manual/api

your second point is not possible in api, though - se https://www.zabbix.org/wiki/Zabbix_T...cial_Templates for examples on adding value maps