Documentation

influxdb_query - Query data points from InfluxDB.

New in version 2.5.

Synopsis

  • Query data points from InfluxDB.

Requirements

The below requirements are needed on the host that executes this module.

  • python >= 2.6
  • influxdb >= 0.9

Parameters

Parameter
Choices/Defaults
Comments
database_name
required
Name of the database.
hostname
Default:
localhost
The hostname or IP address on which InfluxDB server is listening.
Since version 2.5, defaulted to localhost.
password
Default:
root
Password that will be used to authenticate against InfluxDB server.
Alias login_password added in version 2.5.

aliases: login_password
port
Default:
8086
The port on which InfluxDB server is listening
proxies
(added in 2.5)
HTTP(S) proxy to use for Requests to connect to InfluxDB server.
query
required
Query to be executed.
retries
(added in 2.5)
Default:
3
Number of retries client will try before aborting.
0 indicates try until success.
ssl
(added in 2.5)
Use https instead of http to connect to InfluxDB server.
timeout
(added in 2.5)
Number of seconds Requests will wait for client to establish a connection.
udp_port
(added in 2.5)
Default:
4444
UDP port to connect to InfluxDB server.
use_udp
(added in 2.5)
Use UDP to connect to InfluxDB server.
username
Default:
root
Username that will be used to authenticate against InfluxDB server.
Alias login_username added in version 2.5.

aliases: login_username
validate_certs
(added in 2.5)
Default:
yes
If set to no, the SSL certificates will not be validated.
This should only set to no used on personally controlled sites using self-signed certificates.

Examples

- name: Query connections
  influxdb_query:
    hostname: "{{ influxdb_ip_address }}"
    database_name: "{{ influxdb_database_name }}"
    query: "select mean(value) from connections"
  register: connection

- name: Query connections with tags filters
  influxdb_query:
    hostname: "{{ influxdb_ip_address }}"
    database_name: "{{ influxdb_database_name }}"
    query: "select mean(value) from connections where region='zue01' and host='server01'"
  register: connection

- name: Print results from the query
  debug:
    var: connection.results

Return Values

Common return values are documented here, the following are the fields unique to this module:

Key
Returned
Description
results
list
success
Result from the query

Sample:
[{'mean': 1245.5333333333333, 'time': '1970-01-01T00:00:00Z'}]


Status

This module is flagged as preview which means that it is not guaranteed to have a backwards compatible interface.

Author

  • René Moser (@resmo)

Hint

If you notice any issues in this documentation you can edit this document to improve it.