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
string / required
Name of the database.
hostname
string
Default:
"localhost"
The hostname or IP address on which InfluxDB server is listening.
Since Ansible 2.5, defaulted to localhost.
password
string
Default:
"root"
Password that will be used to authenticate against InfluxDB server.
Alias login_password added in Ansible 2.5.

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

aliases: login_username
validate_certs
boolean
added in 2.5
    Choices:
  • no
  • 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.