Using InfluxDB CLI commands for winccoa db

[Sabragan]

Hi,

I was trying to see some content from the influxdb for troubleshooting reasons.

Unfortunately, when I run the CLI commands to make a query on the winccoa database, I get no output. Is this action not allowed by permissions or am I missing something?

I would like to ask if anyone tried to use Influx CLI to execute some queries on the InfluxDB of WinCC OA?

You can see the screenshot in the attachment.

C:\Siemens\Automation\WinCC_OA\3.18\bin>influx -precision rfc3339
Connected to http://localhost:8086 version 1.8.3
InfluxDB shell version: 1.8.3
> auth
username: etm
password:
> show databases
name: databases
name
----
winccoa
_internal
> use winccoa
Using database winccoa
> show measurements
name: measurements
name
----
ALERT
EVENT
Group9
> select * from ALERT limit 3

After the final query, I get no result.

[leoknipp]

I have never tried to use the command line to read data from the database.
Which kind of information to you want to read from the Influx database?
What type of trouble shooting do you want to do?

Best Regards
Leopold Knipp
Senior Support Specialist

[gschijndel]

In the documentation at the bottom of the page InfluxDB® Schema there are some examples.

It would suggest a query like this:

Code: Select all

SELECT * FROM Alert.Alert LIMIT 3