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
- This module is not guaranteed to have a backwards compatible interface. [preview]
- This module is maintained by the Ansible Community. [community]
Authors
- René Moser (@resmo)
Hint
If you notice any issues in this documentation you can edit this document to improve it.
© 2012–2018 Michael DeHaan
© 2018–2019 Red Hat, Inc.
Licensed under the GNU General Public License version 3.
https://docs.ansible.com/ansible/2.7/modules/influxdb_query_module.html