Hi All, Latest requirement of my client is to give list of docuemts and its usage on our MOSS2007 SP2 site. I tried sql query SELECT tp_DirName, tp_LeafName, tp_Version, tp_Modified, tp_Created FROM AllUserData WHERE (tp_ContentType = 'Document') AND (tp_LeafName NOT LIKE '%.css') AND (tp_LeafName NOT LIKE '%.jpg') AND (tp_LeafName NOT LIKE '%.png') AND (tp_LeafName NOT LIKE '%.wmf') AND (tp_LeafName NOT LIKE '%.gif') AND (tp_DirName NOT LIKE '%Template%') AND (tp_IsCurrentVersion = 1) AND (tp_LeafName NOT LIKE '%.xsl') ORDER BY tp_SiteId, tp_ListId, tp_DirName, tp_LeafName, tp_IsCurrentVersion DESC but it is not giving me list of docs which has not been clicked by any users at all! Also the way to archive it at third place. any Out of the box or db solutions please!Srivast

Hi Srivast, You can use Audit Log Reports > Content Viewing to check number of hits per documents / items. and to achieve document archive you have to enable Information Management Policy on the perticular document library. Create a designer workflow to copy / move items from one doc lib to other and then go to Information Management Policy settings Please refer - http://sharepointpratik.wordpress.com/2010/09/17/how-to-upload-a-document-to-multiple-document-libraries-simultaneously/ to create a designer workflow to move document from one to other doc lib. Enable Document Expiration and select time period after which you want to archive the document. Select Start this workflow and select the designer workflow you have created to move documents which will move the documents after some time to destination document library. hthWarm Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/

Thanks Vyas. I tried it but problem is that this process will help me on document library level and I would need to go to each document library manually to perform the action...huge number I have !! Also when I enable this policy today, it will give "item view" data only from today..i need historical data as well. need to figure out documents not even viewed after creation. (priority concern) any clue?Srivast