Example Queries

These queries can be executed using external tools to access the InfluxDB® natively (InfluxDB® command line interface, telegraf, etc.)
Note: These queries are only relevant for directly accessing InfluxDB® (not for using WinCC OAfunctions)

Checking if the database generally works:

SELECT * FROM Event.Event LIMIT 10

Requesting float values:

SELECT "name", "original_value_float", "original_value_float_special" FROM Event.Event WHERE "valuetype" = 3

Requesting all values from a specific type:

SELECT * FROM Event.Event WHERE "variabletype" = 'ExampleDP_Float'

Using a regular expression to request all "_text" columns for alerts:

SELECT "name", /^_text.*/ FROM Alert.Alert