You are not registered yet. Please click here to register!


 
 
plc storereviewsdownloads
This board is for PLC Related Q&A ONLY. Please DON'T use it for advertising, etc.
 
Try our online PLC Simulator- FREE.  Click here now to try it.

New Here? Please read this important info!!!


Go Back   PLCS.net - Interactive Q & A > PLCS.net - Interactive Q & A > LIVE PLC Questions And Answers

Reply
 
Thread Tools Display Modes
Old September 25th, 2014, 08:54 AM   #1
smakdown61
Member
United States

smakdown61 is offline
 
Join Date: Aug 2009
Location: NC
Posts: 90
Wonderware Intouch Inhibited Alarms

For those familiar with Wonderware, I'm trying to embed a list of all inhibited alarms into an intouch app. I want it to look similar to the built in Alarm Viewer. There doesn't seem to be any built in function for this but all of my Archestra tags have a .AlarmMode extension that corresponds to enabled, disabled, silenced. Has anyone tried to write a script that would be able to get modes for all tags and put them on a display?
  Reply With Quote
Old October 17th, 2014, 09:40 AM   #2
smakdown61
Member
United States

smakdown61 is offline
 
Join Date: Aug 2009
Location: NC
Posts: 90
Bumping this as still looking for an answer. Just need some kind of intouch script that will go through all tags in the Galaxy and display in a window all those with .AlarmMode = Disabled.
  Reply With Quote
Old October 18th, 2014, 04:42 AM   #3
RheinhardtP
Lifetime Supporting Member + Moderator
Australia

RheinhardtP is offline
 
RheinhardtP's Avatar
 
Join Date: Oct 2004
Location: Perth
Posts: 562
What version of System Platform do you use?I have a graphic that might put you in the right direction?
__________________
If a cluttered desk is a sign of a cluttered mind, of what, then, is an empty desk a sign?

― Albert Einstein

www.tier16.com
  Reply With Quote
Old October 18th, 2014, 08:30 AM   #4
smakdown61
Member
United States

smakdown61 is offline
 
Join Date: Aug 2009
Location: NC
Posts: 90
Quote:
Originally Posted by RheinhardtP View Post
What version of System Platform do you use?I have a graphic that might put you in the right direction?
SP version 3.0 SP1 and Intouch 10.0. I have dev systems with all versions though I can use to view it.
  Reply With Quote
Old October 18th, 2014, 12:56 PM   #5
lostcontrol
Lifetime Supporting Member
New Zealand

lostcontrol is online now
 
lostcontrol's Avatar
 
Join Date: May 2009
Location: NeverSayNever
Posts: 812
Can it not be done with the alarm client?
  Reply With Quote
Old October 18th, 2014, 02:14 PM   #6
smakdown61
Member
United States

smakdown61 is offline
 
Join Date: Aug 2009
Location: NC
Posts: 90
Quote:
Originally Posted by lostcontrol View Post
Can it not be done with the alarm client?
I don't believe so but I'm not extremely familiar with its customization options. I thought alarm client was only tied to specific alarm extensions enabled in Archestra. I'm looking for something more generic where I can specify exactly which attribute I want to query for and what value.

If it can be done in alarm client it would be great if someone could send an example of the scripting required for it to do that.
  Reply With Quote
Old October 18th, 2014, 07:22 PM   #7
RheinhardtP
Lifetime Supporting Member + Moderator
Australia

RheinhardtP is offline
 
RheinhardtP's Avatar
 
Join Date: Oct 2004
Location: Perth
Posts: 562
So the way we do it is to look at events in the WWALMDB. I then display it using a SQL grid. Not the most elegant way but it gets the information displayed.
This will return alarms that are inhibted or silenced. For this to work you need to ensure the Log Events are activated in the alarm logger. The graphic i attached already has the script inside it you will just need to change the custom property to define your SQL server and username/password.

This is the SQL query i use as you can see i look at the EventHistory View in WWALMDB.

Note this is a beta version at the moment i am not completely happy with the display it is very basic.

I developed this in System Platform 2014.

You can run the query in the WWALMDB database and it should return your results.


WITH dateorderedcommandevents AS
(
SELECT *, RNum=ROW_NUMBER() OVER (PARTITION BY [TagName] ORDER BY EventStamp DESC)
FROM dbo.v_EventHistory
WHERE [TagName] LIKE '%AlarmModeCmd'
AND [Description] LIKE '%Write success%'
)
SELECT EventStamp, LEFT(TagName, LEN(TagName) - 13) , Area, Value, Operator, OperatorNode
FROM dateorderedcommandevents
WHERE RNum=1 AND NOT Value='Enable'


The file is a bit big but if you pm me i can send it to you.(2.1MB)
__________________
If a cluttered desk is a sign of a cluttered mind, of what, then, is an empty desk a sign?

― Albert Einstein

www.tier16.com

Last edited by RheinhardtP; October 18th, 2014 at 07:30 PM.
  Reply With Quote
Reply
Jump to Live PLC Question and Answer Forum

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Topics
Thread Thread Starter Forum Replies Last Post
wonderware intouch installation and share wonderware intouch experience oscarray LIVE PLC Questions And Answers 24 June 19th, 2015 02:33 PM
Alarms and events in Wonderware Intouch, help required urgently. mundae LIVE PLC Questions And Answers 1 December 13th, 2012 12:46 PM
Wonderware Intouch nil9178 LIVE PLC Questions And Answers 2 February 9th, 2011 02:28 PM
Wonderware InTouch vs WinCC nil9178 LIVE PLC Questions And Answers 3 February 6th, 2011 03:41 AM
Wonderware Intouch Server Migration DWBENTLEY LIVE PLC Questions And Answers 1 June 22nd, 2010 04:51 PM


All times are GMT -5. The time now is 01:51 AM.


.