1 Zabbix agent 2

Zabbix agent 2 supports all item keys supported for Zabbix agent on Unix and Windows. This page provides details on the additional item keys, which you can use with Zabbix agent 2 only, grouped by the plugin they belong to.

The item keys are listed without parameters and additional information. Click on the item key to see the full details.

Item key details

Parameters without angle brackets are mandatory. Parameters marked with angle brackets < > are optional.

ceph.df.details[connString,<user>,<apikey>]

The cluster's data usage and distribution among pools.
Return value: JSON object.

Parameters:

• connString - the URI or session name;
  
• user, apikey - the user name and API key for connecting to Ceph.
  

ceph.osd.stats[connString,<user>,<apikey>]

Aggregated and per OSD statistics.
Return value: JSON object.

Parameters:

• connString - the URI or session name;
  
• user, apikey - the user name and API key for connecting to Ceph.
  

ceph.osd.discovery[connString,<user>,<apikey>]

The list of discovered OSDs. Used for low-level discovery.
Return value: JSON object.

Parameters:

• connString - the URI or session name;
  
• user, apikey - the user name and API key for connecting to Ceph.
  

ceph.osd.dump[connString,<user>,<apikey>]

The usage thresholds and statuses of OSDs.
Return value: JSON object.

Parameters:

• connString - the URI or session name;
  
• user, apikey - the user name and API key for connecting to Ceph.
  

ceph.ping[connString,<user>,<apikey>]

Tests whether a connection to Ceph can be established.
Return value: 0 - connection is broken (if there is any error presented including AUTH and configuration issues); 1 - connection is successful.

Parameters:

• connString - the URI or session name;
  
• user, apikey - the user name and API key for connecting to Ceph.
  

ceph.pool.discovery[connString,<user>,<apikey>]

The list of discovered pools. Used for low-level discovery.
Return value: JSON object.

Parameters:

• connString - the URI or session name;
  
• user, apikey - the user name and API key for connecting to Ceph.
  

ceph.status[connString,<user>,<apikey>]

The overall cluster's status.
Return value: JSON object.

Parameters:

• connString - the URI or session name;
  
• user, apikey - the user name and API key for connecting to Ceph.
  

docker.container_info[<ID>,<info>]

Low-level information about a container.
Return value: The output of the ContainerInspect API call serialized as JSON.

Parameters:

• ID - the ID or name of the container;
  
• info - the amount of information returned. Supported values: short (default) or full.

The Agent 2 user ('zabbix') must be added to the 'docker' group for sufficient privileges. Otherwise the check will fail.

docker.container_stats[<ID>]

The container resource usage statistics.
Return value: The output of the ContainerStats API call and CPU usage percentage serialized as JSON.

Parameter:

• ID - the ID or name of the container.

The Agent 2 user ('zabbix') must be added to the 'docker' group for sufficient privileges. Otherwise the check will fail.

docker.containers

The list of containers.
Return value: The output of the ContainerList API call serialized as JSON.

The Agent 2 user ('zabbix') must be added to the 'docker' group for sufficient privileges. Otherwise the check will fail.

docker.containers.discovery[<options>]

Returns the list of containers. Used for low-level discovery.
Return value: JSON object.

Parameter:

• options - specify whether all or only running containers should be discovered. Supported values: true - return all containers; false - return only running containers (default).

The Agent 2 user ('zabbix') must be added to the 'docker' group for sufficient privileges. Otherwise the check will fail.

docker.data.usage

Information about the current data usage.
Return value: The output of the SystemDataUsage API call serialized as JSON.

The Agent 2 user ('zabbix') must be added to the 'docker' group for sufficient privileges. Otherwise the check will fail.

docker.images

Returns the list of images.
Return value: The output of the ImageList API call serialized as JSON.

The Agent 2 user ('zabbix') must be added to the 'docker' group for sufficient privileges. Otherwise the check will fail.

docker.images.discovery

Returns the list of images. Used for low-level discovery.
Return value: JSON object.

The Agent 2 user ('zabbix') must be added to the 'docker' group for sufficient privileges. Otherwise the check will fail.

docker.info

The system information.
Return value: The output of the SystemInfo API call serialized as JSON.

The Agent 2 user ('zabbix') must be added to the 'docker' group for sufficient privileges. Otherwise the check will fail.

docker.ping

Test if the Docker daemon is alive or not.
Return value: 1 - the connection is alive; 0 - the connection is broken.

The Agent 2 user ('zabbix') must be added to the 'docker' group for sufficient privileges. Otherwise the check will fail.

ember.get[<uri>,<path>]

Returns the result of the required device.
Return value: JSON object.

Parameters:

• uri - Ember+ device URI. Default: 127.0.0.1:9998;
  
• path - OID path to device. Empty by default, returns root collection data.
  

memcached.ping[connString,<user>,<password>]

Test if a connection is alive or not.
Return value: 1 - the connection is alive; 0 - the connection is broken (if there is any error presented including AUTH and configuration issues).

Parameters:

• connString - the URI or session name;
  
• user, password - the Memcached login credentials.
  

memcached.stats[connString,<user>,<password>,<type>]

Gets the output of the STATS command.
Return value: JSON - the output is serialized as JSON.

Parameters:

• connString - the URI or session name;
  
• user, password - the Memcached login credentials;
  
• type - stat type to be returned: items, sizes, slabs or settings (empty by default, returns general statistics).

mongodb.collection.stats[connString,<user>,<password>,<database>,collection]

Returns a variety of storage statistics for a given collection.
Return value: JSON object.

Parameters:

• connString - the URI or session name;
  
• user, password - the MongoDB login credentials;
  
• database - the database name (default: admin);
  
• collection - the collection name.

mongodb.cfg.discovery[connString,<user>,<password>]

Returns a list of discovered configuration servers.
Return value: JSON object.

Parameters:

• connString - the URI or session name;
  
• user, password - the MongoDB login credentials.
  

mongodb.collections.discovery[connString,<user>,<password>]

Returns a list of discovered collections. Used for low-level discovery.
Return value: JSON object.

Parameters:

• connString - the URI or session name;
  
• user, password - the MongoDB login credentials.
  

mongodb.collections.usage[connString,<user>,<password>]

Returns the usage statistics for collections.
Return value: JSON object.

Parameters:

• connString - the URI or session name;
  
• user, password - the MongoDB login credentials.
  

mongodb.connpool.stats[connString,<user>,<password>]

Returns information regarding the open outgoing connections from the current database instance to other members of the sharded cluster or replica set.
Return value: JSON object.

Parameters:

• connString - the URI or session name;
  
• user, password - the MongoDB login credentials.

mongodb.db.stats[connString,<user>,<password>,<database>]

Returns the statistics reflecting a given database system state.
Return value: JSON object.

Parameters:

• connString - the URI or session name;
  
• user, password - the MongoDB login credentials;
  
• database - the database name (default: admin).
  

mongodb.db.discovery[connString,<user>,<password>]

Returns a list of discovered databases. Used for low-level discovery.
Return value: JSON object.

Parameters:

• connString - the URI or session name;
  
• user, password - the MongoDB login credentials.
  

mongodb.jumbo_chunks.count[connString,<user>,<password>]

Returns the count of jumbo chunks.
Return value: JSON object.

Parameters:

• connString - the URI or session name;
  
• user, password - the MongoDB login credentials.
  

mongodb.oplog.stats[connString,<user>,<password>]

Returns the status of the replica set, using data polled from the oplog.
Return value: JSON object.

Parameters:

• connString - the URI or session name;
  
• user, password - the MongoDB login credentials.
  

mongodb.ping[connString,<user>,<password>]

Test if a connection is alive or not.
Return value: 1 - the connection is alive; 0 - the connection is broken (if there is any error presented including AUTH and configuration issues).

Parameters:

• connString - the URI or session name;
  
• user, password - the MongoDB login credentials.
  

mongodb.rs.config[connString,<user>,<password>]

Returns the current configuration of the replica set.
Return value: JSON object.

Parameters:

• connString - the URI or session name;
  
• user, password - the MongoDB login credentials.
  

mongodb.rs.status[connString,<user>,<password>]

Returns the replica set status from the point of view of the member where the method is run.
Return value: JSON object.

