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.query_results

Return Values

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

Key Returned Description
query_results
list
 success
Result from the query

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


Status

Authors

  • René Moser (@resmo)

Hint

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