FactoryTalk View SE Alarm Log

Good day,

I would like to extract the FT View SE Alarm Log. We currently have got a Excel spreadsheet set up with a connection to the FTAE SQL Database.
When I refresh the data, Excel give an error telling me that the data is more than what can be displayed in a spreadsheet. So it then discards the latest data. I have tried setting a database limit in the Factory Talk Administration console to only keep the last 60 days worth of data but it does not seem to take effect. I get data from January 2017. Is there a way to configure the ODBC connection in excel to only give me the data for the last 30 days or is there someone that can help me to limit the size of the database?

I have attached the current connection config.

Just use SQL Management Studio to purge old records manually. Or set up a SQL Job to do it periodically. Relying on FactoryTalk to purge old records is at best a 40/30/30 chance. 40% it works, 30% it doesn't, and silently, and 30% that it just corrupts the database entirely.

Yes, you can edit the connection string to select based on eventtimestamp. I have this at the office, but won’t be back in until the 6th