File size query

Dave_Ebels_(jocoadmin_-_(deleted))

I am running Livelink 9.0.0.1 ON HPUX v11 (an 8 processor mega box), Oracle dB, and external doc store. I have, and run a Livereport that returns the names and sizes of files contained in any object, starting with the object ID of the parent and including any child containers therein. This report is very useful in keeping track of how much “stuff” my users have in the system. I have a couple of departments that I track on a weekly (some times daily) basis so I can pan and budget for disk I will have to add to my system. The SQL for the Livereport is ,,,SELECT distinct a.Name,b.DataSize,a.createdate FROM DTree a,DVersData b WHERE a.DataId in(select DataId from DTree start with DataID=%1 connect by prior DataID=abs(ParentID)) AND a.DataId=b.DocIdThere is one user input (number type) which is the object ID I’m examining, and the report format is Auto Live Report. Often, this query will time out, returning nothing but the webserver error screen. I realize the SQL is recursive, but I am not sure how I can accomplish what I want any other way. As long as the Livelink structure I am examining is not too big (2000 or so files) this works great, but much larger, it times out. Does anyone have any suggestions? Feel free to try the Livereport as I have described it, because it is useful in and of itself.Dave Ebels, Johnson Controls, Holland, Michigan. Dave.j.ebels@jci.com

Magnus_Salgo_(IDNordicAdmin_(Delete)_2300172)

RegardsMagnus@ids.se