Personal Workspace User Quota.

We ran into a small procedural problem related to Livelink Personal Workspace. Our management believes that we need to put some control over how much space can a livelink user consume. According to my knowledge in LL and OT feedback we cannot limit the amount of space a user can consume when adding documents to his/her personal workspace. The question is how did you guys deal with this issue from a system level and are there any reports in Livelink that you know of that can give me the amount of space consumed by a user in his/her personal workspace and everything below it.

Find more posts tagged with

Comments

eLink User

Message from David Slimmon via eLinkHi there,I'm not sure what others have tried, but I can help you narrow the options down a bitand help you get to a query/queries that would be somewhat useful when attempting todetermine how much a user "owns" (in megabytes).=============================QUERY 1: TO DETERMINE USER'S ID:=============================SELECT Id FROM KuafWHERE name='X'* Where X is the login name of the user you're interested in finding out about.==================================================QUERY 1: TO DETERMINE SIZE OF THE LL OBJECTS THEY OWN==================================================SELECT sum(datasize)/1048576 "Megabytes"FROM DversDataWHERE Owner=Y** Where Y is the Id from Query 1Regards,Dave-----Original Message-----We ran into a small procedural problem related to Livelink PersonalWorkspace. Our management believes that we need to put some control over howmuch space can a livelink user consume. According to my knowledge in LL andOT feedback we cannot limit the amount of space a user can consume whenadding documents to his/her personal workspace. The question is how did youguys deal with this issue from a system level and are there any reports inLivelink that you know of that can give me the amount of space consumed by auser in his/her personal workspace and everything below it.

Geoff_Obbard

Here's a joined version of what you have that will find the most offending users (space wise).select kuaf.name, (sum(dversdata.datasize)/1048576) "Space Used (MB)" from kuaf, dversdata where kuaf.id=dversdata.owner group by kuaf.name order by "Space Used (MB)" descGeoff

eLink User

Message from David Slimmon via eLinkThanks Geoff! I'll add Geoff's to the list of sample LiveReports.ds-----Original Message-----Here's a joined version of what you have that will find the most offending users (space wise).select kuaf.name, (sum(dversdata.datasize)/1048576) "Space Used (MB)" from kuaf, dversdata where kuaf.id=dversdata.owner group by kuaf.name order by "Space Used (MB)" descGeoff

Bhupinder_Singh

Isn't there a way to incorporate the "Volume ID" into the LiveReport SQL statement, so that the calculation looks only at the personal workspace when looking at documents owned by the user, instead of just calculating of the total size of *all* documents owned by the user (which would likely include general enterprise and project workspace items, no?)...I once came across the Volume ID as a field specifying whether the item was stored in the Personal Workspace or the Enterprise workspace, but I don't remember where.

Geoff_Price

In case any one was interested, I expanded on Geoff's with this....select k.name, (sum(dv.datasize)/1048576) "Space Used (MB)", dt.OWNERIDfrom kuaf k, dversdata dv, dtree dtwhere k.id=dv.ownerand dt.ownerid=-1*k.idand dt.dataid=dv.DOCIDgroup by k.name, dt.ownerid order by "Space Used (MB)" descThis will report on only the Personal Workspace.Geoff Price

Susan_Nare_(sglcuser16a_-_(deleted))

Has anyone been able to make this work under LL9.5 using SQL Server? We had several PW reports that stopped working after we upgraded to LL 9.5 from 9.2.Kind regards,Susan