Query SharePoint List to get all document versions information: SharePoint 2007

Two days back I have posted an article on SharePoint Storage Problems, which can give you a fair idea of what things to look at when you plan or your SharePoint site has eaten space more than expected.

While looking at the same problem, we already know that SharePoint document versions can be the one of the element of sudden spike in SharePoint Storage but how we could determine how many versions are there on the SharePoint collection and what size they are off?

As you all know SQL is the ocean for the SharePoint Information storage, so SQL can provide us the relevant information about this. I wrote a SQL query to get the information on the versioning of all the document in the particular site.

Select a.version, a.timecreated, a.size, b.dirname,b.leafname, b.listid

from dbo.DocVersions a, alldocs b  where a.siteid=b.siteid

and b.dirname = 'sites/AMAR' and a.size 'greator than and equal to' (<>);0 and b.listid is not null

order by a.size

In the above query, columns refer to:

Versions: refer to number of versions of documents in a list

Timecreated: time when the document was created

Size: is the size of the versions (in KB)

Dirname: site name (e.g. sites/amar)

List id: ID of the list in the SharePoint Site.

Hope this piece of information does help you. If you have any questions and concerns do let me know.

Recover / Retrieve The Farm passphrase in Sharepoint 2010

Today one of my Clients wanted to add a server to the farm and had forgot the Farm passphrase . it had been a day and he was not able to find the right one . He had not documented the same .

We tried researching on how to retrieve the Passphrase however were not able to find the right Solution . May be its possible to pull from the sql server after running some Query however was not able to find one

I Came to know that there is no way to lookup the Passphrase in the Database and the only way is to reset the Passphrase and without a valid database or SQL connection this is not possible .

The Best way i could find is to Reset the passphrase using the Powershell commands .

Start =>  All Programs => Microsoft SharePoint 2010 Products => SharePoint 2010 Management Shell right click the link and run as administrator.

At the PowerShell prompt input

$passphrase = ConvertTo-SecureString -asPlainText –Force

You will be asked to input a new passphrase in plain text.

Set-SPPassPhrase -PassPhrase $passphrase –Confirm

After inputting the command above you will be asked to reenter the new passphrase
Enter Y = Yes N = No to complete the change.

Once it is done run the Wizard. and you will be able to add the server to the farm with the new passphrase .

It may Happen that you may get some error related to Sql . At this point of time as you have lost the connectivity with Sql

Check for all the permissions of the account you are logged in with on the sql . At times still it would not connect . then the only thing is disconnect the server from the farm and reconnect it

Note : If you know how or if you have any Idea of retrieving the Passphrase Please share .

Latest software updates for Sharepoint 2010

For the latest public updates, see the Update center for Office, Office servers, and related products.

October 2012 CU

October Cumulative Update for SharePoint 2010 is a Post-SP1 hotfix. That means that you should ensure that SP1 is installed before the October CU.

The KB articles for October CU can be found at the following locations (they should be available in a couple of days):

• KB 2687566 - SharePoint Foundation 2010
• KB 2687564 - SharePoint Server 2010
• KB 2687565 - SharePoint Server 2010 with Project Server
  As you see there is a separate Full Server Package for SharePoint Server 2010 with Project Server which simplifies patching of this common installation.

The Full Server Packages for October 2012 CU are available through the following links:

• Download SharePoint Foundation 2010 October 2012 CU
• Download SharePoint Server 2010 October 2012 CU
• Download SharePoint Server 2010 with Project Server October 2012 CU - (will be avail in a couple of days)
  After installing the fixes you need to run the SharePoint 2010 Products Configuration Wizard on each machine in the farm.

http://blogs.technet.com/b/stefan_gossner/archive/2012/11/15/october-2012-cu-for-sharepoint-2010-has-been-released.aspx

 August 2012 Update

SharePoint Foundation 2010                                      SharePoint Server 2010

   •KB 2687355                                                                   • KB 2687353

June 2012 Update

SharePoint Foundation 2010                                     SharePoint Server 2010

• KB 2598373                                                                    • KB 2598354

April 2012 Update

SharePoint Foundation 2010                                    SharePoint Server 2010

• KB 2598321                                                                    • KB 2598151

February 2012 Update

SharePoint Foundation 2010                                   SharePoint Server 2010

• KB 2597132                                                                   •KB 2597150

December 2011 Update

SharePoint Foundation 2010                                  SharePoint Server 2010

• KB 2597058                                                                   • KB 2597014

