Skip to main content

Posts

Remove "Access Requests" without any email sending to the users

Remove " Access Requests " without any email sending to the users. There is no deletion option in browser UI, howeever There are two ways you can work with this. 1. Using SharePoint Designer Need to add AllItems.aspx view using SharePoint Designer, deleting requests one by one would’ve taken very long time, as while the All Items view allowed me to select multiple rows, there was no Delete button in any toolbar nor ribbon.  Reference Link : http://johnlearnt.blogspot.com/2014/07/how-to-delete-access-request.html 2. Powershell Script $web = Get-SPWeb https://sharepoint.com/sites/siteA $items = $web.Lists["Access Requests"].Items while($items.Count -gt 0) {     Write-Host "Deleting: $($items[0].Title)"     $items[0].Delete() } Happy scripting :)

Step by step Office Online Server(OOS) Installation for SharePoint 2016

Step by step Office Online Server(OOS) Installation for SharePoint 2016 You can create, share and collaborate on Word, PowerPoint, Excel and OneNote files in your browser. Most notably, OOS with SharePoint lets multiple people work in a document at the same time and see everyone’s changes as they happen.Office Online Server 2016 needs to be installed on its own server, and cannot coexist with a SharePoint installation. It can still be used as a standalone installation. The farm we are using here is a one SQL Server with the SharePoint 2016 Application Server MinRole installed on, a Web-Front end (MinRole), and a standalone Office Online Server (OOS) node. We can download OOS from the  Volume License Servicing Center  at no cost.  Pre-requisites: Step Install these software packages on your Office Online Server(s). .NET Framework 4.5.2 Visual C++ Redistributable Packages for Visual Studio 2013 Visual C++ Redistributable for Visual Studio 2015 Microsoft.Id...

Disable Mysite Provisioning in SharePoint using Powershell

