Unanswered: make a report against an InSQL database (was "Question.....")
I am new to the database world and I am trying to understand how all this works. I understand Access and SQL for the most part. My idea that I want to implement is that I want to be able to implement a maintenance log that records motor running life, and piston cycles in the plant. I have a PLC communicating to a server to an InSQL database. Where do i start if i want to make a report that basically counts the total hours that a motor is running, or how many times a piston goes in and out?
IndustrialSQL Server is an extension to Microsoft® SQL Server™ 7.0, acquiring plant data at dramatically increased speeds, reducing data storage volumes, and integrating plant data with event, summary, production and configuration data. The FactorySuite™ database server leverages the open and flexible Microsoft platform to truly integrate the office with the factory floor. Production personnel can use Wonderware tools or hundreds of ‘off the shelf’ software packages to view, analyze and report on their production process.
if this is what you've got, you should be able to use ordinary SQL Server queries in any of a number of front-end tools
hey, you could even use Access, by linking to your InSQL tables