21.2.6         Analog Change Log

This shows a centralized database for all Analog Tags, with Analog Change Log enabled, for all SCADA Nodes and all Projects.

The individual tags must have both Analog Change Log enabled and the values must exceed the Analog Change Log Dead Band to be logged.

From the Project Manager, Project Users call the Analog Change Log from the 'Project Home' page.

Power Users can also call this Log from VIEW using the Tools menu:
Right Click -> Tools -> Analog Change Log

All Users can call this Log from ViewDAQ using the menu bar:
Tools -> Analog Change Log

The data can be sorted and filtered by Tagname, Date, Project, and SCADA Node.  

Use the CTRL key to select multiple project names, nodes or tag names. 

Use SHIFT key to select a range of project names, nodes or tag names.

An optional Tag Name Patterns field isto let users search for patterns using wildcard characters when “All Tags” is highlighted. The wildcard characters are database dependent (.e.g Access, SQL Server, Oracle, MySQL) used to store ODBC data. For an Access database, use % (percent symbol) to match any number of characters and _ (underscore) to match any single character.

An HTML report is displayed .

The HTML report displayed can be copied and pasted into EXCEL, WORD and other office applications preserving the cell, column and other formatting.

Data can be exported to EXCEL  (VIEW and ViewDAQ to EXCEL 2000 or later, the Project Manager requires EXCEL 2002 or later).  See 21.3.2 Export to EXCEL from ODBC Log

The default number of records per page for log displays is up to 600.

The display used is bwchglog.uti.

BwAnaChglog : Data log for Analog tag

a. ProjNodeId : Unique ID for a SCADA node.

b. TagName : Tag Name.

c. LogDate : Date of  the record was recorded.

d. LogTime : Time of the record was recorded.

e. LogMillisecond: Millisecond of the record.

f. LogValue: Value of the recording period.

g. MinValue: Minimum value of the recording period.

h. Alarm: If the tag is in alarm during the recording period.

-2147483648 (Decimal) or  0x80000000 (HEX) means there is  no data during the minute of collection.  Otherwise, the value of this field is a LOGICAL OR of all the Alarms that occurred during the interval.

Alarm Code    Alarm Code   Description
Decimal           Hex

-2147483648   0x80000000   no data during the minute of collection.

                2   0x02            Acknowledged Alarm

                4   0x04            High High Alarm

                8   0x08            High Alarm

               16  0x10             Low Alarm

               32  0x20             Low Low Alarm

               64  0x40             Rate of change Alarm

              128  0x80            High Deviation Alarm

              256  0x100           Low Deviation Alarm