Configure Oracle Specific Queries

If you are using a SQL Server database, the product is configured by default to use the SQL Server versions of these queries, so no manual steps are required.

The Event Trend Daily and Event Trend Monthly summary reports are built using multiple queries, where some of those queries contain syntax that is database-specific and can be interpreted only on Oracle or SQL Server databases. If, however, you are using an Oracle database, you will need to configure the product manually to use the Oracle versions of these queries.

Specifically, the following queries are delivered with a SQL Server and Oracle version, where the Oracle version contains the text _Oracle in the name.

SQL Server Version

Oracle Version

Event Trend Daily

Event Trend Daily_Oracle

Event Trend Monthly

Event Trend Monthly_Oracle

Past 10 Days List

Past 10 Days List_Oracle

Past 12 Months List

Past 12 Months List_Oracle

Steps

  1. Rename the SQL Server versions of the queries. For example, you might want to rename the Event Trend Daily query Event Trend Daily_SQL.
  2. In the Oracle versions of the queries, remove the text _Oracle from the name.

    Queries are configured for Oracle users.

Copyright © 2018 General Electric Company. All rights reserved.