Install SharePoint 2010 Language packs

Hi Readers, We have to install 11 language packs in our share point environment that consists of  several servers. Here is the method that we used to reduce the effort. 1.  Downloaded all the language packs (Foundation & Server) Don’t forget to create logs folder. For example:-  Below screen shot for Chinese simplified folder. 2.…

Exchange ActiveSync – Report

Hi All, This script I have used to extract activesync details from exchange 2007 server. below are the details:- Userid DeviceType DeviceID DeviceUserAgent FirstSyncTime LastSuccessSync Identity DeviceModel DeviceFriendlyName DeviceOS Extract the zip file & run the batch file. http://gallery.technet.microsoft.com/scriptcenter/Exchange-ActiveSync-Report-92279541 here is the report: PowerShell #############################################################################  #       Author: Vikas Sukhija  #       Date: 07/31/2013  #       Description: Extract the Active Sync stats  #############################################################################  # Add Exchange Shell…  If ((Get-PSSnapin | where {$_.Name -match “Exchange.Management”}) -eq $null)  {      Add-PSSnapin Microsoft.Exchange.Management.PowerShell.Admin  }  #format Date …

Connect Excel to SQL

Hi All, Today I am sharing a method that We can use –> connect Excel to SQl server database. Steps to follow:- 1. open excel 2. From data Tab select –>From other Sources –>From SQL server 3.  Enter server Name & authentication mechanism 4.  Select database & then select the table 5.  Click finish 6. click…

Creating SharePoint Dashboard using Chart WebPart

Hi All, Today I am sharing an automated solution that I have created using powershell & sharepoint Chart webpart. I have to share the whole solution as without it relevance of script will not be understood as I desire. We have created a tracker List for SIP (service improvement plan) for each of the tracks.…