Reduce one day in SharePoint list Column using PowerShell

In this article we can able to see how to reduce one day less for a particular date column in SharePoint list using PowerShell.


Copy data from one list to another list in SharePoint using PowerShell

Disable list throttling SharePoint using PowerShell
Concatenate two fields and update the value into another field in SharePoint using PowerShell

We migrated the content from lotus notes to SharePoint, due to some time Zone difference we got one last more for all the items in the list. For that using PowerShell we reduced the one day.

  

Add-PSSnapin microsoft.sharepoint.powershell

$spWeb = Get-SPWeb "http://dotnetsharepoint.com/sites/sharepoint"

write-host $spweb

$List=$spWeb.Lists["ListName"]

write-host $lList

$spItems = $List.GetItems()

foreach($spItem in $spItems)

{

    $datevalue = $spItem["DateColumnName"].AddDays(-1);

$spItem["DateColumnName"] = $datevalue

$modifiedBy = $spItem["Editor"]

$modifieddate = $spItem["Modified"]

$spItem["Editor"] = $modifiedBy

$spItem["Modified"] = $modifieddate

$spItem.Update()

$list.Update()

 }

http://www.dotnetsharepoint.com/2015/12/reduce-one-day-in-sharepoint-list.html

SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM

Read More»

How to get a list of site collection for a web application using PowerShell Script

How to get a list of site collection with template for a web application

       The following PowerShell  script can be used to get a list of site collections with template for a web application.

Get-SPSite -WebApplication http://c4968397007/-Limit All |

Select -ExpandProperty AllWebs |

ft url, Title,WebTemplate, Created -auto |

out-string -width 1024 > c:\sites\sitetemplate.txt

How to get a list of site collections without template names for a web application

     This script will get only list of site collections without template names for a web application.

function GenerateAllSitecollections ($url)

{

    try

      {

         $Site=Get-SPSite $url        

         $spWebApp = $Site.WebApplication

         $TotalList = @()

          write-host "Below is the list of all site collections for a web application" + $spWebApp + "….." -foregroundcolor red

         foreach($allsites in $spWebApp.Sites)

         {

           $list =  $allsites.url

                   $listtemplatename = $allsites.WebTemplate

           write-host $list –foregroundcolor  blue   

                   write-host $listtemplatename -foregroundcolor blue  

         }                      

      }

   catch

      {

          write-host "Unable to Extract Site collection List in web application" -foregroundcolor red

          break

      }

} 

GenerateAllSitecollections  -Url " http://c4968397007/" > c:\sites\sitecollections.txt

Read More»