SOLVED

What is happening under the covers in SSRS when you delete a history snapshot?

Copper Contributor

In SSRS, when you delete a history snapshot, what is really happening on the server? 

RichUchytilWork_2-1693406424459.png

 

Is it running the stored procedure DeleteHistoryRecord? If so, is it doing anything else? We're looking to programmatically delete history snapshots older than X days and want to make sure we don't miss anything. We thought the easiest way to do it would be to do the same thing that happens when you delete a history snapshot through the web interface.

Thanks!

1 Reply
best response confirmed by RichUchytilWork (Copper Contributor)
Solution

We thought the easiest way to do it would be to do the same thing that happens when you delete a history snapshot through the web interface.


@RichUchytilWork , then do that: Calling the SSRS web API, see

Develop using REST APIs - SQL Server Reporting Services (SSRS) | Microsoft Learn

1 best response

Accepted Solutions
best response confirmed by RichUchytilWork (Copper Contributor)
Solution

We thought the easiest way to do it would be to do the same thing that happens when you delete a history snapshot through the web interface.


@RichUchytilWork , then do that: Calling the SSRS web API, see

Develop using REST APIs - SQL Server Reporting Services (SSRS) | Microsoft Learn

View solution in original post