Page History

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

Configure Storage Location

Step 1: Configure Storage Location

1. Optional (You can the default TagHistorian DB)

1. Navigate to Historian → Storage
2. 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

Create Historian Tables

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

Process Data:

• Name: ProcessData
• Type: Continuous
• Storage: 1 second resolution
• Retention: 90 days
• Compression: Deadband

Production Counters:

• Name: Production
• Type: Counter
• Storage: On change
• Retention: 365 days

Configure Tags for Logging

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

Analog Value:

• Tag: TagFarm/Tank1_/Temperature
• Table: ProcessData
• Deadband: 0.5
• Rate: 10 seconds

Digital Value:

• Tag: Motor1_RunningTagFarm/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 control 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: Motor1_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

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

Step 7: Create Reports

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

Step 8: 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
Step 9: 
Test Historian
Start Runtime
Let run for few minutes
Open trend display
Verify:
Data logging active
Trends updating
Historical data visible
Zoom/pan working
Performance Optimization
Log only necessary tags
Use appropriate deadbands
Consider table partitioningRegular index maintenancemultiple historian table with distinct triggers
Monitor disk space
Best Practices
Plan retention requirements
Use multiple tables for different data types
Set appropriate logging rates
Regular backups
Document data retention policy
Next Steps
[Create Dashboards] - Historical KPIs
[Reports Module] - Automated reports
[Datasets Module] - SQL analysis

In this section...