LiveReport to return Folder size and object count

[brettsanders]

I am looking for a Livelink LiveReport to return a folder size and object count for a specified location in Livelink. I have performed a migration from one instance to another and im trying to find a way to compare the two to make sure I have an exact copy.

I did find that greggriffith had a module on his website, but was only windows compatable, not unix. Thanks for any feedback.

 

[appnair]

The objects inside a folder can be easily determined by using an aggregate function of the database in qn.
if this was oracle one could write

select count(*) from dtree start with dataid= <the id of the folder> connect by prior dataid=parentid.

SQl server does not have a tree walk algorithm like oracles connect by,so one has to write a function or stored proc to emulate it.There should be samples of this vailable in OT KB or in any sqlserver forum

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

 

[brettsanders]

Thanks for the quick reply... can i run this in a livereport? This is an oracle database, however I dont have a database user account

 

[ggriffit]

you can run the SQL as a LiveReport, but I would run it out of hours as it could be database intensive if you are looking at anything more complex than a simple folder with a few items in it.

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/

 

[brettsanders]

i got it thanks. Now if I just had the folder size.

 

[appnair]

I really wish I had time to help but the info you are looking for is already in your livelink.access the reports link from your personal menu and get into live reports.Inside there is acanned report saying which project has the most space,you could pretty much tweak that report to get your data from dversdata.clue every version object is in that table and dtree.dataid is dversdata.docid

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937