SQL Database and Zenon Editor

SQL Database and Zenon Editor

Hi,
I m trying to create a report which will give me efficiency of the machines. For this reason I have created a new picture but I am confused on how to extract the information of (Alarm Duration, running time of the machine) from the Database.
I was thinking if I could create new variables and use MATH formulas to calculate the figures that will work but cannot find a way out to extract the values from the database to carry on.
Your help will be highly appreciated
Regards,
Jaz

This is a migrated post! Originally posted on 29.07.2009 by user bmcbrita. Please be aware that information can be outdated.