Wonderware Historian 10.0 Event tag email

LogicON

Member
Join Date
Apr 2008
Location
mayo
Posts
44
I am trying to Configure Database Mail for a Historian Event, I'm using historian 10.0.
I am running Microsoft SQL server 2008 on windows server 2003 R2.
I setup the database mail using WW Tech Note 551, however point 8 - " Select the Private Profiles tab and change the user name to NT Autority\SYSTEM."

Was differnet in that I only had the following user name options
- ##MS_PolicyEventProcessingLogin##
- ##MS_PolicyTsqlExecutionLogin##
- MS_DataCollectorInternalUser

When I run a Query with the script below in Microsoft SQL Server Management Studio, the email works correctly, However when I copy the script to action Generic SQL in the historian Event tag it does not work.

The Generic SQL script is:

Set Quoted_Identifier OFF
declare @AnalogValue float
declare @BodyTxt varchar (1000)

set @AnalogValue = (select Value from INSQL.Runtime.dbo.AnalogLive where TagName = 'Viaflo_Tank08_level_LCD-05') set @BodyTxt = Current level = '+ cast(@AnalogValue as varchar)+' KG.


EXEC msdb.dbo.sp_send_dbmail @profile_name="InSQLMail",
@recipients="name@email.com",
@subject='Tank 8 High level alarm',
@body=@BodyTxt".
 
i am using Wonderware software, how to change its time, when im changing time data base error is coming
and db connection error is also coming
 
Last edited:

Similar Topics

Hi, We are setting up an Aveva Plant SCADA node with the intention to connect it to a Wonderware Historian node. Everywhere I look online I see...
Replies
1
Views
120
So I'm trying to make a tag I created in WonderWare Historian display the correct tag values on the inTouch client but it is currently showing...
Replies
12
Views
1,471
Hello there, Our plant is running Wonderware Historian on a Virtual Server and every few days I'm losing comms to my PLCs. Usually I can simply...
Replies
3
Views
2,030
Hi all, I found some interesting issue from my Wonderware environment. At my Trend table option, if i select "both", the Trend table is not...
Replies
2
Views
3,629
Hello, I want to monitor Wonderware historian's heartbeat and trigger a fault if Historian is not communicating /offline in PLC. Currently my...
Replies
0
Views
776
Back
Top Bottom