Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2007
    Posts
    3

    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?

    any help would be appreciated.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    InSQL?
    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
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jul 2007
    Posts
    3
    So your saying that the data I am looking for is already being stored in the SQL database?

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    not saying, guessing

    is that, in fact, the product you are using? then yes
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Jul 2007
    Posts
    3
    Yes, this is the product I am using. It comes with a program calle d"Activefactory" that has a number of programs for trending, querying, and creating reports. I guess i could just start there.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •