Software tools i use

SQL Server 2019 Visual Studio Code Azure Data Studio PostgreSQL + TimescaleDB InfluxDB Grafana Node-RED Docker Ubuntu 19.04 Spotify Development Server AMD Ryzen 5 – 2400G 16GB RAM 1TB + 240GB SSD’s

SQL Get to know your data

Example SQL statements to learn what data Anywhere365 has stored in your SQL server database. You need to install the PowerBI views that come with the Anywhere365 PowerBI template. On request with support ticket. select count(*) as ‘Total calls in db’ from powerbi_dialogue

Grafana SQL statements

[pl_row] [pl_col col=12] [pl_text] select count(*) from powerbi_dialogue [/pl_text] [/pl_col] [/pl_row]

Grafana resources

The open platform for beautiful analytics and monitoring The leading open source software for time series analytics