Solutions
...
Litmus Production Record Datab...
Interacting with Litmus Produc...
Reading out the Log Tables for Litmus Production Record Database
7 min
use cases to ensure the supportability and sustainability of litmus production record database reading out the log for the various subsystems to monitor for example for errors is one of the cornerstones of a support strategy 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 a function for this which can be used in either a select statement as well can be part of a custom stored procedure method run s elect query with function prorec misc getlogfiledatautc as from clause note as the log tables for the various sub systems can store a lot of entries in the verbose mode , t o not overwhelm the storage requirements for litmus production record database, the table holds by default only one day of records this can be modified through the stored procedure introduced by the chapter modify application configuration items docid\ nizz5qavwknlczz51008q input variables 155,141,239,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 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 read out the log data, execute a select statement from the function prorec misc getlogfiledatautc providing all the required inputs below is an example using t sql in sql server management studio select from \[dbo] \[prorec misc getlogfiledatautc] ( default ,default ,default ,default ,default) result the function returns a table as result additional options 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 from \[dbo] \[prorec misc getlogfiledatautc] ( default ,default ,default ,default ,default) order by logtime desc the result will be a table, where all rows are sorted by their logtime in descending order