Solved

How do I get a report on SharePoint sites " last accessed" and " last created "

Posted on 2010-08-20
9
2,996 Views
Last Modified: 2012-08-13
I am trying to build a report on my farms site usage. I would like to get a report that can show me all the webs under a site collection, when they were created and last accessed.
0
Comment
Question by:snazaire
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
  • 2
9 Comments
 
LVL 5

Expert Comment

by:screen-name
ID: 33485391
Being unsure of your situation, My suggestions would be to use powershell and create a script to generate the information you want, or use a 3rd party tool like Nintex reporting.

What would need to know to provide anymore detail is,

1. What version of SharePoint are you using? wss3, moss2007, moss2010???
2. What level of access do you have? Are the Farm admin? Site owner? Site collection admin?

There is also the built in usage reporting, but I am not sure if it will provide the info you are wanting.

Here is a link to explain the built in usage reports http://blogs.msdn.com/b/markarend/archive/2008/09/06/moss-usage-reports-explained.aspx

0
 
LVL 43

Accepted Solution

by:
zephyr_hex (Megan) earned 167 total points
ID: 33486982
i believe CardioLog has that info in their reports.  for whatever reason, i can't access their web page right now...

anyway...
Sharepoint Designer also has some usage reports available... you might look at those as well:
http://office.microsoft.com/en-us/sharepoint-designer-help/use-reports-to-measure-site-performance-and-usage-HA010174136.aspx
0
 

Author Comment

by:snazaire
ID: 33558452
Hi,
I am really sorry it took me so long torespond to your replies. I have actually visited both links that were provided but could not find what I was looking for. It seems that a lot of those reports are user and files-based. What I am looking is something moore specific on the last time a site was accessed, so we can determine whether or not to kill the site for inactivity.
0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
LVL 43

Expert Comment

by:zephyr_hex (Megan)
ID: 33580702
you can enable and parse IIS logs.
0
 
LVL 5

Assisted Solution

by:screen-name
screen-name earned 333 total points
ID: 33582269
0
 
LVL 5

Expert Comment

by:screen-name
ID: 33582285
oops, sorry wrong question.  

Yes Parsing the IIS logs is going to be what you are looking for I think...


Check this tool out...

http://www.lizard-labs.net/PageHtml.aspx?lng=2&PageId=18&PageListItemId=17

0
 

Author Comment

by:snazaire
ID: 33725873
Where can get the IIS log file please?
0
 
LVL 5

Expert Comment

by:screen-name
ID: 33726014
0
 
LVL 5

Assisted Solution

by:screen-name
screen-name earned 333 total points
ID: 33726058
You could also query the SQL DBs,

Look in the content DBs, and look at dbo.sites, and dbo.webs, there are attributes for lastaccessed, and modified, and what not.

0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question