How to query Spotfire server database for top 5 high volume data reports

[HITESH SAHOO]

Hi Guys,

New to Spotfire Admin, I have client requirement to find top 5 reports that use high volume of data.

So, How can I find this from Spotfire Database.

Please help

 

Thanks in Advance.

[Harshith Reddy Musku]

Use the following query(example for Oracle) to list top 5 reports based on content size

SELECT * from(select Li.Title,li.content_size from LIB_ITEMS LI INNER JOIN LIB_ITEM_TYPES LIT on LI.ITEM_TYPE=LIT.TYPE_ID where LIT.label = 'dxp' order by LI.content_size desc) where ROWNUM

[HITESH SAHOO]

Hi Harshith, 

 

Thank you so much for your answer.... 

 

But above query tells me about content size.... What I need total size of loading data tables in each reports. 

 

Suppose I am opening a report, it shows me like 750mb SBDF data loading(for data table 1), then 235mb SBDF data loading(for data table 2)..... so i need total size for both data table for that report. 

 

Please let me know.