Livereport to get total size occupied by a project(including all subprojects)

Cisco_Developer_(ciscouser2_-_(deleted))

I want an Livereport which shall provide me details of the space occupied by a project which includes all the subprojects,folders and other container objects in the project folder.I am able to get space occupied by a project and its folders but not the subprojects.has anaybody done such Livereport?Thanks

Bhupinder_Singh

Message from Bhupinder Singh via eLinkThe knowledge base article I put together below should help. The SQL was provided by Alex Kowalenko of Open Text.- Bhupinder------------------------------------------------------------------------- Bhupinder Singh, B.Math., B.Ed. Senior Product Specialist, Customer Support Open Text Corporation, Waterloo, Ontario, Canada Customer support e-mail: support@opentext.com Customer Support Telephone: 800-540-7292 ------------------------------------------------------------------------- Article Title:How can we determine which Livelink Projects are taking up the most physical space, in terms of document storage?Article Summary:To determine which projects occupy the most physical space, users can run a LiveReport that ships with core Livelink, called"Largest Projects (Physical Space)". The only problem, however, is that it will not include sub-projects when displaying the totalsize of a specific project. This article provides an alternate solution that does include sub-projects, and projects withinsub-projects, etc., in the total for any given project.Article Details:The "Largest Projects (Physical Space)" LiveReport that ships with Livelink 9.2 is: select %1, sum(c.DataSize) "sumdata" from DTree DTree, DTree b, DVersData c where %2 and DTree.DataID=b.OwnerID and b.DataID=c.DocID and %3 group by %1 order by sum(c.DataSize) desc Param %1 : Report Fields Param %2 : Filter Projects Param %3 : Filter Permissions Additional Display Columns: Field: sumdata Column Title: Space Occupied (bytes) The "Largest Projects (Physical Space)" LiveReport uses the fact that document DTree rows within a project have OwnerID equal to theDataID of the project. This query is quick, easy and needs no hierarchy traversal. To extend this to include sub-projects one needsto traverse a hierarchy of sub-projects. The LiveReport below, which you can create and save as "Largest Projects (Physical Space)with SubProjects", does this but for Oracle only. A Microsoft SQL Server variant would need to use a stored procedure that does thehierarchy traversal.select %1, sum(c.DataSize) "sumdata" from DTree DTree, DTree b, DVersData c where %2 and b.OwnerID in ( select s.DataID from DTree s where %2 start with s.DataID = DTree.DataID connect by prior DataID = ParentID ) and b.DataID=c.DocID and %3 group by %1 order by sum(c.DataSize) desc Param %1 : Report Fields Param %2 : Filter Projects Param %3 : Filter Permissions Additional Display Columns: Field: sumdata Column Title: Space Occupied (bytes) Edited by Bhupinder Singh, Senior Product Specialist, with LiveReport provided by Alex Kowalenko, Lead Consultant, Open Text.Please direct questions to support@opentext.com and not to the authors.-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Monday, June 07, 2004 8:32 AMTo: eLink RecipientSubject: Livereport to get total size occupied by a project(including all subprojects)Livereport to get total size occupied by a project(including all subprojects) Posted by Developer, Cisco on 06/07/2004 08:31 AMI want an Livereport which shall provide me details of the space occupied by a project which includes all the subprojects,foldersand other container objects in the project folder.I am able to get space occupied by a project and its folders but not the subprojects.has anaybody done such Livereport?Thanks [To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server: https://knowledge.opentext.com/knowledge/livelink.exe