Tuesday, December 18, 2012

How to add Google Analytics to SharePoint Online


SharePoint Online provides some basic usage statistics if you browse to the /_layouts/UsageDetails.aspx and the /_layouts/Usage.aspx pages.
This is limited to 30 days, however, and there are only a few basic reports available. And they are not that accurate.
One way to improve this usage reporting is to use an online web analytics solution such as Google Analytics.

This will give you more detailed information about your users and let you view track statistics over any length of time.



SharePoint Online Analytics Features

Once you have set up a Google Analytics account and generated the tracking code you can use the steps below to add this to your Office 365 SharePoint Online environment.

  • Log into your SharePoint Online site such as company.sharepoint.com
  • Select Site Actions > Site Settings
  • Under Galleries select 'Master pages and page layouts' (or Master pages in the P1 plan).
  • Select the v4.master page file check-box and select 'Download a Copy' from the ribbon (Note if you are not using the default master page you should download the custom master page that you are using. To find out the master page you are using go to Site Settings > Look and Feel > 'Master page' ).
  • Open the master page file you downloaded with a text editor such as notepad and enter the Google Analytics tracking code just before the closing </head> tag and save the file
  • From the master page gallery select 'Upload Document' from the ribbon, select the master page file you saved in step 6 and click OK
  • You now need to Publish and Approve the file before it is visible to other users (note this isn't required for the P1 plan or if you have disabled approval). Before you do this I suggest browsing to the homepage in another tab so that you can check the site is not broken (this can happen if you enter the tracking code in the wrong place).

Wednesday, December 5, 2012

Permissions Management and Auditing in Office 365


Permissions management is best maintained and audited by the use of "Groups". Maintaining three major groups will help with auditing. These should be Site Owners, Site Members and Site Visitors. These are defined as FullControl, Add/Update/Delete, and Read Only, respectively.
The site administrator would add existing Active Directory security groups into these or add individual users to these groups.



Permission Management can be viewed site wide or on a specific piece of content.
Site Permission checking:

Content specific permission checking:



You can also check global Permissions per user




Auditing
Configure the settings below on your site to collect Audit Logs.



Audit Log Reporting


Note that the above Content Viewing report will not work in SharePoint Online as this is unsupported for online.


Custom Audit Reports can be run and saved to a SharePoint library for a specific user :

Office 365 Web Analytics

It's a shame, but the official position on Web Analytics for o365 is "UNSUPPORTED"

This is per Appendix B from the Service Description doc: http://www.microsoft.com/en-us/download/details.aspx?id=13602


But in reality, the links are just not there in the Site Settings > Site Collection Administration section.
You can simply append to your domain url the following to get to them.
this is kind of like an Easter Egg for SP365…

Just use the links..
/_layouts/UsageDetails.aspx This page has left navigation to assist you with analytics.

/_layouts/usage.aspx 

Sunday, November 11, 2012

MetaData World Peace

Metadata enables the ability to classify documents and list items within SharePoint.

Sh!t my client says:“We want folders, because metadata will make users’ heads explode”


Review managed metadata services for managing taxonomies, folksonomies, tags, metadata and content types in SharePoint 2010

Managed Metadata Services and Taxonomies in SharePoint 2010
Information architecture is never as easy as it seems. For example, do you have a hard time deciding if you should group your documents by department or by project?
Create a practical, hands on review of managed metadata services (MMS) for managing taxonomies, folksonomies, tags, metadata and content types in SharePoint 2010.

These tools can optimize search, content management, taxonomy, social networking and navigation.

Friday, October 19, 2012

Using the Calendar Printing Assistant for Outlook

The Calendar Printing Assistant for Outlook is a program that provides an easy way to print and customize Outlook calendar information. It puts you in control of the tools you need and helps you plan and create designer-quality output.
Download:
http://www.microsoft.com/en-us/download/details.aspx?id=16645
With this download you can:
  • Add Shared Calendars and print them!
  • Print dynamic calendar views
  • Customize and personalize your calendars
  • Adjust information to changing views
There is one big limitation where you will not be able to run this program on a 64bit version of Outlook.
In the below calendar, I have added my Exchange Calendar, My Tasks, Ron's shared Exchange calendar and my Office365 Calendar.

Tuesday, October 9, 2012

Detect the installed SharePoint edition

get-spfarm | select Products





See the article How To: Detect the Installed SKU of SharePoint 2010 on MSDN. It has a list of GUIDs for each SKU:
  • BEED1F75-C398-4447-AEF1-E66E1F0DF91E: SharePoint Foundation 2010
  • 1328E89E-7EC8-4F7E-809E-7E945796E511: Search Server Express 2010
  • B2C0B444-3914-4ACB-A0B8-7CF50A8F7AA0: SharePoint Server 2010 Standard Trial
  • 3FDFBCC8-B3E4-4482-91FA-122C6432805C: SharePoint Server 2010 Standard
  • 88BED06D-8C6B-4E62-AB01-546D6005FE97: SharePoint Server 2010 Enterprise Trial
  • D5595F62-449B-4061-B0B2-0CBAD410BB51: SharePoint Server 2010 Enterprise
  • BC4C1C97-9013-4033-A0DD-9DC9E6D6C887: Search Server 2010 Trial
  • 08460AA2-A176-442C-BDCA-26928704D80B: Search Server 2010
  • 84902853-59F6-4B20-BC7C-DE4F419FEFAD: Project Server 2010 Trial
  • ED21638F-97FF-4A65-AD9B-6889B93065E2: Project Server 2010
  • 926E4E17-087B-47D1-8BD7-91A394BC6196: Office Web Companions 2010
You can look for these within the registry key HKLM\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\WSS\InstalledProducts.

You can also use the PowerShell command get-spfarm | select Products to output GUIDs for the installed SKUs.

Tuesday, October 2, 2012

Adobe Reader 10.1.4 Checkout and Open

Today I installed Adobe PDF Viewer version X (10.1.4) and when you open a document in SharePoint you are Defaulted with Check Out & Open.
That seems to be a BAD implementation by Adobe, perhaps intentionally done?


Saturday, September 29, 2012

Move a site to another location

Move a site to another location
stsadm -o renameweb -url http://spfarm/subsite -newname spfarm/othersubsite

SharePoint Content DB privileges

Grant user db_owner privileges on the content database associated with that web application.
This can be done either manually (using the UI) or via PowerShell.

PS> $w = Get-SPWebApplication("webappname")
PS> $w.GrantAccessToProcessIdentity("domain\supsvc")

SharePoint Needs Upgrade???

SharePoint Needs Upgrade???
(get-spserver $env:computername).NeedsUpgrade


Find user Profile Application GUID in Sharepoint

Find user Profile Application GUID in Sharepoint $sts = Get-SPServiceApplication | ?{$_ -match "user"}

PowerShell Editor and Secuity

Change Security Policy to Allow users to create powershells and run them
Set-ExecutionPolicy Unrestricted

To get the Powershell Editor on Win2008 R2 server…
Import-Module ServerManager
Add-Windowsfeature PowerShell-ISE

Pasted from <http://www.jonathanmedd.net/2011/02/powershell-ise-not-installed-by-default-in-windows-server-2008-r2.html>

Anonymous Site Access and Site Lockdown

If you need to lock down a SharePoint site collection for additions, but still allow updates and deletions, what do you do?


Use the following cmdlet in PowerShell:
Set-SPSite –Identity <SiteCollection> -LockState NoAdditions


If you setup anonymous access for a web app to the internet there is a way to lock down anon users from seeing allitems and editform pages while still letting them gain access to other areas.  What is this?

You must activate the ViewFormPagesLockDown feature:

To disable, run this Shell command:
$lockdown = get-spfeature viewformpageslockdown

disable-spfeature $lockdown -url http://sitecollectionURL

Tuesday, September 11, 2012

Does Taking a live VM Snapshot effect SharePoint availability or performance?

I was asked this question by a client recently...

Do you know if taking a server snapshot from a Vm will disrupt anything in production like a SharePoint Server user access?

The answer is the consulting 'drinking game' answer...It depends.
For one, if the server is being acquiesced when the snap shot is being taken. A standalone VMware snapshot won’t acquiesce, but if a snapshot is being taken as part of a backup program then all the database services on the server will be paused and the DBs on that server will be inaccessible until all pending transactions have been written and the snapshot has been committed; at [company name]I have one server where this takes almost 15 minutes.


Otherwise, no... a snapshot will not impact SQL function unless the disk with the virtual server is severely overtaxed – to that point where the guest VM is probably unusable anyway.

Friday, July 20, 2012

Sh$# Steve Jobs Said...


An intranet site needs to impute its values from the very first impression it makes.
Starting life with a world class feel and identity is essential.

Monday, July 2, 2012

NTLM Authentication in FireFox


AKA, the FireFox Fix.
This is required if you have a Windows Authenticated website and need to access it via FireFox and not have to re-authenticate.


Type about:config in the FF address bar
Click the cute "I'll be careful" button
In the filter search type "ntlm"
And select "network.automatic-ntlm-auth.trusted-uris"
Now enter the domain.com address
If your site's sharepoint address is scooby.sharepoint.com, just enter sharepoint.com in here
Retry, you should not be able to access the resource, but close and reopen FF first.

Friday, April 13, 2012

How To Capture HTTP traffic

To capture WinHTTP logs
  1. Open an elevated command prompt window on the client PC.
  1. Run the following command: netsh winhttp set tracing trace-file-prefix="C:\Temp\dpws" level=verbose format=ansi state=enabled max-trace-file-size=1073741824This command enables WinHTTP logging. All log files will be stored in the C:\Temp directory, and the filenames will begin with the dpws prefix. At most 1 GB of log files will be stored.
  1. If the process using WinHTTP on the client is already running, restart the computer. For example, if the Function Discovery APIs are being used, the computer must be restarted. The Function Discovery APIs call WinHTTP from inside a service host, which may have already started when tracing was enabled.
  1. Start the WSDAPI-based client application. The application being debugged or the WSD Debug Client can be used.
  1. Reproduce the application failure.
  1. Terminate the WSDAPI-based client application.
  1. If the process using WinHTTP is not terminated with the client application, restart the computer. For example, if the Function Discovery APIs are being used, the computer must be restarted.
  2. Run the following command: netsh winhttp set tracing state=disabledThis command disables WinHTTP logging.

  1. Inspect the DPWS logs in C:\Temp and verify that the required requests and messages were sent.
  2. If secure channel (HTTPS) communication is being used, check for SSL/TLS failures.

Tuesday, January 31, 2012

Mommy, when will we run out of GUIDs?

Answer: 1,633,807,249 years

Assumption:
Each person gets a personal copy of the internet, every second, for a billion years.