Collection of CLI tool for various usages:
- massive host insert
- massive hostgroup moving
- massive host details and properties modification
- data extraction: inventory query, current problems
- hosts query
- item data extraction (history and trend)
- misc automation stuff
- json parsing/LLD/item prototyping
Caution : sample scripts are mostly without error checking and they assume that you know what you are doing!
- python 2.7 / 3
- py-zabbix
- requests
All scripts will share the base command line with ENV variables support, like
# export ZABBIX_SERVER='https://your_zabbix_host/zabbix/'
# export ZABBIX_PASSWORD='admin'
# export ZABBIX_USERNAME='secretPassword'
Most of them are alreay compliant, other are in progress.
From a single csv file:
- create hostgroups
- create hosts and
- assign the correct interface
- assign them to their correct groups
- link them to the correct templates
- add tags and descriptions
- optional proxy assignment
- user macros
Usage:
# hostBulkInsert.py -Z http://yourserver/zabbix -u admin -p somePass -f "zabbixHosts.csv" -s
# export ZABBIX_SERVER='https://your_zabbix_host/zabbix/'
# export ZABBIX_USERNAME='admin'
# export ZABBIX_PASSWORD='secretPassword'
# ./hostBulkInsert.py -f HOSTS.csv <- stops with error if hits an existing host
# ./hostBulkInsert.py -f HOSTS.csv -s <- check and skips existing hosts
File format
Sample csv file:
Hostname;IP Address;Groups;Tags;Description;SNMP community;Proxy;Templates;Interfaces;Macros
SomeHost;8.8.8.8;Group1,Group2,Routers;TagName=someValue;Device Description;snmpCommnity;ZabbixProxyName;Template Net Cisco IOS SNMPv2;agent-SNMP; {$SOMETHING}=25
SecondHost;8.8.8.8;Group3,Group2,SiteA;FirstTag=value,TagName=anotherValue;Device Description;snmpCommnity;;Template Net Cisco IOS SNMPv2;agent-SNMP;
Fields:
- Full hostgroup path is a ',' delimited list of nested hostgroups (Zabbix syntax: group/subgroup1/subgroup2)
- Templates is a ',' delimited list of existing templates to apply or a
DO_NOT_ADD
string - Interfaces could be agent, snmp or both (
agent,SNMP
) - Tags are separated by ',' in the format
TagName=TagValue,AnotherTagName=TagValue
- Macros are separated by ',' in the format
{$ONEMACRO}=102,{$ANOTHERMACRO}=28
TODO
- proxy existance check and what to do if template does not exists
- template existance check and what to do if template does not exists
- convert to the ENV usage all the scripts
- add documentation
jsonLLD.py: Script for JSON low level discovery, produces JSON for Zabbix LLD according to https://www.zabbix.com/documentation/3.4/manual/discovery/low_level_discovery
Requires a base url and a set of macro:JSONfield to remap original data to Zabbix format
jsonGet.py: Gather data from URL, using a dotted notation
$ jsonLLD.py -i https://jsonplaceholder.typicode.com/users -m "{#ID}:id,{#COMPANY}:company.name,{#NAME}:name,{#MAIL}:email"
{
"data": [
{
"{#COMPANY}": "Romaguera-Crona",
"{#ID}": 1,
"{#MAIL}": "[email protected]",
"{#NAME}": "Leanne Graham"
},
{
"{#COMPANY}": "Deckow-Crist",
"{#ID}": 2,
"{#MAIL}": "[email protected]",
"{#NAME}": "Ervin Howell"
},
[cut]
$ jsonGet.py -i https://jsonplaceholder.typicode.com/users/10 -f name
Clementina DuBuque
$ jsonGet.py -i https://jsonplaceholder.typicode.com/users/10 -f company.name
Hoeger LLC
$ jsonGet.py -i https://jsonplaceholder.typicode.com/users/10 -f address.geo
{
"lat": "-38.2386",
"lng": "57.2232"
}
$ jsonGet.py -i https://jsonplaceholder.typicode.com/users -f 9.company.name
Hoeger LLC
- Create a Discovery rule of "Zabbix agent" type and set it to run
system.run[/usr/bin/jsonLLD.py]
(mind the path!) - create an item prototype for each json field you want to work on (ie: Item name:
{#NAME} company name
, Item keysystem.run[/usr/bin/jsonGet.py -i {#BASEURL}/{#ID} -f company.name]
)