Disable Mysite Provisioning in SharePoint using Powershell Add-PSSnapIn Microsoft.SharePoint.PowerShell -EA 0  function DisableMySiteCreation([string]$UserProfileProxyName)  {  $upaproxy = Get-SPServiceApplicationProxy | Where-Object {$_.DisplayName -eq $UserProfileProxyName} $upasecurity = Get-SPProfileServiceApplicationSecurity -ProfileServiceApplicationProxy $upaproxy $authuser = New-SPClaimsPrincipal -Identity 'c:0(.s|true' -IdentityType EncodedClaim $ntauthusers = New-SPClaimsPrincipal -Identity 'c:0!.s|windows' -IdentityType EncodedClaim $localAuthUsers = New-SPClaimsPrincipal "NT AUTHORITY\Authenticated Users" - IdentityType WindowsSamAccountName Revoke-SPObjectSecurity -Identity $upasecurity -Principal $authuser -Rights "Create Personal Site" Revoke-SPObjectSecurity -Identity $upasecurity -Principal $authuser -Rights "Use Personal Features" Revoke-SPObjectSecurity -Identity $upasecurity -Principal $authuser -Rights ...

Create SharePoint Site Quote Template Using Powershell

Create SharePoint Site Quote Template Using Powershell  Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue function CreateQuotaTemplate ($QuotaName, $MaxLevelMB, $WarnLevelMB)  {  $quotaTemplate = New-Object Microsoft.SharePoint.Administration.SPQuotaTemplate  $quotaTemplate.Name = $QuotaName  $quotaTemplate.StorageMaximumLevel = ($MaxLevelMB*1024)*1024  $quotaTemplate.StorageWarningLevel = ($WarnLevelMB*1024)*1024  $contentService = [Microsoft.SharePoint.Administration.SPWebService]::ContentService  $contentService.QuotaTemplates.Add($quotaTemplate)  $contentService.Update()  Write-Host "New Quota Template: $($QuotaName) has been added!"  }  CreateQuotaTemplate –QuotaName "10GB_Quota" –MaxLevelMB 10000 –WarnLevelMB 9500  CreateQuotaTemplate –QuotaName "25GB_Quota" –MaxLevelMB 25000 –WarnLevelMB 20000  CreateQuotaTemplate –QuotaName "50GB_Quota" –MaxLevelMB 500...

Get SharePoint List Items Using REST

1. Create List and items similar to below. In my case list name is Site Links. 2. Download latest jquery.js bootstrap.js and bootstrap.css <div class="col-xs-12 siteLinksDiv siteLinksDivAlone" style="height: 254px;">               <div class="row">                 <div class="col-xs-12">                   <h4>Site Links <span style="width:40%;display: block;margin-top: 10px;" class="customBordered_h3 displayBlock"></span></h4>                   <ul id="sitelinks" class="paddingLeftZero">                                     </ul>                 </div>               </div...

Copy the value of one column to another column in the same SharePoint List using Powershell script

Powershell Script to Copy the value of one column to another column in the same SharePoint List . $site = new-object Microsoft.SharePoint.SPSite(" http://localhst ") $web =  Get-SPWeb -Identity  http://localhst $list =$web.Lists[" List/Library Name "] $items = $list.items     foreach ($item in $items)     {     $sourcevalue = $item[" Column 1 "]     $item[" Column 2 "] = $sourcevalue     write-host $sourcevalue     $item.update()     } $list.update()

Check-out all files in list or library in SharePoint using Powershell

Powershell Script to Check-out all files/items in a specified list or library . $spWeb = Get-SPWeb http://localhost/       $listName = " List/Library Name "   $list = $spWeb.Lists |? {$_.Title -eq $listName}  foreach ($item in $list.Items)        {         $itemFile = $item.File   $itemFile.CheckOut();          }  

Check-in all files in list or library in SharePoint using Powershell

Powershell Script to Check-in all files/items in a specified list or library .    $spWeb = Get-SPWeb http://localhost          $listName = " List/Library Name "      $list = $spWeb.Lists |? {$_.Title -eq $listName}       foreach ($item in $list.Items)        {         $itemFile = $item.File                 if( $itemFile.CheckOutStatus -ne "None" )         {             $itemFile.CheckIn("Automatic CheckIn. ( corp\SPInstallD )")         }       }     $spWeb.Dispose() 

How to access to Access request List in SharePoint Online

Browse to the Access Requests list in Internet Explorer/Chrome. Step 1 : Press F12 to open the F12 Developer Tools window. Step 2 : Click the Network tab, and then press F5 to enable network traffic capturing. Step 3 : Refresh the Access Requests page in Internet Explorer. After the page has loaded, press Shift+F5 to stop capturing network traffic. Step 4 : In the Developer Tools window, double-click the first result in the URL list. This URL ends in " pendingreq.aspx. " Step 5 :In the Developer Tools window, click Response body. Step 6 :In the search box, type pagelistid :, and then press Enter. Note :  The search highlights the pageListId text. Copy the GUID that follows the pageListId. The GUID will be between an opening brace ( { ) character and a closing brace ( } ) character as follows: {GUID} Note Include the opening and closing brace characters when you copy the GUID. This GUID is the identifier for the SharePoint Online Access Requests list for ...

Get Login user name and details for SharePoint 2013 Online (Office 365)List New Form using REST API

Display login user name and details on SharePoint online(Office 365) List New Form. Step 1: Create people picker column(In my case, created 'F rom' column). Step 2: Open your List new form using SP Designer add tdFrom id for description filed. Step 3: Add the below code in script tag and add SharePoint Services and J query reference files(Download latest files). <script type="text/javascript" src="../../Style Library/Scripts/jquery-3.0.0.min.js"></script> <script type="text/javascript" src="../../Style Library/Scripts/jquery.validate.min.js"></script> <script type="text/javascript" src="../../Style Library/Scripts/jquery.SPServices-2014.02.min.js"></script> <script type="text/javascript" > $(document).ready(function()  { var fieldName ='From'; var userAccountName= $().SPServices.SPGetCurrentUser(); LoadPeoplePickerDetails();  }...