Folder Information

Heike_Steinhardt_(PDVAdmin_(Delete)_2309863)

i need a livereport, that gives information about folders size within the personal workspacethank you all

Find more posts tagged with

Comments

Rob_Perry_(Disabled)_(mitra01admin_-_(deleted))

Bhupinder Singh posted a query in another thread that works well for me:select c.id, c.name, c.firstname, c.lastname, sum (b.datasize)/1048576 "Personal Folder Size in MB" from kuaf c, dtree a, dversdata b where c.groupid is not null and c.deleted = 0 and a.ownerid = -(c.id) and a.parentid >= c.id and a.dataid = b.docid group by c.id, c.name, c.firstname, c.lastname order by sum (b.datasize)/1048576 desc

Heike_Steinhardt_(PDVAdmin_(Delete)_2309863)

thanks for this really good LR. But i need something like a list of folders with sizes within the personal WS. I don't need a LR for all users, only for the actual user.best regardsalbecht