Page History

Configure historian tags and test with historian monitor trend chart.

Tutorials → Historian | Tutorial| How-to Guide | Reference

Historian → Tutorial | Concept | How-to Guide | Reference

Configure Storage Location

1. Optional (You can the default TagHistorian DB)
2. Navigate to Historian → Storage
3. Configure database:

Default SQLite (Development):

• Type: SQLite
• Path: Default or custom
• File Size: 1GB per file
• Auto-create: Yes

SQL Server (Production):

• Type: SQL Server
• Server: SQLServer\Instance
• Database: FrameworX_History
• Authentication: Windows/SQL

1. Create Historian Tables

1. Go to Historian → Historian Tables
2. Create tabletables:

Process Data:

• Name: ProcessDataType
• Save On Change: Continuous
• Storage: 1 second resolution
• Retention: 90 days
• Compression: DeadbandAuto Create:

Production Counters:

• Name: ProductionType
• Save On Change: Counter
• StorageAuto Create: On change
• Retention: 365 days
• 

2. Configure Tags for Logging

1. Navigate to Historian → Historian Tags
2. Add tags to log:

Analog ValueProcess Data:

• Tag: TagFarm TankFarm/Tank1/Temperature
• Table: ProcessData
• Deadband: 0.5
• RateRateOfChange: 10 seconds

Digital ValueProduction Data:

• Tag: TagFarm/Tank1/MotorRunning
• Table: ProcessData
• Log: On change only

Production Count:

• Tag: Units_ProducedProduction/Production_Count
• Table: Production
• Type: Counter/Totalizer

Create Trend Display

Basic Setup:

• Duration: 1 hour
• Update: 1 second
• X-Axis: Time
• Y-Axis: Auto-scale

Add Pens:

3

Configure Trend Features

Time Navigation:

• Enable pan and zoom
• Add time selector
• Quick ranges: 1hr, 8hr, 24hr, 7 days

Analysis Tools:

• Cursors for value reading
• Min/Max/Average display
• Export to CSV

Query Historical Data

Using SQL queries:

sql

SELECT Timestamp, TagName, Value 
FROM ProcessData
WHERE TagName = 'Tank1_Temperature'
  AND Timestamp > DATEADD(day, -7, GETDATE())
ORDER BY Timestamp

Using Scripts:

csharp

DataTable history = @Historian.GetData(
    "Tank1_Temperature",
    DateTime.Now.AddDays(-7),
    DateTime.Now,
    1000  // Max points
);

Create Reports

1. Reports → New
2. Add data source:
   • Type: Historian Query
   • Tags: Select multiple
   • Period: Shift/Day/Month
   • Aggregation: Average, Min, Max

Storage Management

Configure data management:

Compression:

.

Archiving:

• Archive after: 30 days
• Archive location: Network path
• Compression: ZIP

Purging:

• Auto-purge: After retention period
• Manual purge: By date range

Test Historian

1. Start Runtime
2. Let run for few minutes
3. Open trend display
4. Verify:
   • Data logging active
   • Trends updating
   • Historical data visible
   • Zoom/pan working
5. (change tags values manually using PropertyWatch)
6. Go to Historian → Historian Monitor
7. Add both tags to the trend and see the values based on the time

4. Performance Optimization

• Log only necessary tags
• Consider multiple historian table with distinct triggers
• Monitor disk space

Next Steps

In this section...