October 2011 Update

SharePoint Foundation 2010                                 SharePoint Server 2010

• KB 2596508                                                                  • KB 2596505

August 2011 Update

SharePoint Foundation 2010                                 SharePoint Server 2010

• KB 2553050                                                                 •  KB 2553048

June 2011 Update

Important

• If you installed a version of the June 2011 cumulative update that you downloaded prior to June 30, 2011, you need to download and install the update refresh from the download center.

• After you install the June 2011 cumulative update refresh, you must run the SharePoint Products and Technologies Configuration Wizard (PSConfigUI.exe) to run upgrade which will update the farm to the latest version. This step is required in order to have full SharePoint functionality. If you do not run PSConfigUI.exe, the farm will run, but with reduced capacity. For example, for SharePoint Foundation 2010 the search service will not start and as a result, the VSS Writer fails if you initiate a farm backup. For SharePoint Server 2010, search queries will work but indexing will not.

• For SharePoint Server 2010, you must restart the User Profile Synchronization service after installing the June 2011 cumulative update refresh. For more information see the Start the User Profile Synchronization service section in the Configure profile synchronization article in the library.

SharePoint Foundation 2010                                                    SharePoint Server 2010

KB 2536601                                                                                     KB 2536599

Service Pack 1 (SP1)

Service Pack 1 for SharePoint 2010 products includes stability, performance, and security enhancements that are a direct result of customer feedback and are designed to extend the value customers experience with SharePoint 2010.

Important

• After you install Service Pack 1, you need to install the June 2011 cumulative update refresh.

SharePoint Foundation 2010                                         SharePoint Server 2010
        KB 2460058                                                                   KB 2460045

      White paper: Service Pack 1 for SharePoint Foundation 2010

                                               White paper: Service Pack 1 for SharePoint Server 2010

April 2011 Update

SharePoint Foundation 2010                                        SharePoint Server 2010
• KB 2512804                                                                      KB 2512800

February 2011 Update

SharePoint Foundation 2010                                      SharePoint Server 2010
• KB 2475880                                                                    • KB 2475878

December 2010 Update

SharePoint Foundation 2010                                      SharePoint Server 2010
• KB 2459125                                                                     •KB 2459257

Note: You must restart the User Profile Synchronization service after installing this cumulative update.

October 2010 Update

SharePoint Foundation 2010                                       SharePoint Server 2010
• KB 2394323                                                                     KB 2394320


August 2010 Update

SharePoint Foundation 2010                                             - KB 2352346
SharePoint Server 2010                                                    - KB 2352342
SharePoint Server 2010 and Project Server 2010              - KB 2352345

The Office 2010 Cumulative Update for August 2010 ( KB 2396341) contains additional hotfixes that apply to Project Server 2010 and FAST Search Server 2010 for SharePoint.

June 2010 Update

SharePoint Foundation 2010                                            SharePoint Server 2010
• KB 2028568                                                                                 KB 983497
                                                                                                        KB 2124512
                                                                                                        KB 2182938
                                                                                                        KB 2204024
                                                                                                        KB 2281364

The Office 2010 Cumulative Update for June 2010 ( KB 2259686) contains additional hotfixes that apply to Project Server 2010 and Search Server 2010.

For more information, see http://blogs.technet.com/b/stefan_gossner/archive/2010/07/22/the-first-cumulative-update-for-sharepoint-2010-family-has-been-released.aspx.

Understanding SCOM ? System Center Operations Manager

System Center Operations Manager offers end to end service availability and performance monitoring for your datacenter applications and infrastructure allowing you to deliver reliable SLAs to your business.

You need a monitoring solution that enables you to reliably monitor your applications and infrastructure in a “single pane of glass” while working well with other components of your systems management tools. Ideally, you want this solution to work across your on-premises datacenter resources as well as off-premises (or public cloud based) resources
Operations Manager provides deep visibility into the health, performance and availability of your datacenter environments – across applications, operating systems, hypervisors and even hardware – through a single, familiar and easy to use interface. Operations Manager offers best of breed monitoring for Windows based environments while providing first class support for heterogeneous environments (e.g. various distributions of Linux/Unix and Sun Solaris).

Key Benefits

• Exceptional application performance and availability for Microsoft environments
• Provides end-to-end service management for your datacenter services
• Helps increase the efficiency and control of your datacenter environments
• Unified monitoring across your private and public cloud services


Reference : http://www.microsoft.com/en-in/server-cloud/system-center/operations-manager.aspx