Reading Tag Data with UTC timestamp

7 min

use cases returning tag data recorded by litmus production record database through the use of these select statements can be used for example by any visualization platform which allows to integrate with mssql like; grafana powerbi tableau further can these queries be used by any other application which allows for an odbc connection such as excel c# net python r they can also be part of a larger stored procedure developed by users with t sql method run s elect query with function prorec tag gettagdatautc as from clause input variables 155,141,239,219,133,114 true unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type how to use to query tag data, execute a select statement from the function prorec tag gettagdatautc providing all the required inputs below is an example using t sql in sql server management studio select from \[le productionrecord] \[dbo] \[prorec tag gettagdatautc] ( default ,default ,default ,default ,default ,default ,default) order by recordtime desc; result the function returns a table as result additional options it is possible to reduce the number of columns returned by the select statement below is an example using t sql in sql server management studio select recordtime, tagvalue from \[le productionrecord] \[dbo] \[ prorec tag gettagdatautc ] ( 'rwt lvl scvl pv' ,default ,default ,default ,default ,default ,default); this will reduce the number of columns returned to only the two selected it is possible to sort data based on users requirements returned by the select statement below is an example using t sql in sql server management studio select recordtime, tagvalue from \[le productionrecord] \[dbo] \[prorec tag gettagdatautc] ( 'rwt lvl scvl pv' ,default ,default ,default ,default ,default ,default ) order by recordtime asc; the result will be a table, where all rows are sorted by their recordtime in ascending order