Page History

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

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

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?
• Storage: On change
• Retention: 365 daysAuto Create: ?

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_Produced
• Table: Production
• Type: Counter/Totalizer

Create Trend Display

1. Open Displays → New
2. Add TrendChart page
3. Configure:

Basic Setup:

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

Add Pens:

• Pen 1: TankFarm/Tank1/Temperature (Blue)
• Pen 2: TankFarm/Tank1/Pressure (Red)
• Pen 3: TankFarm/Motor/Running (Green, digital)

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

• Production/Production_Count
• Table: Production

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

Performance Optimization

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

Next Steps

• [Create Dashboards] - Historical KPIs
• [Reports Module] - Automated reports
• [Datasets Module] - SQL analysis

In this section...