Hi,

can anyone help me out with finding last accessed date and user name for the sites in sharepoint 2007? sql db query on content databases will be helpful or any powershell script.

Thanks

Bhism

Did you check these links?

http://blogs.msdn.com/b/varun_malhotra/archive/2010/05/12/moss-2007-get-last-accessed-date-for-a-site.aspx

https://pyaarey.wordpress.com/2012/11/17/find-unused-sites-based-on-last-accessed-date/

https://sharepointrevealed.wordpress.com/2013/04/10/sql-query-to-determine-last-access-dates-to-sharepoint-sites/