Windows SharePoint Services 3.0 All versions

WSS 3.0
Release	Version	KB	Download
RTM	12.0.4518.1016	n/a	n/a
Public DST	12.0.6039.5000	934525	n/a
SP1	12.0.6219.1000	936988	n/a
Post SP1 (Jan) (Global)	12.0.6300.5000	941422
Post SP1 (Jan)	12.0.6300.5000	941653
Post SP1 (Feb)	12.0.6303.5000	948945
Post SP1 (Feb) (Global)	12.0.6304.5000	949399
Post SP1 (Mar) (Global)	12.0.6305.5000	949749
Post SP1 (Mar) (Global)	12.0.6306.5000	949956
Post SP1 (Mar) (Global)	12.0.6307.5000	950279
Post SP1 (Mar) (Global)	12.0.6308.5000	950484
Post SP1 (May) (Global)	12.0.6314.5000	952288
Post SP1 (May)	12.0.6314.5000	952292
Post SP1 (May) (Global)	12.0.6315.5000	952698
Post SP1 (May) (Global)	12.0.6316.5000	953137
Post SP1 (June) (Global)	12.0.6317.5000	953473
Post SP1 (June)	12.0.6317.5000	953484
Infra Update (Global)	12.0.6318.5000	951695
Post SP1 (July)	12.0.6324.5000	955594
Post SP1 (AAM)	12.0.6324.5001	956248
Aug CU (Global)	12.0.6327.5000	956057
Aug CU	12.0.6327.5000	957109
Oct CU (Global)	12.0.6332.5000	957691
Dec COD (Global)	12.0.6335.5000	959644
Dec CU	12.0.6335.5000	960010
Dec COD (Global)	12.0.6336.5001	961175
Feb 2009 CU	12.0.6341.5000	961755
SP2	12.0.6421.1000	953338	n/a
April 2009 CU	12.0.6504.5000	968850
Jun 2009 CU	12.0.6510.5001	971538
Aug 2009 CU	12.0.6514.5004	973400
Oct 2009 CU	12.0.6520.5000	974989
Dec 2009 CU	12.0.6524.5000	977027
Feb 2010 CU	12.0.6529.5000	978396
April 2010 CU	12.0.6535.5002	981043
Jun 2010 CU	12.0.6539.5000	983311
Aug 2010 CU	12.0.6545.5001	2276474
Oct 2010 CU	12.0.6548.5000	2412268
Dec 2010 CU	12.0.6550.5002	2458606
Feb 2011 CU	12.0.6554.5000	2475886
April 2011 CU	12.0.6557.5000	2512783
June 2011 CU	12.0.6562.5000	2544399
August 2011 CU	12.0.6565.5001	2553022
SP3	12.0.6608.1000	2526305
October 2011 CU	12.0.6654.5000	2596541
December 2011 CU	12.0.6656.5000	2596987

SharePoint 15 Technical Preview Download - Documentation only

SharePoint 15!!! Development is going on in express mode :). Microsoft SharePoint team is getting ready with the next release of SharePoint and it named SharePoint 15. Recently they released the interoperability API Documentation of SharePoint 15 Technical Preview version and it contains what's new. I am still not yet gone through all, will update you once I completed reviewing the documentation. It is public available and download it here. SharePoint 15 Technical Preview Documentation.

Loop through all webs faster way in SharePoint 2010

We are learning so many concepts each day and implementing/writing lot of code. But, we might not spending time to write the code more efficient way or more cleaner way. So, this post is again related to how to write code efficient in SharePoint 2010. :)

So far, till SharePoint 2007 to loop through all the webs in site collection we use the code:

