Skip to main content

Posts

Showing posts from March, 2016

Delete a particular web part from all the sites ans sub sites

Please us below PowerShell script to delete a particular web part from all the sites ans sub sites, Add-PSSnapin "Microsoft.SharePoint.PowerShell" #$CSVFile = Import-CSV -Path "E:\Ulhas\Subsites.csv" $filepath = "E:\Ulhas\Subsites.csv" Import-CSV $filepath -Header SiteUrl | Foreach-Object{     $SPweb = Get-SPWeb $_.SiteUrl #"https://www.contoso.com/it/pmo/"     $webpartmanager = $SPweb.GetLimitedWebPartManager(($SPweb.Url + "default.aspx"),  [System.Web.UI.WebControls.WebParts.PersonalizationScope]::Shared)        $webpartsarray = @()      For($i=0;$i -lt $webpartmanager.WebParts.Count;$i++)       {         if($webpartmanager.WebParts[$i].title -eq "ScriptToRemoveBlankSpace")  #Check for particular web part          {           $webpartsarray = $webpartsarray + $webpartmanager.WebParts[$i].ID              }       }      $var=$webpartsarray.length      write-host $var      for($j=0; $j -lt $var; $j++)

Permission audit report for site and all sub sites using PowerShell

Use below script to get Permission audit report for site and all sub sites using PowerShell, Add-PSSnapin "Microsoft.SharePoint.PowerShell" $URL="https://intranet.contoso.com/sales/mysite/"      $site = Get-SPSite $URL      #Write the Header to "Tab Separated Text File"         "Site Name`t  URL `t Group Name `t User Account `t User Name `t E-Mail" | out-file "E:\Ulhas\UsersandGroupsRpt.txt"          #Iterate through all Webs       foreach ($web in $site.AllWebs)       {         #Write the Header to "Tab Separated Text File"         "$($web.title) `t $($web.URL) `t  `t  `t `t " | out-file "E:\Ulhas\UsersandGroupsRpt.txt" -append          #Get all Groups and Iterate through            foreach ($group in $Web.groups)          {                 "`t  `t $($Group.Name) `t   `t `t " | out-file "E:\Ulhas\UsersandGroupsRpt.txt" -append                 #Iterate throu

Color coding the list status column in SharePoint 2013

Below formula can be used to color code the list status column in SharePoint 2013, ="<DIV style='font-weight:bold; font-size:42px; color:"&CHOOSE(RIGHT(LEFT(Priority,2),1),"red","orange","green")&";'>•</DIV>" Credit goes to Junaid Khan here:  https://junaidsk.wordpress.com/2014/02/25/color-coding-in-sharepoint-lists-using-calculated-columns/

Application error when access /_admin/owners.aspx, Error=User cannot be found. reolved using PowerShell

While trying to set site collection admin and secondary admin from central admin in SharePoint I got below error in ULS log, Application error when access /_admin/owners.aspx, Error=User cannot be found.   at Microsoft.SharePoint.SPUserCollection.GetByID(Int32 id)     at Microsoft.SharePoint.Administration.SPSiteAdministration.get_SecondaryContactLoginName() User below PowerShell Add-PSSnapin "Microsoft.SharePoint.PowerShell" Set-SPSite –Identity https://contoso.com/sites/it/ –SecondaryOwnerAlias domain\umorbale https://technet.microsoft.com/en-in/library/ff631156.aspx?f=255&MSPPError=-2147217396 https://pholpar.wordpress.com/2011/05/13/user-cannot-be-found-error-solved-using-a-sql-query/