Thursday, February 28, 2013

Check SharePoint Build version

In this post documenting following three ways of checking the SharePoint build version

  1. Using PowerShell script
  2. Using Central Admin
  3. Using SharePoint Admin database Versions table sql select query

1. Using PowerShell Script

Get-SPFarm | Select BuildVersion


2. Using Central Admin


a. Open Central Admin and go to Upgrade and Migration



b. Under Upgrade and Patch Management click on link "Check product and patch installation status" and now you can now view the patch status for products installed on servers in the farm.






3. Using SharePoint Admin database Versions table sql select query

Log in to SharePoint database server and select the SharePoint Admin database.

select * from Versions


Wednesday, February 27, 2013

XML Formatting using Notepad++ editor

There are occasions where i had received XML files that are not formatted. I know we can view XML files in browsers however XML data modifications and viewing/manipulating/searching XML data etc needs some effort using XML editors etc. First before XML data modifications everyone prefers the XML data is in readable and formatted with indents.

So assume XML data is not formatted like in screenshot below...



Steps below explains how to do XML Formatting using Notepad++ editor
1. Install the XML Tools plugin that comes FREE as part of NotePadd++ editor.
2. SELECT ALL TEXT (CTRL+A) the XML data that you want to format
3. Go to Menu "Plugins" --> "XML Tools" --> "Pretty print (libXML) [experimental]"



4. That's it... Now you have the XML data in formatted format.