Solutions
...
Litmus Production Record Datab...
Interacting with Litmus Produc...
Reading out specific Tag definition - second option
6min
use cases reading out the tag definition can be used to verify what tags do exist and what items and meta data are defined this is most useful, when creating a new tag or wanting to modify an existing tag user can do this either by using applications such as microsoft sql server management studio mssql cli this can also be used for building custom solutions based on applications which allow for an odbc connection such as excel c# net python litmus does provide such as custom solution which can be downloaded from our central portal method execute stored procedure prorec tag readtagconfiguration note litmus production record database can act similar to an historian and allows to store data for individual defined tags and their meta data input variables variable name datatype description example @tag varchar(50) the name of a tag tag names can occur several times for different devices but have to be unique per device mandatory! can not be null or empty isrunning @device varchar(50) the name of a specific device devices in litmus production record database are acting the same way as they do in litmus edge in grouping tags logically together it is recommended to use the same device name as used in litmus edge mandatory! can not be null or empty l1 machine2 1 mb how to use to read out a specific data model definition, call the stored procedure prorec tag readtagconfiguration using the t sql exec or execute keyword and provide the input variables below is an example using t sql in sql server management studio execute \[le productionrecord] \[dbo] \[prorec tag readtagconfiguration] @tag = n'isrunning', @device = n' l1 machine2 1 mb '; result the function returns a table as result