Get SharePoint 2010 version with PowerShell

As part of the summary script I use the following code to get the SharePoint 2010 version. This identifies which CU or Service Pack has been installed.

There are a couple of ways for getting the build version:

1. Using Central Administration

It is of course possible to get the build version using central administration by going to ‘Central Administration –> System Settings –> Manage servers in this farm’

image

2. Using get-spfarm

You can use the following line of code to get the buildversion

get-spfarm | select BuildVersion

image

3. Using [Microsoft.SharePoint.Administration.SPFarm]::Local

This command outputs the same values as get-spfarm.

([Microsoft.SharePoint.Administration.SPFarm]::Local).buildversion

image

Use .tostring() to get the version as string.

image

Getting SQL Instance Edition or service pack for Microsoft SQL Server

I was working on a manual for implementing SCOM 2012 and I needed to document the SQL edition. I founded an select query a couple years ago what I’m using ever since. This query shows the edtion, productversion, productlvl and some more data.

I thought why not make a blog about it for people who are starting to use SQL.

Script

SELECT
SERVERPROPERTY(‘Edition’) AS ‘Edition’,
SERVERPROPERTY(‘ProductVersion’) AS ‘ProductVersion’,
SERVERPROPERTY(‘ProductLevel’) AS ‘ProductLevel’,
SERVERPROPERTY(‘ResourceLastUpdateDateTime’) AS ‘ResourceLastUpdateDateTime’,
SERVERPROPERTY(‘ResourceVersion’) AS ‘ResourceVersion’
GO

Below are 2 screenshots. 1 is from SQL 2005 and the other is SQL 2008 R2.

SQL 2005

image

SQL2008 R2

image

SharePoint Storage Manager – Storman.aspx

Storman.aspx was a feature in SharePoint installations but it was not implemented in the RTM version of SharePoint 2010. Service Pack 1 implements StorMan.aspx again for site collections.

StorMan.aspx can be used for the management of documents size and pagesize. You can see the pages and documents which require the most disk space in SharePoint 2010. Administrators can easily spot documents that require high disk space.

You can find StorMan.aspx under ‘Site Settings –> Storage Metrics’

 image

image

It is possible that you won’t see any changes when you view it for the first time. The information will be visible when you have browsed a few pages, otherwise you can re-open internet explorer.