IntelliTrend Zabbix CSV Host Importer
This is a Zabbix frontend module that provides a simplified host import via CSV files.
License
This software is licensed under the GNU Lesser General Public License v3.0.
Download
You can find the latest versions for the respective Zabbix releases on the Github releases page.
Requirements
- Zabbix 6.0, 6.2, 6.4 or 7.0
- File write access to the Zabbix frontend server
- Super admin permissions for the Zabbix users that want to use the frontend module
Installation
For Debian and Ubuntu server, the Zabbix Frontend modules are usually placed in /usr/share/zabbix/modules/.
Copy the folder modules/csv-host-importer to /usr/share/zabbix/modules/csv-host-importer on the Zabbix frontend web server.
Note: If you're using Zabbix 6.2 or 6.0, you'll need to remove manifest.json and rename manifest.v1.json to manifest.json.
Then go to Administration, General, Modules, click Scan directory and enable the new module in the list.
Usage
Once the frontend module is activated, a new menu entry Host CSV Importer should appear under Configuration (6.0, 6.2) or Data collection (6.4+).
Here's an example of two hosts: the first one with Zabbix agent and another with an SNMPv2 agent:
NAME;VISIBLE_NAME;HOST_GROUPS;TEMPLATES;AGENT_IP;AGENT_DNS;SNMP_IP;SNMP_DNS;SNMP_VERSION;DESCRIPTION
example1;Example Host Agent;First host group, second host group;Linux by Zabbix agent;127.0.0.1;localhost;;;;Example Zabbix Agent host
example2;Example Host SNMP;Third host group;Generic by SNMP;;;127.0.0.1;localhost;2;Example SNMPv2 hostYou can find more specific examples in the examples directory.
The following CSV columns are supported:
| Name | Purpose | Default |
|---|---|---|
| NAME | Host name. (required) | |
| VISIBLE_NAME | Host visible name. | |
| HOST_GROUPS | List of host group names, separated by a '|'. Missing host groups are created automatically. (required) | |
| HOST_TAGS | List of host tags, separated by a '|'. The tag format can be either be tag name (empty value) or tag name=tag value. |
|
| HOST_MACROS | List of host macros, separated by a '|'. The macro format can be either be {$MACRONAME} (empty value) or {$MACRONAME}=macro value. |
|
| PROXY | Name of the proxy that should monitor the host. | |
| PROXY_GROUP | Name of the proxy group assigned to the host. (Zabbix 7+) | |
| PROXY_GROUP | Name of the proxy group that should monitor the host. (from Zabbix 7.0) | |
| STATUS | Host enable status 0 - (default) monitored host 1 - unmonitored host. | 0 |
| TEMPLATES | List of template names to assign to the host, separated by a '|'. Templates must exist with the specified name. | |
| AGENT_IP | Interface: Zabbix Agent IP address. | |
| AGENT_DNS | Interface: Zabbix Agent DNS name. | |
| AGENT_PORT | Interface: Zabbix Agent port. | 10050 |
| SNMP_IP | Interface: SNMP IP address. | |
| SNMP_DNS | Interface: SNMP DNS name. | |
| SNMP_PORT | Interface: SNMP port. | 161 |
| SNMP_VERSION | Interface: SNMP version number (1, 2 or 3). | |
| SNMP_COMMUNITY | Interface: SNMP community string. | {$SNMP_COMMUNITY} |
| SNMP_MAXREP | Interface: SNMP max repitition count. | 10 |
| SNMP_V3SECNAME | Interface: SNMPv3 security name. | |
| SNMP_V3SECLEVEL | Interface: SNMPv3 security level. | |
| SNMP_V3AUTHPASSPHRASE | Interface: SNMPv3 auth passphrase. | |
| SNMP_BULK | Interface: SNMP Whether to use bulk SNMP requests. 0 - don't use bulk requests, 1 - use | 1 |
| SNMP_V3PRIVPASSPHRASE | Interface: SNMPv3 priv passphrase. | |
| SNMP_V3AUTHPROTOCOL | Interface: SNMPv3 auth protocol. | |
| SNMP_MAXREP | Interface: SNMP max repetitions. | 10 |
| SNMP_V3SECNAME | Interface: SNMPv3 security name. | |
| SNMP_V3SECLEVEL | Interface: SNMPv3 security level. | |
| SNMP_V3AUTHPASSPHRASE | Interface: SNMPv3 authentication passphrase | |
| SNMP_V3PRIVPASSPHRASE | Interface: SNMPv3 privacy passphrase | |
| SNMP_V3AUTHPROTOCOL | Interface: SNMPv3 authentication protocol | |
| SNMP_V3PRIVPROTOCOL | Interface: SNMPv3 privacy protocol | |
| SNMP_V3CONTEXTNAME | Interface: SNMPv3 context name | |
| SNMP_V3PRIVPROTOCOL | Interface: SNMPv3 priv protocol. | |
| SNMP_V3CONTEXTNAME | Interface: SNMPv3 context name. | |
| JMX_IP | Interface: JMX IP address. | |
| JMX_DNS | Interface: JMX DNS name. | |
| JMX_PORT | Interface: JMX port. | 12345 |
| DESCRIPTION | Host description field. | |
| INV_ALIAS | Inventory: Alias | |
| INV_ASSET_TAG | Inventory: Asset tag | |
| INV_CHASSIS | Inventory: Chassis | |
| INV_CONTACT | Inventory: Contact person | |
| INV_CONTRACT_NUMBER | Inventory: Contract number | |
| INV_DATE_HW_DECOMM | Inventory: HW decommissioning date | |
| INV_DATE_HW_EXPIRY | Inventory: HW maintenance expiry date | |
| INV_DATE_HW_INSTALL | Inventory: HW installation date | |
| INV_DATE_HW_PURCHASE | Inventory: HW purchase date | |
| INV_DEPLOYMENT_STATUS | Inventory: Deployment status | |
| INV_HARDWARE | Inventory: Hardware | |
| INV_HARDWARE_FULL | Inventory: Detailed hardware | |
| INV_HOST_NETMASK | Inventory: Host subnet mask | |
| INV_HOST_NETWORKS | Inventory: Host networks | |
| INV_HOST_ROUTER | Inventory: Host router | |
| INV_HW_ARCH | Inventory: HW architecture | |
| INV_INSTALLER_NAME | Inventory: Installer name | |
| INV_LOCATION | Inventory: Location | |
| INV_LOCATION_LAT | Inventory: Location latitude | |
| INV_LOCATION_LON | Inventory: Location longitude | |
| INV_MACADDRESS_A | Inventory: MAC address A | |
| INV_MACADDRESS_B | Inventory: MAC address B | |
| INV_MODEL | Inventory: Model | |
| INV_NAME | Inventory: Name | |
| INV_NOTES | Inventory: Notes | |
| INV_OOB_IP | Inventory: OOB IP address | |
| INV_OOB_NETMASK | Inventory: OOB host subnet mask | |
| INV_OOB_ROUTER | Inventory: OOB router | |
| INV_OS | Inventory: OS name | |
| INV_OS_FULL | Inventory: Detailed OS name | |
| INV_OS_SHORT | Inventory: Short OS name | |
| INV_POC_1_CELL | Inventory: Primary POC mobile number | |
| INV_POC_1_EMAIL | Inventory: Primary email | |
| INV_POC_1_NAME | Inventory: Primary POC name | |
| INV_POC_1_NOTES | Inventory: Primary POC notes | |
| INV_POC_1_PHONE_A | Inventory: Primary POC phone A | |
| INV_POC_1_PHONE_B | Inventory: Primary POC phone B | |
| INV_POC_1_SCREEN | Inventory: Primary POC screen name | |
| INV_POC_2_CELL | Inventory: Secondary POC mobile number | |
| INV_POC_2_EMAIL | Inventory: Secondary POC email | |
| INV_POC_2_NAME | Inventory: Secondary POC name | |
| INV_POC_2_NOTES | Inventory: Secondary POC notes | |
| INV_POC_2_PHONE_A | Inventory: Secondary POC phone A | |
| INV_POC_2_PHONE_B | Inventory: Secondary POC phone B | |
| INV_POC_2_SCREEN | Inventory: Secondary POC screen name | |
| INV_SERIALNO_A | Inventory: Serial number A | |
| INV_SERIALNO_B | Inventory: Serial number B | |
| INV_SITE_ADDRESS_A | Inventory: Site address A | |
| INV_SITE_ADDRESS_B | Inventory: Site address B | |
| INV_SITE_ADDRESS_C | Inventory: Site address C | |
| INV_SITE_CITY | Inventory: Site city | |
| INV_SITE_COUNTRY | Inventory: Site country | |
| INV_SITE_NOTES | Inventory: Site notes | |
| INV_SITE_RACK | Inventory: Site rack location | |
| INV_SITE_STATE | Inventory: Site state | |
| INV_SITE_ZIP | Inventory: Site ZIP/postal code | |
| INV_SOFTWARE | Inventory: Software | |
| INV_SOFTWARE_APP_A | Inventory: Software application A | |
| INV_SOFTWARE_APP_B | Inventory: Software application B | |
| INV_SOFTWARE_APP_C | Inventory: Software application C | |
| INV_SOFTWARE_APP_D | Inventory: Software application D | |
| INV_SOFTWARE_APP_E | Inventory: Software application E | |
| INV_SOFTWARE_FULL | Inventory: Software details | |
| INV_TAG | Inventory: Tag | |
| INV_TYPE | Inventory: Type | |
| INV_TYPE_FULL | Inventory: Type details | |
| INV_URL_A | Inventory: URL A | |
| INV_URL_B | Inventory: URL B | |
| INV_URL_C | Inventory: URL C | |
| INV_VENDOR | Inventory: Vendor |
Additional hints:
- The columns are case-insensitive, so
NAME,nameandNaMeare all valid. - The columns must be in the first line of the CSV file.
- The separator character must be the same as in the import dialog and can either be a semicolon, comma or a tabulator.
The CSV file can then be imported in the same menu entry. You get a chance to preview the host list before the actual import.