Article 3.6.1AE : How to check Live Data in a SQL?

First, open the SQL server management studio (SSMS) and log in with the user id and password.

After that follow below hierarchy to get Online data from SQL.

ElNetDB > dbo.LiveData > Edit Top 200 Rows.

You will find the table of the list of the meter with device id and all parameters at the end column last stored data time and date will be seen.

• Related Articles

• Article 3.6 SQL 2019 Installation Guide

  Please find the attachment

• Article 3.6.5S : How to check Server name and PW of SQL?

  Yes, we can know the server name and Password of the SQL server management studio. With the help of ElNet master application is available in the software installation folder in the server PC program file. Click on ElNet master and we can know the SQL ...

• Article 3.6.1T : How to copy SQL Data from one table to another table ?

  1. SET NOCOUNT ON SET STATISTICS TIME ON INSERT INTO Table_name_one (    colm1,    colm2,    colm3,    colm4,    colm5 ) SELECT    colm1,    colm2,    colm3,    colm4,    colm5, FROM Table_name_two SET STATISTICS TIME OFF SET NOCOUNT OFF Note: Before ...

• Article 3.6.1AR : SQL Version Details Supported for Windows OS

  Hi All, Please find the below link to check whether the selected version of SQL will support with the windows OS at any client location. https://docs.microsoft.com/en-us/troubleshoot/sql/general/use-sql-server-in-windows

• Article 3.1.45S : SQL Configurator Manager is not showing in system

  If SQL Configurator manager is not showing in system follow below process to find. Go to C Drive -> Windows - > System 32 - > SQL server manager - > Open