Solved

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

Posted on 2010-08-20
9
2,664 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
  • 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 42

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
 
LVL 42

Expert Comment

by:zephyr_hex (Megan)
ID: 33580702
you can enable and parse IIS logs.
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

895 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now