Sathiya's Blog

Month: September 2015

  • Delete SharePoint list items from PowerShell

    Here the quick solution to clean up/delete SharePoint list items that save a days lot if cleanup required. Manual efforts would take a lot so prefer to go with scripts; # Enter the site URL instead http://sathiya.io $weburl = “http://sathiya.io” $site = new-object Microsoft.SharePoint.SPSite ($weburl) $web = $site.OpenWeb() Write-Host “The Web application is : “$web.Title…

  • Export Windows Service to Excel with Filter

    Another sample Powershell script to exporting “Running” and “Stopped” windows service to excel by using Powershell Array. $location = “C:\sathiya.io”; $service = @(“Running”, “Stopped”); for ($i=0;$i -ne 2;$i++) { $text = $service[$i]; #Exporting the result to the text file # Append – This keyword is to update the file in the loop # Select -…

  • Creating Managed Metadata Service Application by Powershell Script

    As we are all knows, the SharePoint Powershell can be fast and simple. Here the sample script for creating Managed Metadata Service Application; New-SPServiceApplicationPool -Name “Managed Metadata Service App Pool” -Account sathiya\SPAppPool New-SPMetadataServiceApplication -Name “Managed Metadata Service Application” -ApplicationPool “Managed Metadata Service App Pool” -DatabaseName “MMD” New-SPMetadataServiceApplicationProxy -Name “Managed Metadata Service App Pool” -ServiceApplication “Managed…