Trouble getting all data from native History funtion

Ignition
, ,
1

Hello,

I'm having a problem with the tag history and audit features.

What I'm trying to do is to create a view with a simple table and custom filter that will allow the users to visualize every change on the application, that means every tag change from the user or from the OPC tag, audit action,...

I've tried to do that with the native function of Ignition with the Tag History property, by getting all the data with a Tag History binding, but I think there is too much data; the CPU is overwhelmed and I end up restarting the gateway every time.

The table should look like this, with every user action + tag change from users or from OPCtag

image
image1198×184 7.88 KB

Is there a way to get all the data from the native Tag History function so that I could display all the History and Audit data together?

Or maybe, is it possible to store on the Audit every tag change? Included from OPCTag that we receive?

The data are supposed to be stored for 6 months and I need to be capable of filtering from that data on the table view directly, I can't just limit the data on the table if I want to be able to do that

Thanks

2

How many rows of data are you expecting to be returned? Are you trying to load more data into memory than Ignition has available?

3

This is an unrealistic expectation. You should substitute a zero-length timespan any time the selected timespan is too large for your system to handle (determined experimentally).

Consider using a short tag history time window of 5 minutes before and after a selected audit event.