There are two settings in the Central Administration (CA) that need to be enabled for this functionality to work. When they are enabled, you’ll get usage reports that help you determine how the users are using SharePoint in your organization.

1. Access the CA (Central Administration) of your SharePoint solution
2. Click the Operations short-cut or the tab at the top
3. Under Logging and Reporting click the Usage analysis processing link
4. Tick Enable Logging and set the path for the logs. Default is fine if you have space on your server, and then the number of log files to create. Microsoft suggests 1 to 3 times the number of database servers.
5. Tick Enable usage analysis processing and select the start time and end time you want to collect the information.
6. Click OK to save your changes
7. Under the Share Services Administration, click the SSP for your site
8. Under Office SharePoint Usage Reporting click the Usage reporting link
9. Tick Enable advanced usage analysis processing and Enable search query logging (helpful when seeing how your users are using search)
10. Click OK

That’s all there is to it.

Access your reports by navigating to your sites home page. Click the Site Actions tab, Site Settings -> Modify All Site Settings. Under Site Collection Administration, click the Site collection usage reports link. You’ll have several reports to choose from on the left hand navigation bar.

Jon

There are a few ways to integrate MS Office 2007 and SharePoint 2007. This first method uses the group policy editor to manually input locations that will show up in My Places bar in your Office applications.

This approach seems to be a little disconnected from the SharePoint environment but does work. I only tested this on a local machine group policy. I will test it on the domain controller to see if I can force it out to all desktops.

First, you need to get the Office Resource Kit or the Office12.adm file. This link will take you to the download for the administrative templates which includes the above mentioned file.

http://support.microsoft.com/kb/924617

Download the file and extract to a location on your PC. You’ll find the file in the C:\..\ADM\en-us\ folder (English US version). Copy this file to your C:\Windows\INF directory. Now open the group policy editor, gpedit.msc from a command line. Either use the Start -> Run -> gpedit.msc or from a command prompt by typing gpedit.msc.

1. Right click Administrative Templates under the User Configuration and click Add/Remove Templates…
2. Click Add…
3. It should open in your C:\Windows\INF directory. If not, browse to it and select the file Office12.adm and click Open.
4. Click Close
5. Expand Administrative Templates and expand Microsoft Office 2007 system.
6. Expand File Open/Save dialog box and select Places Bar Locations.
7. You’ll see 10 items labeled Places Bar Locations 1, 2, 3…
8. Double click or right click and select properties.
9. Enable it, enter a logical name for the location and paste the link for the SharePoint site.  Do not add the default.aspx file in the link.
10. Click OK and close Group Policy Editor.
11. Open Word or Excel and select the Office Icon, Select Open and you should see the new location in the My Places Bar.

I will continue testing for more dynamic ways to update this information. I know it’s available through audience targeting but I haven’t tackled that yet.

Hopes this helps someone.

Jon

It’s been just over 11 years since I decided to take my current job. I’ve had memorable experiences and awesome opportunities that will last a lifetime. It was through this experience, I was able to obtain a degree and gain experience in SharePoint, Software Development and Analysis.

I am now focused on my next journey which is to get my MOSS Configuration certification (70-630). I will keep a blog journal of my studies until the exam. After that, I will embark on another journey… the Microsoft Masters Program.

Please check back as I hope to fill this blog with great information that everyone can use. I’m concentrating on real world uses for SharePoint and how you can maximize its potential within an organizations structure and culture. The idea behind SharePoint is to streamline your companies need for an intranet and document management.

Jon