Skip to main content

Posts

Create a SharePoint Online Site - Office 365 using Powershell

Create a SharePoint  Online Site - Office 365 using Powershell # Usage #       .\create-site-csom.ps1 -siteTitle "new site2" -siteUrl "newsite2" -cred $false -parent "https://pravahaminfo.sharepoint.com/teams/appdev1/" # #       .\create-site-csom.ps1 -siteTitle "new site2" -siteUrl "newsite2" -cred $true -parent "https://pravahaminfo.sharepoint.com/teams/appdev1/" #               Will ask for Credentials Param(     [Parameter(Mandatory=$true)]  [string] $parent,  [Parameter(Mandatory=$true)]  [string] $siteTitle, [Parameter(Mandatory=$true)] [string] $siteUrl, [string] $siteDescription,     [string] $template = "STS#0",     [bool] $cred #Use custom Credentials ) #Clear-Host Write-Host "Initializing..." $resources = split-path $script:MyInvocation.MyCommand.Definition if(-not $(Test-Path "$resources\bin")) ...

Get List of Site owners from all web applications in SharePoint using Powershell

List of Site owners from all web applications in SharePoint using Powershell Add-PSSnapin "Microsoft.SharePoint.Powershell" function CreateReportObject($url = $null, $title = $null, $desc = $null, $IsRoot = $null, $groupname = $null, $loginname = $null, $dg = $null, $email = $null, $ucount = $null, $created = $null, $farm = $null,$isreadonly = $null)  {  $newreportobj = new-object psobject          $newreportobj | add-member noteproperty -name "URL" -value $url  $newreportobj | add-member noteproperty -name "Title" -value $title  $newreportobj | add-member noteproperty -name "Description" -value $desc  $newreportobj | add-member noteproperty -name "IsRootWeb" -value $IsRoot          $newreportobj | add-member noteproperty -name "Groups" -value $groupname         $newreportobj | add-member noteproperty -name "Owners" -value $loginname $newreportobj | add-member notepr...

Get List of Site collection owners from all web applications in SharePoint using Powershell

List of Site collection owners from all web applications in SharePoint using Powershell Add-PSSnapin "Microsoft.SharePoint.Powershell" function CreateReportObject($url = $null, $title = $null, $loginname = $null, $dg = $null, $created = $null, $isreadonly = $null, $email = $null) { $newreportobj = new-object psobject          $newreportobj | add-member noteproperty -name "URL" -value $url  $newreportobj | add-member noteproperty -name "Title" -value $title         $newreportobj | add-member noteproperty -name "Owners" -value $loginname $newreportobj | add-member noteproperty -name "DomainGroups" -value $dg         $newreportobj | add-member noteproperty -name "Email" -value $email $newreportobj | add-member noteproperty -name "Created" -value $created  $newreportobj | add-member noteproperty -name "Is Read-Only" -value $isreadonly         return ($newreportobj)...

Error message : The file name or path does not exist; The file is being used by another program; The workbook you are trying to save has the same name as currently open workbook". While opening Excel file in SharePoint

Issue : Trying to download files from SharePoint through either IE or Chrome, however, getting this message: " The file name or path does not exist; The file is being used by another program; The workbook you are trying to save has the same name as currently open workbook " this happens to any file I try to download  Solution : Local office cache was the root cause of the problem only regular users who kept accessing the same files on SharePoint were the ones experiencing this issue. Excel and Word would refer to the office cache files and wouldn't find the documents. Below are the steps to resolve this issue. Follow steps from 1 to 4 if you need to unhide folders. 1.Right-Click on Start and choose 'Open Windows Explorer' 2.Tools > Folder Options. Choose the View tab. 3.In 'Hidden Files and folders ' select 'Show hidden files, folders and drives. 4.Uncheck 'Hide protected operating system files(Recommended)' 5.Go to ...

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...