Skip to Content
avatar image
Former Member

alaram query

hi ,

any one explain me the alarm query with example

murali

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    May 09, 2007 at 09:48 AM

    Hi Murali,

    To be able to have an Alarm query you will need an Alarm database. Generally mostt SCADA/MES Systems have an alrm database. Alarm Queries are directed to these. An Alarm query is similar to a Tag Query in most respects and contain information of generated Alarms and the Alarm Level like High, Very High or Low, Very Low etc

    Regards,

    Arijeet

    Add comment
    10|10000 characters needed characters exceeded

  • May 09, 2007 at 11:53 AM

    The AlarmQuery will only work against AlarmSuite, which was a legacy Lighthammer software application that logged Wonderware InTouch alarms into SQLServer. Wonderware bought this application and I believe it is now incorporated into the FactorySuite.

    These types of query template have specialized modes with SQL select statements built to go against the AlarmSuite database model, so unless you have the AlarmSuite product it will not provide you with any benefit. The AlarmSummary, AlarmHistory, and AlarmStatistics can be used for analyzing alarms logged into the database, showing current status (like Hi, Lo, HiHi, LoLo, etc.), historical state changes (like Alarm, Acknowledge, Return to Normal, etc.), and statistics (like Event count, Duration, Frequency percentage, etc.).

    In an application you would typically use iGrids with color-contexting for displaying AlarmSummary and AlarmHistory modes, and an iChar in Bar or Group Bar for displaying a pareto type analysis of the alarm behavior. All queries are time based so the time refresh controls would be available to the user for navigating through specific time ranges or time periods.

    Like I mentioned before, unless you have the particular AlarmSuite product, this type of query will have no use to you or the customer.

    Best Regards,

    Jeremy Good

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 01, 2007 at 03:59 AM

    Murali,

    Any additional questions on this thread?

    Regards,

    Jeremy

    Add comment
    10|10000 characters needed characters exceeded