Interacting with Litmus Production Record Database

2min
Litmus Production Record Database is entirely build in Microsoft SQL Server. Supported are all versions from MSQL Server 2017 onwards as well as all editions.

Due to this architecture, users do not need additional software to be installed to use Litmus Production Record Database, as the solution includes all he means necessary in the form of Procedures, Functions or Views.

These allow users to perform all tasks which are required to setup and manage Data Models as well as insert data or retrieve query results.

As they take the form of T-SQL code, users have a wide range of options for interacting with Litmus Production Record Database.

Options include direct execution of these Procedures, Functions and views through applications MSSQL CLI or Microsoft SQL Server Management Studio.

Additionally, users have the option to create their own custom applications using any programming language which supports the execution of T-SQL.
For customers convenience, Litmus does offer several custom solutions to work with Litmus Production Record Database. 
Please feel free to browse our dedicated solutions for Litmus Production Record Database.
To the Guides
﻿Inserting Single Production Record Item if not using Litmus Edge Integration﻿﻿
﻿Inserting Multiple Production Record Item if not using Litmus Edge Integration﻿﻿
﻿Inserting Production Record Item if not using Litmus Edge Integration via JSON﻿﻿
﻿Inserting Single Tag Item if not using Litmus Edge Integration﻿﻿
﻿Inserting Multiple Tag Items if not using Litmus Edge Integration﻿﻿
﻿Inserting Tag Items if not using Litmus Edge Integration via JSON﻿﻿
﻿Reading Production Record Event Data with UTC timestamp﻿﻿
﻿Reading Production Record Event Data with Local timestamp﻿﻿
﻿Reading Tag Data with UTC timestamp﻿﻿
﻿Reading Tag Data with Local timestamp﻿﻿
﻿Reading out the Application configuration of Litmus Production Record Database﻿﻿
﻿Reading Tag Meta Data with Local timestamp﻿﻿
﻿Reading out Data Model definitions﻿﻿
﻿Reading out specific Data Model definition - second option﻿﻿
﻿Adding or Modifying a Data Model Item﻿﻿
﻿Adding or Modifying a Data Model Item(s) via JSON﻿﻿
﻿Reading out Tag definitions﻿﻿
﻿Reading out specific Tag definition - second option﻿﻿
﻿Adding or Modifying a Tag Item﻿﻿
﻿Adding or Modifying a Tag Item(s) via JSON﻿﻿
﻿Reading out all Event definitions﻿﻿
﻿Reading out a specific Event definition﻿﻿
﻿Adding or Modifying an Event definition﻿﻿
﻿Deleting an Event definition﻿﻿
﻿Complete factory reset﻿﻿
﻿Reading out the Application configuration of Litmus Production Record Database﻿﻿
﻿Modify Application Configuration Items﻿﻿
﻿Creating a backup of a data model configuration﻿﻿
﻿Purging a data model configuration﻿﻿
﻿Restore a data model configuration﻿﻿
﻿Purging production record data for a specific data model﻿﻿
﻿Purging production record data for a specific Production Record ID﻿﻿
﻿Restore production record data﻿﻿
﻿Creating a backup of a tag definition﻿﻿
﻿Purging of a tag definition﻿﻿
﻿Restore a tag definition﻿﻿
﻿Purging tag and meta data for a specific tag﻿﻿
﻿Restore tag and meta data﻿﻿
﻿Restore tag data from automated backup﻿﻿
﻿Reading Production Record Event Data Transposed with UTC timestamp﻿﻿
﻿Reading Production Record Event Data Transposed based on Occurrence with UTC timestamp﻿﻿
﻿Reading Tag Data Transposed with UTC timestamp﻿﻿
﻿Reading Tag Meta Data Transposed with UTC timestamp﻿﻿
﻿Reading Production Record Event Data for SPC with UTC timestame﻿﻿
﻿Reading Tag Data for SPC with UTC timestame﻿﻿
﻿Rerunning a failed Transaction﻿﻿
﻿
Updated 04 Oct 2023
Production Event Tracking
Inserting Single Production Record Item if not using Litmus Edge Integration