SubscriptionHistory Table Entries

[Anonymous]

Dear Team,

I started to use SubscriptionHistory Table to build a Report for Scheduled Refresh Overview but found that it's not a complete history table respecting gobal ExecutionLog settings from instance.

During tests I've found expected that only 10 entries will remain per report and if you want to create a history for last days where report was refreshed several days a day a value of 10 isn't enough.

I've also found where hard coded delete entry is listed:

StoredProcedure [dbo].[AddSubscriptionHistoryEntry]

As you can see all entries but last 10 will be removed from table when SP is executed.

I've moved to using ExecutionLogStorage table to get all nexessary information for report.

Many thanks

Daniel