AnsweredAssumed Answered

Generate Alarm and Event reports using RtReports

Question asked by SrinathG on Jun 2, 2019
Latest reply on Nov 22, 2019 by afaulkner

Hi,

 

I am working on a time based report which should generate a daily report of all the alarms and events that got generated in the last 24 hours.

 

And the format of the report that I am trying to achieve using RtReports is as below,

 

DateTime

TagName

Message

UserID

Duration

29-May-19 07:57:49

Test_Alarm

Room 1414 High High Temperature Alarm for TT-1414-01

 

 

29-May-19 07:59:10

Test_Alarm

Acknowledged alarm [Room 1414 High High Temperature Alarm] in alarm server [RNA://$Global/bluebird_bio_scafa_rev02:Alarm_area_rev01]

 CORP\KIRAN.BHAGAVTHULA

 

29-May-19 08:01:35

Test_Alarm

Room 1414 High High Temperature Alarm for TT-1414-01

 

00:03:46

30-May-19 00:00:00

Test_Alarm

Room 1414 Low Low Temperature Alarm for TT-1414-01

 

 

30-May-19 01:30:00

Test_Alarm

Acknowledged alarm [Room 1414 Low Low Temperature Alarm] in alarm server [RNA://$Global/bluebird_bio_scafa_rev02:Alarm_area_rev01]

 CORP\KIRAN.BHAGAVTHULA

 

30-May-19 08:00:00

Test_Alarm

Room 1414 Low Low Temperature Alarm for TT-1414-01

 

08:00:00

28-May-19 23:00:00

Test_Alarm_1

Room 1400 Low Low Temperature Alarm for TT-1400-01

 

 

28-May-19 23:30:00

Test_Alarm_1

Acknowledged alarm [Room 1400 Low Low Temperature Alarm] in alarm server [RNA://$Global/bluebird_bio_scafa_rev02:Alarm_area_rev01]

 CORP\JOHN.SMITH

 

29-May-19 10:00:00

Test_Alarm_2

Room 1300 Low Low Temperature Alarm for TT-1300-01

 

 

29-May-19 12:00:00

Test_Alarm_2

Acknowledged alarm [Room 1300 Low Low Temperature Alarm] in alarm server [RNA://$Global/bluebird_bio_scafa_rev02:Alarm_area_rev01]

 CORP\ANDREW.JOHN

 

29-May-19 13:25:00

Test_Alarm_2

Room 1300 Low Low Temperature Alarm for TT-1300-01

 

03:25:00

29-May-19 10:30:00

Test_Alarm_3

Room 1500 High High Temperature Alarm for TT-1500-02

 

 

29-May-19 11:55:53

Test_Alarm_3

Acknowledged alarm [Room 1500 High High Temperature Alarm] in alarm server [RNA://$Global/bluebird_bio_scafa_rev02:Alarm_area_rev01]

 CORP\JOHN.SMITH

 

29-May-19 12:15:01

Test_Alarm_3

Room 1500 High High Temperature Alarm for TT-1500-02

 

01:45:01

 

Source for Alarm and Event data to PI is SQL Server via PI Interface for RDBMS. The data in PI is being stored as a string type and is separated by a delimiter "|". 

For example, Message and UserID columns from the above table are stored in a single tag separated by “|” and in RtReports I have used ParseString function to display those values in different columns.

 

Please find the attached screenshot for a better understanding of data flow.

 

I am able to retrieve DateTime, Message and UserID columns using RtReports. But, I am unable to get Tagname and Duration details.

 

Can someone please help me out in achieving this? I am okay if the results can be achieved in a different format also.

 

Regards,

Srinath@#

Outcomes