• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3865
  • Last Modified:

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.
0
snazaire
Asked:
snazaire
  • 5
  • 2
  • 2
3 Solutions
 
screen-nameCommented:
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
 
zephyr_hex (Megan)DeveloperCommented:
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
 
snazaireAuthor Commented:
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
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 
zephyr_hex (Megan)DeveloperCommented:
you can enable and parse IIS logs.
0
 
screen-nameCommented:
0
 
screen-nameCommented:
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
 
snazaireAuthor Commented:
Where can get the IIS log file please?
0
 
screen-nameCommented:
0
 
screen-nameCommented:
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now