01 - InfluxDB: First Steps and Guide-Lines

InfluxLine Protocol

InfluxDB line protocol is a text based format for writing points to InfluxDB.

Syntax

<measurement>,<tag_key>=<tag_value>,<tag_key>=<tag_value> <field_key>=<field_value>,<field_key>=<field_value> <timestamp>

Example:

win_process_usage,ProcessName,ID Handles,PagedmemorySize,CPU

Measurement = win_process_usace
Tags = ProcessName, ID
Fields = Handles, PagedmemorySize, CPU

Syntax description

Element	Optional/Required	Description	Type
Measurement	Required	The measurement name. InfluxDB accepts one measurement per point.	String
Tag set	Optional	All tag key-value pairs for the point.	Tag keys and tag values are both strings.
Field set	Required. Points must have at least one field.	All field key-value pairs for the point.	Field keys are strings. Field values can be floats, integers, strings, or Booleans.
Timestamp	Optional. InfluxDB uses the server’s local nanosecond timestamp in UTC if the timestamp is not included with the point.	The timestamp for the data point. InfluxDB accepts one timestamp per point.	Unix nanosecond timestamp. Specify alternative precisions with the InfluxDB API.

PowerShell-Example to write this with the Telegraf Agent to an InfluxDB

Telegraf configuration name "inputs.exec.process.conf"

 [[inputs.exec]]
 commands = ['powershell -NopProfile -file "C:\Program Files\Telegraf\scripts\input.process.ps1"']
 timeout = "1m"
 data_format = "influx" 

PowerShell-Skript named "input.process.ps1"

$Processes = Get-Process -Name *vmm* | Select-Object ProcessName, Id, Handles, PagedmemorySize, CPU
 
ForEach ($Process in $Processes) {
    Write-Output "win_process_usage,ProcessName=$($Process.ProcessName) ID=$($Process.Id),Handles=$($Process.Handles),PagedmemorySize=$($Process.PagedmemorySize),CPU=$($Process.CPU)"
}

More informations: https://docs.influxdata.com/influxdb/v1.8/write_protocols/line_protocol_reference/