A list of projects sorted by modification date

Nina_Lewau_(sablinadmin_-_(deleted))

We have a need for deleting/archiving a lot projects that have not been accessed/modified for a long time. IT's quite time consuming to chase all the Coordinators to have them deleting or archiving their projects, and above all it's not easy to see which projects that should be archived.But, we're not sure on how to do this, anyone who know how to do a LiveReport that resturns a list of all projects, sorted by the date that an object within the project last was modified?Thanks

Filippo_Bianchini_(x-fbianchini_-_(deleted))

Message from Filippo Bianchini via eLinktry this liveReportselect %2, DTree.ModifyDate from DTree DTree, DTree b where(DTree.DataID=b.OwnerID) and %1 group by %2, Dtree.ModifyDate order byDtree.ModifyDatewhere %1 is Filter Projectand %2 is Report Fields-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: lunedì 23 agosto 2004 09:07To: eLink RecipientSubject: A list of projects sorted by modification dateA list of projects sorted by modification datePosted by Englund, Nina on 08/23/2004 03:03 AMWe have a need for deleting/archiving a lot projects that have not beenaccessed/modified for a long time. IT's quite time consuming to chase allthe Coordinators to have them deleting or archiving their projects, andabove all it's not easy to see which projects that should be archived.But, we're not sure on how to do this, anyone who know how to do aLiveReport that resturns a list of all projects, sorted by the date that anobject within the project last was modified?Thanks[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 "Questo messaggio ed ogni suo allegato sono confidenziali e possono essere riservati o, comunque, protetti dall'essere diffusi. Se il ricevente non é il destinatario diretto del presente messaggio, è pregato di contattare l'originario mittente e di cancellare questo messaggio ed ogni suo allegato dal sistema di posta. Se il ricevente non é il destinatario diretto del presente messaggio, sono vietati l'uso, la riproduzione e la stampa di questo messaggio e di ogni suo allegato, nonché la diffusione del loro contenuto a qualsiasi altro soggetto" "This message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, please contact the sender and delete this message and any attachment from your system. If you are not the intended recipient you must not use, copy or print this message or attachment or disclose the contents to any other person."