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
# Enter name of the List below insted of ProjectList
$oList = $web.Lists["ProjectList"];
$collListItems = $oList.Items;
$count = $collListItems.Count - 1
$itemCount = $contents.Count;
$currentItem = 1;
Write-Output -NoNewline "Are you sure you want to permanently delete the '$oList.ItemCount' item from the list '$oList.Title' (y/n)? " -NoNewline;
$con = Read-Host;
if ($con -eq "y") {
    for($intIndex = $count; $intIndex -gt -1; $intIndex--)
    {
        #Deleting the item from list
        "Deleting record: " + $intIndex
        $collListItems.Delete($intIndex);
    }
    Write-Host $itemCount "item has been deleted from the list '"$oList.Title "'...!" -ForegroundColor Yellow;
}
else {
    Write-Host "No changes are happened in the list'"$oList.Title "'...!" -ForegroundColor Black -BackgroundColor Green;
}
#Close the connection
$web.Dispose()

# 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

# Enter name of the List below insted of ProjectList

$oList = $web.Lists["ProjectList"];

$collListItems = $oList.Items;

$count = $collListItems.Count - 1

$itemCount = $contents.Count;

$currentItem = 1;

Write-Output -NoNewline "Are you sure you want to permanently delete the '$oList.ItemCount' item from the list '$oList.Title' (y/n)? " -NoNewline;

$con = Read-Host;

if ($con -eq "y") {

for($intIndex = $count; $intIndex -gt -1; $intIndex--)

{

#Deleting the item from list

"Deleting record: " + $intIndex

$collListItems.Delete($intIndex);

}

Write-Host $itemCount "item has been deleted from the list '"$oList.Title "'...!" -ForegroundColor Yellow;

}

else {

Write-Host "No changes are happened in the list'"$oList.Title "'...!" -ForegroundColor Black -BackgroundColor Green;

}

#Close the connection

$web.Dispose()

Cheers…!

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 - To export the field that you want to export
	Get-Service |?{$_.Status -eq "running"} | Select ServiceName, Status | Out-File $location\text1.txt -Append
	#Exporting the result to CSV
	Get-Service |?{$_.Status -eq $text} |  Select ServiceName, Status | export-csv $location\file2.csv -Append
}

$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 - To export the field that you want to export

Get-Service |?{$_.Status -eq "running"} | Select ServiceName, Status | Out-File $location\text1.txt -Append

#Exporting the result to CSV

Get-Service |?{$_.Status -eq $text} | Select ServiceName, Status | export-csv $location\file2.csv -Append

}

Cheers!

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 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 Metadata Service Application"

Cheers!