Parameters:

• connString - the URI or session name;
  
• user, password - the MongoDB login credentials.
  

mongodb.server.status[connString,<user>,<password>]

Returns the database state.
Return value: JSON object.

Parameters:

• connString - the URI or session name;
  
• user, password - the MongoDB login credentials.
  

mongodb.sh.discovery[connString,<user>,<password>]

Returns the list of discovered shards present in the cluster.
Return value: JSON object.

Parameters:

• connString - the URI or session name;
  
• user, password - the MongoDB login credentials.
  

mongodb.version[connString,<user>,<password>]

Returns the database server version.
Return value: String.

Parameters:

• connString - the URI or session name;
  
• user, password - the MongoDB login credentials.
  

mqtt.get[<broker url>,topic,<user>,<password>]

Subscribes to a specific topic or topics (with wildcards) of the provided broker and waits for publications.
Return value: Depending on topic content. If wildcards are used, returns topic content as JSON.

Parameters:

• broker url - the MQTT broker URL in the format protocol://host:port without query parameters (supported protocols: tcp, ssl, ws). If no value is specified, the agent will use tcp://localhost:1883. If a protocol or port are omitted, default protocol (tcp) or port (1883) will be used;
  
• topic - the MQTT topic (mandatory). Wildcards (+,#) are supported;
  
• user, password - the authentication credentials (if required).
  

Comments:

• The item must be configured as an active check ('Zabbix agent (active)' item type);
• TLS encryption certificates can be used by saving them into a default location (e.g. /etc/ssl/certs/ directory for Ubuntu). For TLS, use the tls:// scheme.

mssql.availability.group.get[URI,<user>,<password>]

Returns availability groups.
Return value: JSON object.

Parameters:

• URI - MSSQL server URI (the only supported schema is sqlserver://). Embedded credentials will be ignored. It is possible to specify an instance name as part of the URI, i.e.: sqlserver://localhost/InstanceName (no port). If port is specified, the instance name is ignored;
  
• user, password - username, password to send to protected MSSQL server.
  

For more information see the MSSQL plugin readme.

mssql.custom.query[URI,<user>,<password>,queryName,<args...>]

Returns the result of a custom query.
Return value: JSON object.

Parameters:

• URI - MSSQL server URI (the only supported schema is sqlserver://). Embedded credentials will be ignored. It is possible to specify an instance name as part of the URI, i.e.: sqlserver://localhost/InstanceName (no port). If port is specified, the instance name is ignored;
  
• user, password - username, password to send to protected MSSQL server;
  
• queryName - name of a custom query configured in Plugins.MSSQL.CustomQueriesDir without the .sql extension;
  
• args - one or several comma-separated arguments to pass to a query.

For more information see the MSSQL plugin readme.

mssql.db.get

Returns all available MSSQL databases.
Return value: JSON object.

For more information see the MSSQL plugin readme.

mssql.job.status.get

Returns the status of jobs.
Return value: JSON object.

For more information see the MSSQL plugin readme.

mssql.last.backup.get

Returns the last backup time for all databases.
Return value: JSON object.

For more information see the MSSQL plugin readme.

mssql.local.db.get

Returns databases that are participating in an Always On availability group and replica (primary or secondary) and are located on the server that the connection was established to.
Return value: JSON object.

For more information see the MSSQL plugin readme.

mssql.mirroring.get

Returns mirroring info.
Return value: JSON object.

For more information see the MSSQL plugin readme.

mssql.nonlocal.db.get

Returns databases that are participating in an Always On availability group and replica (primary or secondary) located on other servers (the database is not local to the SQL Server instance that the connection was established to).
Return value: JSON object.

For more information see the MSSQL plugin readme.

mssql.perfcounter.get

Returns the performance counters.
Return value: JSON object.

For more information see the MSSQL plugin readme.

mssql.ping

Ping the database. Test if connection is correctly configured.
Return value: 1 - alive, 0 - not alive.

For more information see the MSSQL plugin readme.

mssql.quorum.get

Returns the quorum info.
Return value: JSON object.

For more information see the MSSQL plugin readme.

mssql.quorum.member.get

Returns the quorum members.
Return value: JSON object.

For more information see the MSSQL plugin readme.

mssql.replica.get

Returns the replicas.
Return value: JSON object.

For more information see the MSSQL plugin readme.

mssql.version

Returns the MSSQL version.
Return value: String.

For more information see the MSSQL plugin readme.

mysql.custom.query[connString,<user>,<password>,queryName,<args...>]

Returns the result of a custom query.
Return value: JSON object.

Parameters:

• connString - URI or session name;
  
• user, password - MySQL login credentials;
  
• queryName - name of a custom query, must match SQL file name without an extension;
  
• args - one or several comma-separated arguments to pass to a query.

For more information see the MySQL plugin readme, the Custom queries section.

mysql.db.discovery[connString,<user>,<password>]

Returns the list of MySQL databases. Used for low-level discovery.
Return value: The result of the "show databases" SQL query in LLD JSON format.

Parameters:

• connString - the URI or session name;
  
• user, password - the MySQL login credentials.
  

mysql.db.size[connString,<user>,<password>,<database name>]

The database size in bytes.
Return value: Result of the "select coalesce(sum(data_length + index_length),0) as size from information_schema.tables where table_schema=?" SQL query for specific database in bytes.

Parameters:

• connString - the URI or session name;
  
• user, password - the MySQL login credentials;
  
• database name - the database name.

mysql.get_status_variables[connString,<user>,<password>]

Values of the global status variables.
Return value: Result of the "show global status" SQL query in JSON format.

Parameters:

• connString - the URI or session name;
  
• user, password - the MySQL login credentials.
  

mysql.ping[connString,<user>,<password>]

Test if a connection is alive or not.
Return value: 1 - the connection is alive; 0 - the connection is broken (if there is any error presented including AUTH and configuration issues).

Parameters:

• connString - the URI or session name;
  
• user, password - the MySQL login credentials.
  

mysql.replication.discovery[connString,<user>,<password>]

Returns the list of MySQL replications. Used for low-level discovery.
Return value: the result of the SHOW SLAVE STATUS or SHOW REPLICA STATUS SQL query in LLD JSON format.

Parameters:

• connString - the URI or session name;
  
• user, password - the MySQL login credentials.
  

mysql.replication.get_slave_status[connString,<user>,<password>,<master host>]

The replication status.
Return value: result of the SHOW SLAVE STATUS or SHOW REPLICA STATUS SQL query in JSON format.

Parameters:

• connString - the URI or session name;
  
• user, password - the MySQL login credentials;
  
• master host - the replication master host name. If none found, an error is returned. If this parameter is not specified, all hosts are returned.
  

mysql.version[connString,<user>,<password>]

The MySQL version.
Return value: String (with the MySQL instance version).

Parameters:

• connString - the URI or session name;
  
• user, password - the MySQL login credentials.
  

net.dns.get[<ip>,name,<type>,<timeout>,<count>,<protocol>,"<flags>"]

Performs a DNS query and returns detailed DNS record information.
This item is an extended version of the net.dns.record Zabbix agent item with more record types and customizable flags supported.
Return values: JSON object

Parameters:

• ip - the IP address of DNS server (leave empty for the default DNS server);
• name - the DNS name to query;
• type - the record type to be queried (default is SOA);
• timeout - the timeout for the request in seconds (default is 1 second);
• count - the number of tries for the request (default is 2);
• protocol - the protocol used to perform DNS queries: udp (default) or tcp;
• flags - one or more comma-separated arguments to pass to a query.

Comments:

• The possible values for type are: A, NS, MD, MF, CNAME, SOA, MB, MG, MR, NULL, PTR, HINFO, MINFO, MX, TXT, RP, AFSDB, X25, ISDN, RT, NSAPPTR, SIG, KEY, PX, GPOS, AAAA, LOC, NXT, EID, NIMLOC, SRV, ATMA, NAPTR, KX, CERT, DNAME, OPT, APL, DS, SSHFP, IPSECKEY, RRSIG, NSEC, DNSKEY, DHCID, NSEC3, NSEC3PARAM, TLSA, SMIMEA, HIP, NINFO, RKEY, TALINK, CDS, CDNSKEY, OPENPGPKEY, CSYNC, ZONEMD, SVCB, HTTPS, SPF, UINFO, UID, GID, UNSPEC, NID, L32, L64, LP, EUI48, EUI64, URI, CAA, AVC, AMTRELAY. Note that values must be in uppercase only; lowercase or mixed case values are not supported.
• For reverse DNS lookups (when type is set to PTR), you can provide the DNS name in both reversed and non-reversed format (see examples below). Note that when PTR record is requested, the DNS name is actually an IP address.
• The possible values for flags are: cdflag or nocdflag (default), rdflag (default) or nordflag, dnssec or nodnssec (default), nsid or nonsid (default), edns0 (default) or noedns0, aaflag or noaaflag (default), adflag or noadflag (default). The flags dnssec and nsid cannot be used together with noedns0, as both require edns0. Note that values must be in lowercase only; uppercase case or mixed case values are not supported.
• Internationalized domain names are not supported, please use IDNA encoded names instead.
• The output is an object containing DNS record information based on the parameters provided (see more details).

Examples:

net.dns.get[192.0.2.0,example.com,DNSKEY,3,3,tcp,"cdflag,rdflag,nsid"]

net.dns.get[,198.51.100.1,PTR,,,,"cdflag,rdflag,nsid"]
net.dns.get[,1.100.51.198.in-addr.arpa,PTR,,,,"cdflag,rdflag,nsid"]

net.dns.get[,2a00:1450:400f:800::200e,PTR,,,,"cdflag,rdflag,nsid"]
net.dns.get[,e.0.0.2.0.0.0.0.0.0.0.0.0.0.0.0.0.0.8.0.f.0.0.4.0.5.4.1.0.0.a.2.ip6.arpa,PTR,,,,"cdflag,rdflag,nsid"]

nvml.device.count

The number of GPU devices.
Return value: Integer.

For more information see the NVIDIA GPU plugin readme.

nvml.device.decoder.utilization[<deviceUUID>]

GPU device decoder utilization as a percentage.
Return value: Integer.

Parameter:

• deviceUUID - GPU device UUID.

For more information see the NVIDIA GPU plugin readme.

nvml.device.ecc.mode[<deviceUUID>]

GPU device ECC mode information (current, pending).
Return value: JSON.

Parameter:

• deviceUUID - GPU device UUID.

For more information see the NVIDIA GPU plugin readme.

nvml.device.encoder.stats.get[<deviceUUID>]

GPU device encoder statistics.
Return value: JSON.

Parameter:

• deviceUUID - GPU device UUID.

For more information see the NVIDIA GPU plugin readme.

nvml.device.encoder.utilization[<deviceUUID>]

GPU device encoder utilization as a percentage.
Return value: Integer.

Parameter:

• deviceUUID - GPU device UUID.

For more information see the NVIDIA GPU plugin readme.

nvml.device.energy.consumption[<deviceUUID>]

GPU device total energy consumption in millijoules (mJ) since the driver was last reloaded.
Return value: Integer.

Parameter:

• deviceUUID - GPU device UUID.

For more information see the NVIDIA GPU plugin readme.

nvml.device.errors.memory[<deviceUUID>]

GPU device ECC memory error information (corrected, uncorrected).
Return value: JSON.

Parameter:

• deviceUUID - GPU device UUID.

For more information see the NVIDIA GPU plugin readme.

nvml.device.errors.register[<deviceUUID>]

GPU device ECC register error information (corrected, uncorrected).
Return value: JSON.

Parameter:

• deviceUUID - GPU device UUID.

For more information see the NVIDIA GPU plugin readme.

nvml.device.fan.speed.avg[<deviceUUID>]

GPU device average fan speed as a percentage of maximum speed.
Return value: Integer.

Parameter:

• deviceUUID - GPU device UUID.

For more information see the NVIDIA GPU plugin readme.

nvml.device.get

Discovered GPUs with UUID and name.
Return value: JSON.

For more information see the NVIDIA GPU plugin readme.

nvml.device.graphics.frequency[<deviceUUID>]

GPU device graphics clock speed in MHz.
Return value: Integer.

Parameter:

• deviceUUID - GPU device UUID.

For more information see the NVIDIA GPU plugin readme.

nvml.device.memory.fb.get[<deviceUUID>]

GPU device framebuffer memory statistics (total, reserved, free, used).
Return value: JSON.

Parameter:

• deviceUUID - GPU device UUID.

For more information see the NVIDIA GPU plugin readme.

nvml.device.memory.bar1.get[<deviceUUID>]

GPU device BAR1 memory statistics (total, free, used).
Return value: JSON.

Parameter:

• deviceUUID - GPU device UUID.

For more information see the NVIDIA GPU plugin readme.

nvml.device.memory.frequency[<deviceUUID>]

GPU device memory clock speed in MHz.
Return value: Integer.

Parameter:

• deviceUUID - GPU device UUID.

For more information see the NVIDIA GPU plugin readme.

nvml.device.pci.utilization[<deviceUUID>]

GPU device PCI utilization (transmit/receive throughput in KBps).
Return value: JSON.

Parameter:

• deviceUUID - GPU device UUID.

For more information see the NVIDIA GPU plugin readme.

nvml.device.performance.state[<deviceUUID>]

GPU device performance state.
Return value: Integer.

Parameter:

• deviceUUID - GPU device UUID.

For more information see the NVIDIA GPU plugin readme.

nvml.device.power.limit[<deviceUUID>]

GPU device power limit in milliwatts.
Return value: Integer.

Parameter:

• deviceUUID - GPU device UUID.

For more information see the NVIDIA GPU plugin readme.

nvml.device.power.usage[<deviceUUID>]

GPU device current power usage in milliwatts.
Return value: Integer.

Parameter:

• deviceUUID - GPU device UUID.

For more information see the NVIDIA GPU plugin readme.

nvml.device.serial[<deviceUUID>]

GPU device serial number.
Return value: String.

Parameter:

• deviceUUID - GPU device UUID.

For more information see the NVIDIA GPU plugin readme.

nvml.device.sm.frequency[<deviceUUID>]

GPU device streaming multiprocessor clock speed in MHz.
Return value: Integer.

Parameter:

• deviceUUID - GPU device UUID.

For more information see the NVIDIA GPU plugin readme.

nvml.device.temperature[<deviceUUID>]

GPU device temperature in Celsius.
Return value: Integer.

Parameter:

• deviceUUID - GPU device UUID.

For more information see the NVIDIA GPU plugin readme.

nvml.device.utilization[<deviceUUID>]

GPU device utilization statistics (GPU/memory utilization as a percentage).
Return value: JSON.

Parameter:

• deviceUUID - GPU device UUID.

For more information see the NVIDIA GPU plugin readme.

nvml.device.video.frequency[<deviceUUID>]

GPU device video clock speed in MHz.
Return value: Integer.

Parameter:

• deviceUUID - GPU device UUID.

For more information see the NVIDIA GPU plugin readme.

nvml.system.driver.version

The NVIDIA driver version.
Return value: String.

For more information see the NVIDIA GPU plugin readme.

nvml.version

The NVML library version.
Return value: String.

For more information see the NVIDIA GPU plugin readme.

oracle.diskgroups.stats[connString,<user>,<password>,<service>,<diskgroup>]

Returns the Automatic Storage Management (ASM) disk groups statistics.
Return value: JSON object.

Parameters:

• connString - it can be:
  
  • the URI - if no session with the given name is found, and Plugins.Oracle.ResolveTNS is set to false. If it contains a schema (e.g., "tcp://"), port (e.g., 1521) or both, the ResolveTNS option will not be taken into account, and it anyway will be treated as URI;
    
  • session name - if such a name is found in the plugin configuration file;
    
  • TNS key - if the ResolveTNS option is set to true, and none of the above conditions apply;
    
  • TNS value - if it starts with the open bracket “(“ (leading spaces ignored). In this case, the ResolveTNS option is not taken into account.
    
• user - the Oracle username, supports appending one of the login options as sysdba, as sysoper, as sysasm, as sysbackup, as sysdg, as syskm, or as sysrac in the format user as sysdba (a login option is case-insensitive, must not contain a trailing space).
  
• password - the Oracle password;
  
• service - the Oracle service name;
  
• diskgroup - the name of the ASM disk group to query.

oracle.diskgroups.discovery[connString,<user>,<password>,<service>]

Returns the list of ASM disk groups. Used for low-level discovery.
Return value: JSON object.

Parameters:

• connString - it can be:
  
  • the URI - if no session with the given name is found, and Plugins.Oracle.ResolveTNS is set to false. If it contains a schema (e.g., "tcp://"), port (e.g., 1521) or both, the ResolveTNS option will not be taken into account, and it anyway will be treated as URI;
    
  • session name - if such a name is found in the plugin configuration file;
    
  • TNS key - if the ResolveTNS option is set to true, and none of the above conditions apply;
    
  • TNS value - if it starts with the open bracket “(“ (leading spaces ignored). In this case, the ResolveTNS option is not taken into account.
    
• user - the Oracle username, supports appending one of the login options as sysdba, as sysoper, as sysasm, as sysbackup, as sysdg, as syskm, or as sysrac in the format user as sysdba (a login option is case-insensitive, must not contain a trailing space).
  
• password - the Oracle password;
  
• service - the Oracle service name.
  

oracle.archive.info[connString,<user>,<password>,<service>,<destination>]

The archive logs statistics.
Return value: JSON object.

Parameters:

• connString - it can be:
  
  • the URI - if no session with the given name is found, and Plugins.Oracle.ResolveTNS is set to false. If it contains a schema (e.g., "tcp://"), port (e.g., 1521) or both, the ResolveTNS option will not be taken into account, and it anyway will be treated as URI;
    
  • session name - if such a name is found in the plugin configuration file;
    
  • TNS key - if the ResolveTNS option is set to true, and none of the above conditions apply;
    
  • TNS value - if it starts with the open bracket “(“ (leading spaces ignored). In this case, the ResolveTNS option is not taken into account.
    
• user - the Oracle username, supports appending one of the login options as sysdba, as sysoper, as sysasm, as sysbackup, as sysdg, as syskm, or as sysrac in the format user as sysdba (a login option is case-insensitive, must not contain a trailing space).
  
• password - the Oracle password;
  
• service - the Oracle service name;
  
• destination - the name of the destination to query.

oracle.cdb.info[connString,<user>,<password>,<service>,<database>]

The Container Databases (CDBs) information.
Return value: JSON object.

Parameters:

• connString - it can be:
  
  • the URI - if no session with the given name is found, and Plugins.Oracle.ResolveTNS is set to false. If it contains a schema (e.g., "tcp://"), port (e.g., 1521) or both, the ResolveTNS option will not be taken into account, and it anyway will be treated as URI;
    
  • session name - if such a name is found in the plugin configuration file;
    
  • TNS key - if the ResolveTNS option is set to true, and none of the above conditions apply;
    
  • TNS value - if it starts with the open bracket “(“ (leading spaces ignored). In this case, the ResolveTNS option is not taken into account.
    
• user - the Oracle username, supports appending one of the login options as sysdba, as sysoper, as sysasm, as sysbackup, as sysdg, as syskm, or as sysrac in the format user as sysdba (a login option is case-insensitive, must not contain a trailing space).
  
• password - the Oracle password;
  
• service - the Oracle service name;
  
• database - the name of the database to query.

oracle.custom.query[connString,<user>,<password>,<service>,queryName,<args...>]

The result of a custom query.
Return value: JSON object.

Parameters:

• connString - it can be:
  
  • the URI - if no session with the given name is found, and Plugins.Oracle.ResolveTNS is set to false. If it contains a schema (e.g., "tcp://"), port (e.g., 1521) or both, the ResolveTNS option will not be taken into account, and it anyway will be treated as URI;
    
  • session name - if such a name is found in the plugin configuration file;
    
  • TNS key - if the ResolveTNS option is set to true, and none of the above conditions apply;
    
  • TNS value - if it starts with the open bracket “(“ (leading spaces ignored). In this case, the ResolveTNS option is not taken into account.
    
• user - the Oracle username, supports appending one of the login options as sysdba, as sysoper, as sysasm, as sysbackup, as sysdg, as syskm, or as sysrac in the format user as sysdba (a login option is case-insensitive, must not contain a trailing space).
  
• password - the Oracle password;
  
• service - the Oracle service name;
  
• queryName - the name of a custom query, must match SQL file name without an extension;
  
• args - one or several comma-separated arguments to pass to the query.

Comments:

• Returned data is automatically converted into JSON.
• Avoid returning JSON directly from queries, as it will become corrupted when the plugin attempts to convert it into JSON again.

oracle.datafiles.stats[connString,<user>,<password>,<service>]

Returns the data files statistics.
Return value: JSON object.

Parameters:

• connString - it can be:
  
  • the URI - if no session with the given name is found, and Plugins.Oracle.ResolveTNS is set to false. If it contains a schema (e.g., "tcp://"), port (e.g., 1521) or both, the ResolveTNS option will not be taken into account, and it anyway will be treated as URI;
    
  • session name - if such a name is found in the plugin configuration file;
    
  • TNS key - if the ResolveTNS option is set to true, and none of the above conditions apply;
    
  • TNS value - if it starts with the open bracket “(“ (leading spaces ignored). In this case, the ResolveTNS option is not taken into account.
    
• user - the Oracle username, supports appending one of the login options as sysdba, as sysoper, as sysasm, as sysbackup, as sysdg, as syskm, or as sysrac in the format user as sysdba (a login option is case-insensitive, must not contain a trailing space).
  
• password - the Oracle password;
  
• service - the Oracle service name.

oracle.db.discovery[connString,<user>,<password>,<service>]

Returns the list of databases. Used for low-level discovery.
Return value: JSON object.

Parameters:

• connString - it can be:
  
  • the URI - if no session with the given name is found, and Plugins.Oracle.ResolveTNS is set to false. If it contains a schema (e.g., "tcp://"), port (e.g., 1521) or both, the ResolveTNS option will not be taken into account, and it anyway will be treated as URI;
    
  • session name - if such a name is found in the plugin configuration file;
    
  • TNS key - if the ResolveTNS option is set to true, and none of the above conditions apply;
    
  • TNS value - if it starts with the open bracket “(“ (leading spaces ignored). In this case, the ResolveTNS option is not taken into account.
    
• user - the Oracle username, supports appending one of the login options as sysdba, as sysoper, as sysasm, as sysbackup, as sysdg, as syskm, or as sysrac in the format user as sysdba (a login option is case-insensitive, must not contain a trailing space).
  
• password - the Oracle password;
  
• service - the Oracle service name.
  

oracle.fra.stats[connString,<user>,<password>,<service>]

Returns the Fast Recovery Area (FRA) statistics.
Return value: JSON object.

Parameters:

• connString - it can be:
  
  • the URI - if no session with the given name is found, and Plugins.Oracle.ResolveTNS is set to false. If it contains a schema (e.g., "tcp://"), port (e.g., 1521) or both, the ResolveTNS option will not be taken into account, and it anyway will be treated as URI;
    
  • session name - if such a name is found in the plugin configuration file;
    
  • TNS key - if the ResolveTNS option is set to true, and none of the above conditions apply;
    
  • TNS value - if it starts with the open bracket “(“ (leading spaces ignored). In this case, the ResolveTNS option is not taken into account.
    
• user - the Oracle username, supports appending one of the login options as sysdba, as sysoper, as sysasm, as sysbackup, as sysdg, as syskm, or as sysrac in the format user as sysdba (a login option is case-insensitive, must not contain a trailing space).
  
• password - the Oracle password;
  
• service - the Oracle service name.
  

oracle.instance.info[connString,<user>,<password>,<service>]

The instance statistics.
Return value: JSON object.

Parameters:

• connString - it can be:
  
  • the URI - if no session with the given name is found, and Plugins.Oracle.ResolveTNS is set to false. If it contains a schema (e.g., "tcp://"), port (e.g., 1521) or both, the ResolveTNS option will not be taken into account, and it anyway will be treated as URI;
    
  • session name - if such a name is found in the plugin configuration file;
    
  • TNS key - if the ResolveTNS option is set to true, and none of the above conditions apply;
    
  • TNS value - if it starts with the open bracket “(“ (leading spaces ignored). In this case, the ResolveTNS option is not taken into account.
    
• user - the Oracle username, supports appending one of the login options as sysdba, as sysoper, as sysasm, as sysbackup, as sysdg, as syskm, or as sysrac in the format user as sysdba (a login option is case-insensitive, must not contain a trailing space).
  
• password - the Oracle password;
  
• service - the Oracle service name.
  

oracle.pdb.info[connString,<user>,<password>,<service>,<database>]

The Pluggable Databases (PDBs) information.
Return value: JSON object.

Parameters:

• connString - it can be:
  
  • the URI - if no session with the given name is found, and Plugins.Oracle.ResolveTNS is set to false. If it contains a schema (e.g., "tcp://"), port (e.g., 1521) or both, the ResolveTNS option will not be taken into account, and it anyway will be treated as URI;
    
  • session name - if such a name is found in the plugin configuration file;
    
  • TNS key - if the ResolveTNS option is set to true, and none of the above conditions apply;
    
  • TNS value - if it starts with the open bracket “(“ (leading spaces ignored). In this case, the ResolveTNS option is not taken into account.
    
• user - the Oracle username, supports appending one of the login options as sysdba, as sysoper, as sysasm, as sysbackup, as sysdg, as syskm, or as sysrac in the format user as sysdba (a login option is case-insensitive, must not contain a trailing space).
  
• password - the Oracle password;
  
• service - the Oracle service name;
  
• database - the name of the database to query.

oracle.pdb.discovery[connString,<user>,<password>,<service>]

Returns the list of PDBs. Used for low-level discovery.
Return value: JSON object.

Parameters:

• connString - it can be:
  
  • the URI - if no session with the given name is found, and Plugins.Oracle.ResolveTNS is set to false. If it contains a schema (e.g., "tcp://"), port (e.g., 1521) or both, the ResolveTNS option will not be taken into account, and it anyway will be treated as URI;
    
  • session name - if such a name is found in the plugin configuration file;
    
  • TNS key - if the ResolveTNS option is set to true, and none of the above conditions apply;
    
  • TNS value - if it starts with the open bracket “(“ (leading spaces ignored). In this case, the ResolveTNS option is not taken into account.
    
• user - the Oracle username, supports appending one of the login options as sysdba, as sysoper, as sysasm, as sysbackup, as sysdg, as syskm, or as sysrac in the format user as sysdba (a login option is case-insensitive, must not contain a trailing space).
  
• password - the Oracle password;
  
• service - the Oracle service name.
  

oracle.pga.stats[connString,<user>,<password>,<service>]

Returns the Program Global Area (PGA) statistics.
Return value: JSON object.

Parameters:

• connString - it can be:
  
  • the URI - if no session with the given name is found, and Plugins.Oracle.ResolveTNS is set to false. If it contains a schema (e.g., "tcp://"), port (e.g., 1521) or both, the ResolveTNS option will not be taken into account, and it anyway will be treated as URI;
    
  • session name - if such a name is found in the plugin configuration file;
    
  • TNS key - if the ResolveTNS option is set to true, and none of the above conditions apply;
    
  • TNS value - if it starts with the open bracket “(“ (leading spaces ignored). In this case, the ResolveTNS option is not taken into account.
    
• user - the Oracle username, supports appending one of the login options as sysdba, as sysoper, as sysasm, as sysbackup, as sysdg, as syskm, or as sysrac in the format user as sysdba (a login option is case-insensitive, must not contain a trailing space).
  
• password - the Oracle password;
  
• service - the Oracle service name.
  

oracle.ping[connString,<user>,<password>,<service>]

Test whether a connection to Oracle can be established.
Return value: 1 - the connection is successful; 0 - the connection is broken (if there is any error presented including AUTH and configuration issues).

Parameters:

• connString - it can be:
  
  • the URI - if no session with the given name is found, and Plugins.Oracle.ResolveTNS is set to false. If it contains a schema (e.g., "tcp://"), port (e.g., 1521) or both, the ResolveTNS option will not be taken into account, and it anyway will be treated as URI;
    
  • session name - if such a name is found in the plugin configuration file;
    
  • TNS key - if the ResolveTNS option is set to true, and none of the above conditions apply;
    
  • TNS value - if it starts with the open bracket “(“ (leading spaces ignored). In this case, the ResolveTNS option is not taken into account.
    
• user - the Oracle username, supports appending one of the login options as sysdba, as sysoper, as sysasm, as sysbackup, as sysdg, as syskm, or as sysrac in the format user as sysdba (a login option is case-insensitive, must not contain a trailing space).
  
• password - the Oracle password;
  
• service - the Oracle service name.
  

Examples:

oracle.ping[tcp://127.0.0.1:1521,ZABBIX_MON,zabbix,xe]
oracle.ping[localhost,ZABBIX_MON,zabbix,xe]
oracle.ping[zbx_tns_example,ZABBIX_MON,zabbix,xe]
oracle.ping["(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=xe)))",ZABBIX_MON,zabbix]

oracle.proc.stats[connString,<user>,<password>,<service>]

Returns the processes statistics.
Return value: JSON object.

Parameters:

• connString - it can be:
  
  • the URI - if no session with the given name is found, and Plugins.Oracle.ResolveTNS is set to false. If it contains a schema (e.g., "tcp://"), port (e.g., 1521) or both, the ResolveTNS option will not be taken into account, and it anyway will be treated as URI;
    
  • session name - if such a name is found in the plugin configuration file;
    
  • TNS key - if the ResolveTNS option is set to true, and none of the above conditions apply;
    
  • TNS value - if it starts with the open bracket “(“ (leading spaces ignored). In this case, the ResolveTNS option is not taken into account.
    
• user - the Oracle username, supports appending one of the login options as sysdba, as sysoper, as sysasm, as sysbackup, as sysdg, as syskm, or as sysrac in the format user as sysdba (a login option is case-insensitive, must not contain a trailing space).
  
• password - the Oracle password;
  
• service - the Oracle service name.
  

oracle.redolog.info[connString,<user>,<password>,<service>]

The log file information from the control file.
Return value: JSON object.

Parameters:

• connString - it can be:
  
  • the URI - if no session with the given name is found, and Plugins.Oracle.ResolveTNS is set to false. If it contains a schema (e.g., "tcp://"), port (e.g., 1521) or both, the ResolveTNS option will not be taken into account, and it anyway will be treated as URI;
    
  • session name - if such a name is found in the plugin configuration file;
    
  • TNS key - if the ResolveTNS option is set to true, and none of the above conditions apply;
    
  • TNS value - if it starts with the open bracket “(“ (leading spaces ignored). In this case, the ResolveTNS option is not taken into account.
    
• user - the Oracle username, supports appending one of the login options as sysdba, as sysoper, as sysasm, as sysbackup, as sysdg, as syskm, or as sysrac in the format user as sysdba (a login option is case-insensitive, must not contain a trailing space).
  
• password - the Oracle password;
  
• service - the Oracle service name.
  

oracle.sga.stats[connString,<user>,<password>,<service>]

Returns the System Global Area (SGA) statistics.
Return value: JSON object.

Parameters:

• connString - it can be:
  
  • the URI - if no session with the given name is found, and Plugins.Oracle.ResolveTNS is set to false. If it contains a schema (e.g., "tcp://"), port (e.g., 1521) or both, the ResolveTNS option will not be taken into account, and it anyway will be treated as URI;
    
  • session name - if such a name is found in the plugin configuration file;
    
  • TNS key - if the ResolveTNS option is set to true, and none of the above conditions apply;
    
  • TNS value - if it starts with the open bracket “(“ (leading spaces ignored). In this case, the ResolveTNS option is not taken into account.
    
• user - the Oracle username, supports appending one of the login options as sysdba, as sysoper, as sysasm, as sysbackup, as sysdg, as syskm, or as sysrac in the format user as sysdba (a login option is case-insensitive, must not contain a trailing space).
  
• password - the Oracle password;
  
• service - the Oracle service name.
  

oracle.sessions.stats[connString,<user>,<password>,<service>,<lockMaxTime>]

Returns the sessions statistics.
Return value: JSON object.

Parameters:

• connString - it can be:
  
  • the URI - if no session with the given name is found, and Plugins.Oracle.ResolveTNS is set to false. If it contains a schema (e.g., "tcp://"), port (e.g., 1521) or both, the ResolveTNS option will not be taken into account, and it anyway will be treated as URI;
    
  • session name - if such a name is found in the plugin configuration file;
    
  • TNS key - if the ResolveTNS option is set to true, and none of the above conditions apply;
    
  • TNS value - if it starts with the open bracket “(“ (leading spaces ignored). In this case, the ResolveTNS option is not taken into account.
    
• user - the Oracle username, supports appending one of the login options as sysdba, as sysoper, as sysasm, as sysbackup, as sysdg, as syskm, or as sysrac in the format user as sysdba (a login option is case-insensitive, must not contain a trailing space).
  
• password - the Oracle password;
  
• service - the Oracle service name;
  
• lockMaxTime - the maximum session lock duration in seconds to count the session as a prolongedly locked. Default: 600 seconds.

oracle.sys.metrics[connString,<user>,<password>,<service>,<duration>]

Returns a set of system metric values.
Return value: JSON object.

Parameters:

• connString - it can be:
  
  • the URI - if no session with the given name is found, and Plugins.Oracle.ResolveTNS is set to false. If it contains a schema (e.g., "tcp://"), port (e.g., 1521) or both, the ResolveTNS option will not be taken into account, and it anyway will be treated as URI;
    
  • session name - if such a name is found in the plugin configuration file;
    
  • TNS key - if the ResolveTNS option is set to true, and none of the above conditions apply;
    
  • TNS value - if it starts with the open bracket “(“ (leading spaces ignored). In this case, the ResolveTNS option is not taken into account.
    
• user - the Oracle username, supports appending one of the login options as sysdba, as sysoper, as sysasm, as sysbackup, as sysdg, as syskm, or as sysrac in the format user as sysdba (a login option is case-insensitive, must not contain a trailing space).
  
• password - the Oracle password;
  
• service - the Oracle service name;
  
• duration - the capturing interval (in seconds) of system metric values. Possible values: 60 — long duration (default), 15 — short duration.

oracle.sys.params[connString,<user>,<password>,<service>]

Returns a set of system parameter values.
Return value: JSON object.

Parameters:

• connString - it can be:
  
  • the URI - if no session with the given name is found, and Plugins.Oracle.ResolveTNS is set to false. If it contains a schema (e.g., "tcp://"), port (e.g., 1521) or both, the ResolveTNS option will not be taken into account, and it anyway will be treated as URI;
    
  • session name - if such a name is found in the plugin configuration file;
    
  • TNS key - if the ResolveTNS option is set to true, and none of the above conditions apply;
    
  • TNS value - if it starts with the open bracket “(“ (leading spaces ignored). In this case, the ResolveTNS option is not taken into account.
    
• user - the Oracle username, supports appending one of the login options as sysdba, as sysoper, as sysasm, as sysbackup, as sysdg, as syskm, or as sysrac in the format user as sysdba (a login option is case-insensitive, must not contain a trailing space).
  
• password - the Oracle password;
  
• service - the Oracle service name.
  

oracle.ts.stats[connString,<user>,<password>,<service>,<tablespace>,<type>,<conname>]

Returns the tablespaces statistics.
Return value: JSON object.

Parameters:

• connString - it can be:
  
  • the URI - if no session with the given name is found, and Plugins.Oracle.ResolveTNS is set to false. If it contains a schema (e.g., "tcp://"), port (e.g., 1521) or both, the ResolveTNS option will not be taken into account, and it anyway will be treated as URI;
    
  • session name - if such a name is found in the plugin configuration file;
    
  • TNS key - if the ResolveTNS option is set to true, and none of the above conditions apply;
    
  • TNS value - if it starts with the open bracket “(“ (leading spaces ignored). In this case, the ResolveTNS option is not taken into account.
    
• user - the Oracle username, supports appending one of the login options as sysdba, as sysoper, as sysasm, as sysbackup, as sysdg, as syskm, or as sysrac in the format user as sysdba (a login option is case-insensitive, must not contain a trailing space).
  
• password - the Oracle password;
  
• service - the Oracle service name;
  
• tablespace - name of the tablespace to query. Default (if left empty and type is set):
  • "TEMP" (if type is set to "TEMPORARY");
  • "USERS" (if type is set to "PERMANENT").
• type - the type of the tablespace to query. Default (if tablespace is set): "PERMANENT".
• conname - name of the container for which the information is required.

If tablespace, type, or conname is omitted, the item will return tablespace statistics for all matching containers (including PDBs and CDB).

oracle.ts.discovery[connString,<user>,<password>,<service>]

Returns a list of tablespaces. Used for low-level discovery.
Return value: JSON object.

Parameters:

• connString - it can be:
  
  • the URI - if no session with the given name is found, and Plugins.Oracle.ResolveTNS is set to false. If it contains a schema (e.g., "tcp://"), port (e.g., 1521) or both, the ResolveTNS option will not be taken into account, and it anyway will be treated as URI;
    
  • session name - if such a name is found in the plugin configuration file;
    
  • TNS key - if the ResolveTNS option is set to true, and none of the above conditions apply;
    
  • TNS value - if it starts with the open bracket “(“ (leading spaces ignored). In this case, the ResolveTNS option is not taken into account.
    
• user - the Oracle username, supports appending one of the login options as sysdba, as sysoper, as sysasm, as sysbackup, as sysdg, as syskm, or as sysrac in the format user as sysdba (a login option is case-insensitive, must not contain a trailing space).
  
• password - the Oracle password;
  
• service - the Oracle service name.

oracle.user.info[connString,<user>,<password>,<service>,<username>]

Returns Oracle user information.
Return value: JSON object.

Parameters:

• connString - it can be:
  
  • the URI - if no session with the given name is found, and Plugins.Oracle.ResolveTNS is set to false. If it contains a schema (e.g., "tcp://"), port (e.g., 1521) or both, the ResolveTNS option will not be taken into account, and it anyway will be treated as URI;
    
  • session name - if such a name is found in the plugin configuration file;
    
  • TNS key - if the ResolveTNS option is set to true, and none of the above conditions apply;
    
  • TNS value - if it starts with the open bracket “(“ (leading spaces ignored). In this case, the ResolveTNS option is not taken into account.
    
• user - the Oracle username, supports appending one of the login options as sysdba, as sysoper, as sysasm, as sysbackup, as sysdg, as syskm, or as sysrac in the format user as sysdba (a login option is case-insensitive, must not contain a trailing space).
  
• password - the Oracle password;
  
• service - the Oracle service name;
  
• username - the username for which the information is needed. Lowercase usernames are not supported. Default: current user.

oracle.version[connString,<user>,<password>,<service>]

Returns the database server version.
Return value: String.

Parameters:

• connString - it can be:
  
  • the URI - if no session with the given name is found, and Plugins.Oracle.ResolveTNS is set to false. If it contains a schema (e.g., "tcp://"), port (e.g., 1521) or both, the ResolveTNS option will not be taken into account, and it anyway will be treated as URI;
    
  • session name - if such a name is found in the plugin configuration file;
    
  • TNS key - if the ResolveTNS option is set to true, and none of the above conditions apply;
    
  • TNS value - if it starts with the open bracket “(“ (leading spaces ignored). In this case, the ResolveTNS option is not taken into account.
    - user - the Oracle username, supports appending one of the login options as sysdba, as sysoper, as sysasm, as sysbackup, as sysdg, as syskm, or as sysrac in the format user as sysdba (a login option is case-insensitive, must not contain a trailing space).
    
• password - the Oracle password;
  
• service - the Oracle service name.

pgsql.autovacuum.count[uri,<username>,<password>,<database name>]

The number of autovacuum workers.
Return value: Integer.

Parameters:

• uri - the URI or session name;
  
• username, password - the PostgreSQL credentials;
  
• database name - the database name (if omitted, the value of Plugins.PostgreSQL.Default.Database from postgresql.conf is used).
  

pgsql.archive[uri,<username>,<password>,<database name>]

The information about archived files.
Return value: JSON object.

Parameters:

• uri - the URI or session name;
  
• username, password - the PostgreSQL credentials;
  
• database name - the database name (if omitted, the value of Plugins.PostgreSQL.Default.Database from postgresql.conf is used).
  

pgsql.bgwriter[uri,<username>,<password>,<database name>]

The combined number of checkpoints for the database cluster, broken down by checkpoint type.
Return value: JSON object.

Parameters:

• uri - the URI or session name;
  
• username, password - the PostgreSQL credentials;
  
• database name - the database name (if omitted, the value of Plugins.PostgreSQL.Default.Database from postgresql.conf is used).
  

pgsql.cache.hit[uri,<username>,<password>,<database name>]

The PostgreSQL buffer cache hit rate.
Return value: Float.

Parameters:

• uri - the URI or session name;
  
• username, password - the PostgreSQL credentials;
  
• database name - the database name (if omitted, the value of Plugins.PostgreSQL.Default.Database from postgresql.conf is used).
  

pgsql.connections[uri,<username>,<password>,<database name>]

Returns connections by type.
Return value: JSON object.

Parameters:

• uri - the URI or session name;
  
• username, password - the PostgreSQL credentials;
  
• database name - the database name (if omitted, the value of Plugins.PostgreSQL.Default.Database from postgresql.conf is used).
  

pgsql.custom.query[uri,<username>,<password>,queryName,<args...>]

Returns the result of a custom query.
Return value: JSON object.

Parameters:

• uri - the URI or session name;
  
• username, password - the PostgreSQL credentials;
  
• queryName - the name of a custom query, must match the SQL file name without an extension;
  
• args - one or several comma-separated arguments to pass to a query.

pgsql.db.age[uri,<username>,<password>,<database name>]

The age of the oldest FrozenXID of the database.
Return value: Integer.

Parameters:

• uri - the URI or session name;
  
• username, password - the PostgreSQL credentials;
  
• database name - the database name (if omitted, the value of Plugins.PostgreSQL.Default.Database from postgresql.conf is used).
  

pgsql.db.bloating_tables[uri,<username>,<password>,<database name>]

The number of bloating tables per database.
Return value: Integer.

Parameters:

• uri - the URI or session name;
  
• username, password - the PostgreSQL credentials;
  
• database name - the database name (if omitted, the value of Plugins.PostgreSQL.Default.Database from postgresql.conf is used).
  

pgsql.db.discovery[uri,<username>,<password>,<database name>]

The list of PostgreSQL databases. Used for low-level discovery.
Return value: JSON object.

Parameters:

• uri - the URI or session name;
  
• username, password - the PostgreSQL credentials;
  
• database name - the database name (if omitted, the value of Plugins.PostgreSQL.Default.Database from postgresql.conf is used).
  

pgsql.db.size[uri,<username>,<password>,<database name>]

The database size in bytes.
Return value: Integer.

Parameters:

• uri - the URI or session name;
  
• username, password - the PostgreSQL credentials;
  
• database name - the database name (if omitted, the value of Plugins.PostgreSQL.Default.Database from postgresql.conf is used).
  

pgsql.dbstat[uri,<username>,<password>,<database name>]

Collects the statistics per database. Used for low-level discovery.
Return value: JSON object.

Parameters:

• uri - the URI or session name;
  
• username, password - the PostgreSQL credentials;
  
• database name - the database name (if omitted, the value of Plugins.PostgreSQL.Default.Database from postgresql.conf is used).
  

pgsql.dbstat.sum[uri,<username>,<password>,<database name>]

The summarized data for all databases in a cluster.
Return value: JSON object.

Parameters:

• uri - the URI or session name;
  
• username, password - the PostgreSQL credentials;
  
• database name - the database name (if omitted, the value of Plugins.PostgreSQL.Default.Database from postgresql.conf is used).
  

pgsql.locks[uri,<username>,<password>,<database name>]

The information about granted locks per database. Used for low-level discovery.
Return value: JSON object.

Parameters:

• uri - the URI or session name;
  
• username, password - the PostgreSQL credentials;
  
• database name - the database name (if omitted, the value of Plugins.PostgreSQL.Default.Database from postgresql.conf is used).
  

pgsql.oldest.xid[uri,<username>,<password>,<database name>]

The age of the oldest XID.
Return value: Integer.

Parameters:

• uri - the URI or session name;
  
• username, password - the PostgreSQL credentials;
  
• database name - the database name (if omitted, the value of Plugins.PostgreSQL.Default.Database from postgresql.conf is used).
  

pgsql.ping[uri,<username>,<password>,<database name>]

Tests whether a connection is alive or not.
Return value: 1 - the connection is alive; 0 - the connection is broken (if there is any error presented including AUTH and configuration issues).

Parameters:

• uri - the URI or session name;
  
• username, password - the PostgreSQL credentials;
  
• database name - the database name (if omitted, the value of Plugins.PostgreSQL.Default.Database from postgresql.conf is used).
  

pgsql.queries[uri,<username>,<password>,<database name>,time period]

Queries metrics by execution time.
Return value: JSON object.

Parameters:

• uri - the URI or session name;
  
• username, password - the PostgreSQL credentials;
  
• database name - the database name (if omitted, the value of Plugins.PostgreSQL.Default.Database from postgresql.conf is used);
  
• time period - the execution time limit for the count of slow queries (must be a positive integer).

pgsql.replication.count[uri,<username>,<password>]

The number of standby servers.
Return value: Integer.

Parameters:

• uri - the URI or session name;
  
• username, password - the PostgreSQL credentials.

pgsql.replication.process[uri,<username>,<password>]

The flush lag, write lag and replay lag per each sender process.
Return value: JSON object.

Parameters:

• uri - the URI or session name;
  
• username, password - the PostgreSQL credentials.

pgsql.replication.process.discovery[uri,<username>,<password>]

The replication process name discovery.
Return value: JSON object.

Parameters:

• uri - the URI or session name;
  
• username, password - the PostgreSQL credentials.

pgsql.replication.recovery_role[uri,<username>,<password>]

The recovery status.
Return value: 0 - master mode; 1 - recovery is still in progress (standby mode).

Parameters:

• uri - the URI or session name;
  
• username, password - the PostgreSQL credentials.

pgsql.replication.status[uri,<username>,<password>]

The status of replication.
Return value: 0 - streaming is down; 1 - streaming is up; 2 - master mode.

Parameters:

• uri - the URI or session name;
  
• username, password - the PostgreSQL credentials.

pgsql.replication_lag.b[uri,<username>,<password>]

The replication lag in bytes.
Return value: Integer.

Parameters:

• uri - the URI or session name;
  
• username, password - the PostgreSQL credentials.

pgsql.replication_lag.sec[uri,<username>,<password>]

The replication lag in seconds.
Return value: Integer.

Parameters:

• uri - the URI or session name;
  
• username, password - the PostgreSQL credentials.

pgsql.uptime[uri,<username>,<password>,<database name>]

The PostgreSQL uptime in milliseconds.
Return value: Float.

Parameters:

• uri - the URI or session name;
  
• username, password - the PostgreSQL credentials;
  
• database name - the database name (if omitted, the value of Plugins.PostgreSQL.Default.Database from postgresql.conf is used).
  

pgsql.version[uri,<username>,<password>,<database name>]

Returns PostgreSQL version.
Return value: String.

Parameters:

• uri - the URI or session name;
  
• username, password - the PostgreSQL credentials;
  
• database name - the database name (if omitted, the value of Plugins.PostgreSQL.Default.Database from postgresql.conf is used).
  

pgsql.wal.stat[uri,<username>,<password>,<database name>]

The WAL statistics.
Return value: JSON object.

Parameters:

• uri - the URI or session name;
  
• username, password - the PostgreSQL credentials;
  
• database name - the database name (if omitted, the value of Plugins.PostgreSQL.Default.Database from postgresql.conf is used).
  

redis.config[connString,<password>,<pattern>]

Gets the configuration parameters of a Redis instance that match the pattern.
Return value: JSON - if a glob-style pattern was used; single value - if a pattern did not contain any wildcard character.

Parameters:

• connString - the URI or session name;
  
• password - the Redis password;
  
• pattern - a glob-style pattern (* by default).

Comment:

• Security warning: redis.config runs the Redis CONFIG GET command and may return sensitive configuration parameters (for example requirepass, masterauth, TLS-related settings, and other secrets). Using the default pattern (*) or wide patterns may expose these secrets to anyone with permission to view item values in Zabbix.

redis.info[connString,<password>,<section>]

Gets the output of the INFO command.
Return value: JSON - the output is serialized as JSON.

Parameters:

• connString - the URI or session name;
  
• password - the Redis password;
  
• section - the section of information (default by default).
  

redis.ping[connString,<password>]

Test if a connection is alive or not.
Return value: 1 - the connection is alive; 0 - the connection is broken (if there is any error presented including AUTH and configuration issues).

Parameters:

• connString - the URI or session name;
  
• password - the Redis password.
  

redis.slowlog.count[connString,<password>]

The number of slow log entries since Redis was started.
Return value: Integer.

Parameters:

• connString - the URI or session name;
  
• password - the Redis password.
  

smart.attribute.discovery

Returns a list of S.M.A.R.T. device attributes.
Return value: JSON object.

Comments:

• The following macros and their values are returned: {#NAME}, {#DISKTYPE}, {#ID}, {#ATTRNAME}, {#THRESH};
• HDD, SSD and NVME drive types are supported. Drives can be alone or combined in a RAID. {#NAME} will have an add-on in case of RAID, e.g: {"{#NAME}": "/dev/sda cciss,2"}.

smart.disk.discovery[<type>]

Returns a list of S.M.A.R.T. devices.
Return value: JSON object.

Parameter:

• type - specifies a value to scan for the disks. Possible values: id, name (default). id is not supported on Windows, and will return an error if selected

Comments:

• The following macros and their values are returned: {#NAME}, {#DISKTYPE}, {#MODEL}, {#SN}, {#PATH}, {#ATTRIBUTES}, {#RAIDTYPE};
• HDD, SSD and NVME drive types are supported. If a drive does not belong to a RAID, the {#RAIDTYPE} will be empty. {#NAME} will have an add-on in case of RAID, e.g: {"{#NAME}": "/dev/sda cciss,2"}.

smart.disk.get[<path>,<raid type>]

Returns all available properties of S.M.A.R.T. devices.
Return value: JSON object.

Parameters:

• path - the disk path, the {#PATH} macro may be used as a value;
  
• raid_type - the RAID type, the {#RAID} macro may be used as a value

Comments:

• HDD, SSD and NVME drive types are supported. Drives can be alone or combined in a RAID;
  
• The data includes smartctl version and call arguments, and additional fields:
  disk_name - holds the name with the required add-ons for RAID discovery, e.g: {"disk_name": "/dev/sda cciss,2"}
  disk_type - holds the disk type HDD, SSD, or NVME, e.g: {"disk_type": "ssd"};
  
• If no parameters are specified, the item will return information about all disks.

systemd.unit.get[unit name,<interface>]

Returns all properties of a systemd unit.
Return value: JSON object.

Parameters:

• unit name - the unit name (you may want to use the {#UNIT.NAME} macro in item prototype to discover the name);
  
• interface - the unit interface type, possible values: Unit (default), Service, Socket, Device, Mount, Automount, Swap, Target, Path.

Comments:

• This item is supported on Linux platform only;
• LoadState, ActiveState and UnitFileState for Unit interface are returned as text and integer: "ActiveState":{"state":1,"text":"active"}.

systemd.unit.info[unit name,<property>,<interface>]

A systemd unit information.
Return value: String.

Parameters:

• unit name - the unit name (you may want to use the {#UNIT.NAME} macro in item prototype to discover the name);
  
• property - unit property (e.g. ActiveState (default), LoadState, Description);
• interface - the unit interface type (e.g. Unit (default), Socket, Service).

Comments:

• This item is supported on Linux platform only;
• This item allows to retrieve a specific property from specific type of interface as described in dbus API.

Examples:

systemd.unit.info["{#UNIT.NAME}"] #collect active state (active, reloading, inactive, failed, activating, deactivating) info on discovered systemd units
systemd.unit.info["{#UNIT.NAME}",LoadState] #collect load state info on discovered systemd units
systemd.unit.info[mysqld.service,Id] #retrieve the service technical name (mysqld.service)
systemd.unit.info[mysqld.service,Description] #retrieve the service description (MySQL Server)
systemd.unit.info[mysqld.service,ActiveEnterTimestamp] #retrieve the last time the service entered the active state (1562565036283903)
systemd.unit.info[dbus.socket,NConnections,Socket] #collect the number of connections from this socket unit

systemd.unit.discovery[<type>]

List of systemd units and their details. Used for low-level discovery.
Return value: JSON object.

Parameter:

• type - possible values: all, automount, device, mount, path, service (default), socket, swap, target.

This item is supported on Linux platform only.

web.certificate.get[hostname,<port>,<address>]

Validates the certificates and returns certificate details.
Return value: JSON object.

Parameter:

• hostname - can be either IP or DNS.
  May contain the URL scheme (https only), path (it will be ignored), and port.
  If a port is provided in both the first and the second parameters, their values must match.
  If address (the 3rd parameter) is specified, the hostname is only used for SNI and hostname verification;
  
• port - the port number (default is 443 for HTTPS);
  
• address - can be either IP or DNS. If specified, it will be used for connection, and hostname (the 1st parameter) will be used for SNI, and host verification. In case, the 1st parameter is an IP and the 3rd parameter is DNS, the 1st parameter will be used for connection, and the 3rd parameter will be used for SNI and host verification.

Comments:

• This item turns unsupported if the destination specified in the host configuration does not exist, is unavailable, or if the TLS handshake fails with any error except an invalid certificate;
  
• Currently, AIA (Authority Information Access) X.509 extension, CRLs and OCSP (including OCSP stapling), and Certificate Transparency are not supported;
• JSON response fields:
  • x509: contains the details of the X.509 certificate.
    • version: the X.509 version (e.g., 3).
    • serial_number: the serial number of the certificate.
    • signature_algorithm: the algorithm used to sign the certificate (e.g., SHA256-RSA).
    • issuer: the issuer of the certificate.
    • not_before: the start date of the certificate's validity.
    • not_after: the expiration date of the certificate.
    • subject: the subject of the certificate.
    • public_key_algorithm: the algorithm used for the public key (e.g., RSA).
    • alternative_names: subject alternative names (if present), otherwise null.
  • result: contains the validation result.
    • value: the validation status (see possible values below).
    • message: detailed validation message (e.g., "certificate verified successfully").
  • sha1_fingerprint: the SHA-1 fingerprint of the certificate.
  • sha256_fingerprint: the SHA-256 fingerprint of the certificate.
• The $.result.value field indicates the certificate validation result. Possible values include:
  • valid – the certificate is valid and trusted.
  • valid-but-self-signed – the certificate is valid but self-signed, meaning its subject matches its issuer.
  • invalid – the certificate is invalid due to an issue such as expiration, incorrect hostname, or an unknown signing authority.

Example:

web.certificate.get[example.com,443]

JSON Response:

{
  "x509": {
    "version": 3,
    "serial_number": "0ad893bafa68b0b7fb7a404f06ecaf9a",
    "signature_algorithm": "ECDSA-SHA384",
    "issuer": "CN=DigiCert Global G3 TLS ECC SHA384 2020 CA1,O=DigiCert Inc,C=US",
    "not_before": {
      "value": "Jan 15 00:00:00 2025 GMT",
      "timestamp": 1736899200
    },
    "not_after": {
      "value": "Jan 15 23:59:59 2026 GMT",
      "timestamp": 1768521599
    },
    "subject": "CN=*.example.com,O=Internet Corporation for Assigned Names and Numbers,L=Los Angeles,ST=California,C=US",
    "public_key_algorithm": "ECDSA",
    "alternative_names": [
      "*.example.com",
      "example.com"
    ]
  },
  "result": {
    "value": "valid",
    "message": "certificate verified successfully"
  },
  "sha1_fingerprint": "310db7af4b2bc9040c8344701aca08d0c69381e3",
  "sha256_fingerprint": "455943cf819425761d1f950263ebf54755d8d684c25535943976f488bc79d23b"
}