Query the Historical Database for AVEVA Pipeline Operations for Liquids information

To query the Historical database

1. On the system used to set up AVEVA Pipeline Operations for Liquids, open Microsoft SQL Server Management Studio.

2. Select Connect > Database Engine.

3. Enter the name of the database to which you'd like to connect (AVEVA Pipeline Operations for Liquids information is stored in the LMS database).

4. Select New Query.

5. Enter select * from <table/view>.

   For example, enter select * from ticketHourlyIntegration. This query can be used to access tables or views.

6. Select Execute.