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

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.
snazaireSharePoint AdminAsked:
Who is Participating?
zephyr_hex (Megan)Connect With a Mentor DeveloperCommented:
i believe CardioLog has that info in their reports.  for whatever reason, i can't access their web page right now...

Sharepoint Designer also has some usage reports available... you might look at those as well:
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

snazaireSharePoint AdminAuthor Commented:
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.
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

zephyr_hex (Megan)DeveloperCommented:
you can enable and parse IIS logs.
oops, sorry wrong question.  

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

Check this tool out...

snazaireSharePoint AdminAuthor Commented:
Where can get the IIS log file please?
screen-nameConnect With a Mentor Commented:
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.