Solutions
...
Interacting with Litmus Produc...
Reading Tag Data for SPC with UTC timestame
5 min
use cases returning tag data recorded by litmus production record database for spc analytics 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 execute stored procedure prorec tag spcchartsfortags input variables 166,127,225,219,133,114 false true false unhandled content type unhandled content type unhandled content type unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type unhandled content type unhandled content type unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type how to use to query production record event data for spc, execute the stored procedure prorec tag spcchartsfortags providing all the required inputs below is an example using t sql in sql server management studio exec \[le productionrecord] \[dbo] \[prorec tag spcchartsfortags] @tagitem = n'value', @tagname = n'toolctr axis x', @devicename = n'toolctr v1 3bsm makino1', @subgroups = 5, @timestart = '2023 03 24t16 46 00z', @timeend= '2023 03 24t16 51 00z', @spcchart = 'rbar' result the function returns a table as result the time is in unix time format