using(SPSite site = new SPSite("http://sitecollectionurl")
{
foreach(SPWeb web in site.AllWebs)
{
//Some code here
web.Dispose();
}
}

The above code is not at all wrong.

Case 1:
If you need the web object only for reading the generic information of the site like title, url, id etc… then it is a very expensive operation. For this, in SharePoint 2010 there is a workaround and that will load results 10 times faster than above code. Below is the efficient code:

using(SPSite site = new SPSite("http://sitecollectionurl")
{
foreach(SPWebInfo webInfo in site.AllWebs.WebsInfo)
{
//Code here to read web information 
}
}

This way you only reading the web information object instead of complete Web object. You can take a look more about WebInfo class here in MSDN.

Case 2:
If you want to read the properties you needed then there is a more better way than simply loop through AllWebs property in for each. The complete explaination is here. This is a very good post and very very faster way to read the properties in all webs.

You really see the difference, a big difference. Do you like this post?

Download Visual Studio 11 Developer Preview - now with SharePoint developer tools

Visual Studio 11 Developer Preview is now available with the SharePoint developer tools and downloadable to public. Earlier version only has the Windows 8 stuff as a new thing along with some user experience improvements. But, in the new version it has the SharePoint developer tools added. So, as I am a SharePoint guy I would like to see what are all the features available in the new version.

Visual Studio 11 is very fast when compared to Visual Studio 2010 and it definitely improves the productivity. This is one of the major point which I like about it. When come back to what are the new features added in SharePoint developer tools, below are the few of them.

• Create Lists and Content Types by Using New Designers
• Create Site Columns
• Create Silverlight Web Parts
• Publish SharePoint Solutions to Remote SharePoint Servers
• Test SharePoint Performance by Using Profiling Tools
• Create Sandboxed Visual Web Parts
• Improved Support for Sandboxed Solutions.
• Support for JavaScript Debugging and IntelliSense for JavaScript
• Streamlined SharePoint Project Templates
• Related Topics

The MSDN link has all these features explained. Stay tuned for the more updates from this blog as I like to publish more articles on what next...

Script to install SharePoint 2010 in Windows 7

You are ready to install SharePoint 2010 in Windows 7? Then you are at the right place. For the installation you have to download all required and follow the complete MSDN article and then execute step by step. If there is something which do all the steps for you then how it is? good right?
Yah! there is a great script which is written by Ram which installs SharePoint 2010 on windows 7 PC. Go and download and execute guys. Great script.

Get the information here.

How to find Inactive computer accounts in active directory?

Do you know how can we do this? Either we query the AD to get the information by writing code in C# or manually check the AD for the inactive accounts. But, there is another simple way which will get this information without any big efforts. Yes, using Powershell script.

$COMPAREDATE=GET-DATE
$NumberDays=90 
$CSVFileLocation='C:\TEMP\OldComps.CSV' 
GET-QADCOMPUTER -SizeLimit 0 -IncludedProperties LastLogonTimeStamp | where { ($CompareDate-$_.LastLogonTimeStamp).Days -gt $NumberDays } | Select-Object Name, LastLogonTimeStamp, OSName, ParentContainerDN | Sort-Object ModificationDate, Name | Export-CSV $CSVFileLocation 

You have to provide the days - the timeline of inactive accounts and where to save the output of inactive accounts list.

The complete information is available at this post.

Open PDF files directly in browser SharePoint 2010

Here is how you can tell SharePoint 2010 site to open the PDF files in the browser instead of prompting the user to save or open the PDF. This will be a great option to the most of end users. This needs simple Powershell scripting run on the server. Below is the code we should use:

# <# 
# .DESCRIPTION 
#  This script adds new MIME type to "AllowedInlineDownloadedMimeTypes" property list of defined SharePoint 2010 Web Application.
#
#  Script prompts you for MIME type and Web Application URL.
#
#  Code shall run in context of Farm Administrators group member.
# 
# .NOTES 
#       File Name   : Add_MIME_Type.ps1 
#       Author      : Kamil Jurik, WBI Systems a.s. 
#       Created     : 11/12/2011 
# 

If ( (Get-PSSnapin -Name "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null ) {
    Add-PSSnapin "Microsoft.SharePoint.PowerShell"
}
Get-SPWebApplication
$WebApp = Get-SPWebApplication $(Read-Host "Enter Web Application URL")
Write-Host "Mime Type Examples:""application/pdf, text/html, text/xml"

If ($WebApp.AllowedInlineDownloadedMimeTypes -notcontains ($MimeType = Read-Host "Enter a required mime type"))
{
  Write-Host -ForegroundColor White "Adding" $MimeType "MIME Type to defined Web Application"$WebApp.url
  $WebApp.AllowedInlineDownloadedMimeTypes.Add($MimeType)
  $WebApp.Update()
  Write-Host -ForegroundColor Green "The" $MimeType "MIME type has been successfully added."
} Else {
  Write-Host -ForegroundColor Red "The" $MimeType "MIME type has already been added."
}

The powershell script do the magic for us. Below is the explanation.

1. It is taking the web application url as input
2. And if the web application is not allowed the the PDF files MIME type to it's allow downloadable mime types collection then it will add it.

So, once you run the code the files will be open up in the browser instead of prompting the user. The server will not allow PDF files by default as it think PDF files are not secure.

Note: The script should run with the account who has FARM administrator level access.
For more details about it: please check technet article.

ASP.NET 4.5 new features

The new version of ASP.NET 4.5 has many features integrated and there are many additions to the Visual Studio as well. I am really excited to see all of these features in hand.... These functionality improvements makes applications more easier and faster. The features are added in both Web forms and MVC.

ScottGu's blog has all these features explained in detail as series of posts. Readers, please read all of these and know the new and great features coming for better productivity.

ASP.NET 4.5 New Features

Get TaskID in SharePoint custom Visual Studio workflows

When you are working with custom workflows implementing in Visual studio, you might be sending the emails when a task is created. By default SharePoint sends an email when a task is assigned to a user. But, if you want to customize the email body and subject, then you will use send mail activity and will give link to the user. Here the problem starts.
In CreateTask activity in Visual Studio you cannot get the taskID as the task is not yet created. What to do??? So, to get the task identifier we have to implement the below approach.

1. CreateTask Activity
2. TaskCreated Activity 
3. SendMail Activity
4. OnTaskChanged Activity
5. TaskComplete Activity

Remember, until unless the Activity TaskCreated is executed the TaskID will not be available in workflow context. The main reason behind is, the task created information is not caught by SharePoint workflow anywhere until we run this activity. So, in the TaskCreated activity you can get the AfterProperties of the task and in those properties you will get the recent created task identifier which is integer.

So, note that in custom workflows which are implementing through Visual Studio the only way you can get the TaskID is AfterProperties of the TaskCreated activity. I have wasted hours when I was learning these. Hope you liked it.