#1 2018-02-13 02:07:29

shivasakthi18
Member
Registered: 2018-02-13
Posts: 2

file purging via SQL queries or API

Hi,

The main issue with report server is arising when there is storage of large volume of files. So I am trying to delete files from team space periodically.

Following is the step i am following now.

delete from RS_EXEC_REPORT_AS_FILE_REF where id=?;
delete from RS_TS_DISK_GENERAL_REFERENCE where id=?;
delete from RS_TS_DISK_NODE where entity_id=?;
delete from RS_COMPILED_REPORT where entity_id in (?);

Is there any other good way to do it ....?

Thanks,
Sivasakthi.

Offline

#2 2018-02-13 07:59:09

eduardo
Administrator
Registered: 2016-11-01
Posts: 522

Re: file purging via SQL queries or API

Hi Sivasakthi,

you should not delete/modify data directly with SQL, as you may miss dependencies. Only reportserver and/or reportserver scripting should be used for this purpose. In the contrary, this may have unexpected results. Check the scripting guide for this: https://reportserver.net/en/guides/script/main/
You may also want to check the API documentation downloadable from https://sourceforge.net/projects/dw-rs/files/src/3.0/. There, you can find a list of services, a list of entities and a list of hooks along with the javadocs.

Regards,
Eduardo

Offline

#3 2018-02-13 08:07:18

shivasakthi18
Member
Registered: 2018-02-13
Posts: 2

Re: file purging via SQL queries or API

Hi Admin,

It's a useful information, Can somebody help me to delete all CSV file older than 1 or 2 days...?

Thanks,
Sivasakthi.

Offline

Board footer

Powered by FluxBB