Reading out all Event definitions
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.
Execute Stored Procedure PROREC_Event_ReadAllEventConfigurations.
To read out all event definitions, call the stored procedure PROREC_Event_ReadAllEventConfigurations using the T-SQL EXEC or EXECUTE keyword. Below is an example using T-SQL in SQL Server Management Studio:
The function returns a table as result.
The result does include a column with no naming. which is intended to provide a single string representation of a NodeName, EventName and TriggerName combination. This is used by a Litmus provided solution and can also be used by customers in a similar capacity.
