Issue
Help with Creating Custom Reports for EcoStruxure Reports Server
Product Line
EcoStruxure Building Operation
Environment
- SQL
- Report Builder 3.0
Cause
In order to create a custom report for EcoStruxure, the user must have a basic knowledge of SQL and writing SQL SELECT Statements. Report Builder 3.0 can walk a user through most of the process but there is a bit of a learning curve.
Resolution
If you are attempting to create a custom report the most difficult piece of information is determining what Tables store which information. To get definitions of Table Rows, run the provided Database Schema report in the Web Reports browser. This will show primary/foreign key relationships as well as give you information on what is stored in each column.
Information on Extended Trend Logs is stored in the tbLoggedEntities table and the tbLogTimeValues Tables.
Additional Metering information can be found in tbMeter, tbMeteringLogFilter, tbEntityData and tbEntityRelation
