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
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
-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