Solutions
...
Litmus Production Record Datab...
Interacting with Litmus Produc...
Reading out a specific Event definition
5min
use cases litmus production record database is capable of monitoring tag data for production events and then record these events reading out an event definition can be used to verify what events do exist and what are the triggers and what data are recorded if a trigger is executed 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 event readeventconfiguration input variables variable name datatype description example @nodename varchar(50) the name of a root node of a specific data model mandatory! can not be null or empty downtime @eventname varchar(50) the name of a specific event mandatory! can not be null or empty downtimel1m2 how to use to read out a specific event definition, call the stored procedure prorec event readeventconfigurati on 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 event readeventconfiguration] @nodename = n'downtime', @eventname = n'downtimel1m2'; result the function returns a table as result