Useful reports for housekeeping and cleanup?

Carey_Moore_(pmuser36_-_(deleted))

What reports do you find the most useful for "housekeeping" - identifying inefficient usage or where best practices are not being followed; periodically identifying items to be deleted, restructured, archived, etc.?Please reply to this thread or privately to Robin.A.Hilp@pmusa.com (and I'll summarize).ThanksRobin Hilp

Simon_Beal

Message from Sean O'Callaghan via eLinkI find these reports quite useful....This displays objects with more that 200 subitems (in the root of thecontainer)select %1 from dtree where childcount > '200' and %2 order by childcountdesc%1 = report fields%2 = filter PermsThis one shows the 25 documents with the most versions (these may not berequired and can be a pain if you need to reindex)select %1, DVersData.MimeType, count(*) "count(*)" from DTree, DVersDatawhere %2 and (DTree.DataID = DVersData.DocID) and (%3) group by %1,DVersData.MimeType order by count(*) desc%1 = report fields%2 = filter docs%3 = filter permsThis one is useful for check public access rights (we don't use publicso we do spot checks)select Dataid, name , Wpermissions, ownerid from dtree whereWpermissions > '128' and Wpermissions < '16777215' and subtype = %1order by name%1 = object typeAnd finally.......this one lists all users on your system how have notbeen deleted and who have "login enabled"select a.name "Login", a.Firstname, a.Lastname, b.Name "DepartmentGroup" from kuaf a, kuaf b where a.userprivileges <> '14'and a.GroupID =b.id and a.groupid is not NULL and a.deleted <> '1' order by a.namePs. Try an autolivereport.Hope these are helpful,Sean-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: 28 September 2004 19:14To: eLink RecipientSubject: [Maybe Spam] Useful reports for housekeeping and cleanup?Useful reports for housekeeping and cleanup?Posted by Hilp, Robin on 09/28/2004 02:11 PMWhat reports do you find the most useful for "housekeeping" -identifying inefficient usage or where best practices are not beingfollowed; periodically identifying items to be deleted, restructured,archived, etc.?Please reply to this thread or privately to Robin.A.Hilp@pmusa.com (andI'll summarize).ThanksRobin Hilp[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********************************************************************************This e-mail is confidential to the ordinary user of the e-mail addressand may also be privileged. If you have received it in error, pleasenotify us immediately by reply e-mail and then delete this message fromyour system. Please do not copy it or use it for any purposes, or disclose its contents to any person. Please contact our IT Departmenton +44 (0) 020 7592 0600 or e-mail at it@angeltrains.com if you needassistance. Angel Trains Limited - Portland House Stag Place VictoriaLondon SW1E 5BH Tel: 020 75920500 Fax: 020 75920519 Registered in England No 2912655www.angeltrains.com**********************************************************************************