Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
tfoliveira
Regular Visitor

Is there any routine to clean up the ExecutionLogStorage table?

Hi,

I verified that the ExecutionLogStorage table is being cleared on the server, not showing all log history. I would like to know if there is any routine responsible for this, and if this can be configured.

1 ACCEPTED SOLUTION
Marcin_PL
Helper I
Helper I

Hi,

You can change it in dbo.configurationinfo table in the  ExecutionLogDaysKept field.

 

ExecutionLogDaysKept

The number of days to keep report execution information in the execution log. Valid values for this property include -1 through 2,147,483,647. If the value is -1, entries are not deleted from the Execution Log table. The default value is 60.

 

Regards,

Marcin

View solution in original post

2 REPLIES 2
v-henryk-mstf
Community Support
Community Support

Hi @tfoliveira ,

 

According to your description, ExecutionLogStorage does not show all the history. Because log entries are kept 60 days. Entries that exceed this date are removed at 2:00 A.M. every day. On a mature installation, only 60 days of information will be available at any given time. You cannot set limits on the number of rows or on the type of entries that are logged.

 

The report server execution records data about the report execution to an internal database table. The information in the table is available from the SQL server view.

For example, you can try the following code, the returned results capture a range of historical data.

Use ReportServer  
select * from ExecutionLog3 order by TimeStart DESC

vhenrykmstf_0-1635474528641.png

For more details, you can read related document.

Report Server ExecutionLog and the ExecutionLog3 View - SQL Server Reporting Services (SSRS) | Micro...


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Marcin_PL
Helper I
Helper I

Hi,

You can change it in dbo.configurationinfo table in the  ExecutionLogDaysKept field.

 

ExecutionLogDaysKept

The number of days to keep report execution information in the execution log. Valid values for this property include -1 through 2,147,483,647. If the value is -1, entries are not deleted from the Execution Log table. The default value is 60.

 

Regards,

Marcin

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.