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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.