Most used PowerShell admin tasks in SharePoint Online

In this article we can see most used PowerShell tasks based on the requirements in SharePoint online.

How to provide site collection admin access?

Set-SPOUser -site  https://sr7yn.sharepoint.com/sites/TestPublic -LoginName $SiteCollectionAdmin -IsSiteCollectionAdmin $True

How to enable and disable custom scripting?

Set-SPOSite  https://sr7yn.sharepoint.com/sites/TestPublic -DenyAddAndCustomizePages $False

How to enable external sharing?

Set-SPOSite -Identity  https://sr7yn.sharepoint.com/sites/TestPublic -SharingCapability ExternalUserSharingOnly

How to remove external user from admin centre?

$ExternalUserEmail = "Phani_xyz.onmicrosoft.com#EXT#@abc.onmicrosoft.com"

$ExternalUser = Get-SPOExternalUser -filter $ExternalUserEmail

Remove-SPOExternalUser -UniqueIDs @($ExternalUser.UniqueId) -Confirm:$false

How to lock the site in SharePoint site?

Set-SPOSite -Identity https://sr7yn.sharepoint.com/sites/TestPublic -LockState ReadOnly

Set-SPOSite -Identity https://sr7yn.sharepoint.com/sites/TestPublic -LockState unlock

Read More»

cannot be loaded because running scripts is disabled on this system

cannot be loaded because running scripts is disabled on this system.

When we are trying to run the script from Power Shell ISE , we got this error message as per the below screen shot

Issue Description:

File C:\Users\Raavi\Documents\CreateFolders.ps1 cannot be loaded because running scripts is disabled on this system. For more information, see

about_Execution_Policies at https:/go.microsoft.com/fwlink/?LinkID=135170.

    + CategoryInfo          : SecurityError: (:) [], ParentContainsErrorRecordException

    + FullyQualifiedErrorId : UnauthorizedAccess

Solution : This issue will happened when running script is disabled in our machine , to run the script 

Opened PowerShell ISE and ran this command 

Get-ExecutionPolicy

we can see the status as per the below 

Run this command this will allow us to run the scripts 

set-ExecutionPolicy RemoteSigned -Scope CurrentUser

After clicking on Yes  ,  we can again check the status Get-ExecutionPolicy

Now we are getting status as RemoteSigned , able to run scripts successfully.

Hope this will helps!!  

Read More»

Enable app catalog at site collection level using PowerShell

Enable app catalog at site collection level using PowerShell. 

In SharePoint Online we can deploy apps, SPX solutions based on our requirement to appcatalog at site collection, once we deployed at app catalog site collection solution will be available for all site collections and developers need to contact admins to deploys apps multiple times this will impact on project deliverable’s. 
To avoid this, we can enable app catalog at site collection level itself using PowerShell. 
To deploy apps at site collection level we need to enable app catalog at site collection level using PowerShell, for enabling we should require Tenant admin access (For me it is working fine with SharePoint Admin access) and to deploy apps required site collection admin access. 

To enable App catalog for multiple site collections based on our Input file. Create a CSV file  as per the below format . 

SiteURL 

https://dotnetsharepoint.sharepoint.com/sites/Site1 
https://dotnetsharepoint.sharepoint.com/sites/Site2 
https://dotnetsharepoint.sharepoint.com/sites/Site3 

 Code  

 # SharePoint Admin URl 
$AdminURL = "https://dotnetsharepoint-admin.sharepoint.com" 
 $Cred = Get-Credential 
 #Connect to SharePoint Online 
Connect-SPOService -Url $AdminURL -Credential $Cred 
 #sites from csv 
$sites = Import-Csv -Path "D:\SitesInput.csv" 
 #Get sites one by one 
foreach($row in $sites) 
{ 
     $site = Get-SPOSite -Identity $row.SiteURL 
    $sitecollURL = $site.Url  
     Add-SPOSiteCollectionAppCatalog -Site $sitecollURL 
    Write-Host $sitecollURL 
  }  
 
 
 

Read More»

New-SPConfigurationDatabase : The user does not exist or is not unique

When we are trying to install SharePoint 2016 using PowerShell we got the below error.

“New-SPConfigurationDatabase : The user does not exist or is not unique ” as per the below screen we face the issue.

Resolution: Make sure once you run this command in the PowerShell credential popup window will come.

New-SPConfigurationDatabase –DatabaseName SharePoint_Config –DatabaseServer DNSP2016 –AdministrationContentDatabaseName SharePoint_Content –Passphrase (ConvertTo-SecureString DotNetSharePoint2016–AsPlaintext –Force) –FarmCredentials (Get-Credential) -localserverrole SingleServerFarm

We have to enter MachineName\UserName  as per the above screen shot.

Read More»

Monitoring disk space utilization using powershell

Monitoring disk space utilization is an important task in SharePoint to avoid the critical issues , we can implemented this using PowerShell to monitor the disk utilization , in this we did not kept any threshold conditions , we are generating only report in CSV format with list of all servers available  in our  environment.

We created a config file to add all servers that you want to know the disk space utilization.

Added the server names as per the below screen shot in the text file.

Send email to members of SharePoint Group using PowerShell

Who created list in SharePoint using PowerShell

Please note: we are generating this only in CSV format, it is a plane text we cannot add any colors in our output file.

Add-PSSnapin microsoft.sharepoint.powershell

$resultsarray = @()

$computers = (Get-Content "d:\Allservers.txt")

$date = Get-Date -Format “dd-MM-yyyy”

foreach($computer in $computers)

{

if([string]::isnullorwhitespace($computer))

{

}

else

{

Write-Host $computer

 $drives = Get-WmiObject -ComputerName $computer Win32_LogicalDisk | Where-Object {$_.DriveType -eq 3}

 foreach($drive in $drives)

 {

  $contactObject = new-object PSObject

   $id = $drive.DeviceID

 $totalsize = [math]::round($drive.Size /1GB, 2)

 $freespace = [math]::round($drive.FreeSpace  / 1GB, 2)

 $usedspace= $totalsize-$freespace

 $freeprecent = [math]::round($freespace / $totalsize, 2) * 100

 $diskObject | add-member -membertype NoteProperty -name "Date" -Value $date

 $diskObject | add-member -membertype NoteProperty -name "Server Name" -Value $computer

 $diskObject | add-member -membertype NoteProperty -name "Drive" -Value $id

  $diskObject | add-member -membertype NoteProperty -name "Total GB" -Value  $totalsize     
   $diskObject | add-member -membertype NoteProperty -name "Used GB" -Value $usedspace   
 $diskObject | add-member -membertype NoteProperty -name "Free GB" -Value $freespace  
    $diskObject | add-member -membertype NoteProperty -name "% Free" -Value $freeprecent  
$resultsarray += $diskObject

}

}

}

$resultsarray| Export-csv -path "D:\diskreport_$date.csv" –notypeinformation

Delete SharePoint list items based on particular view using PowerShell

Read More»

Send email to members of SharePoint Group using PowerShell

In this article we can see how to send email only from a particular group of people using power shell, it is very easy to user to remove/add new users whenever they want. In the below code we created a SharePoint Group with name “DotNetSharePoint”

 how to send email using powershell in sharepoint

add-pssnapin microsoft.sharepoint.powershell

$web = get-spweb -identity  "http://dotnetsharepoint.com/sites/SharePoint2013/BusinessUsers"

$groupss = $web.Groups.GetByName("DotNetSharePoint")

$emailgrouptoo =@()

foreach($user in $groupss.Users)

{

$sendemailto  =  $user.Email

$totalemail =  $sendemailto

  $emailgrouptoo+=$totalemail

 }

#You can also get this below information from Custom List also , in the article we are mainly showing how to send email to Owners Group Using PowerShell.

$smtpserver = "yourSMTP severname"

$emailfrm  =  "emailidfrom whom you have to send this email"

$Subject =  "We are sending email to Users"

$EmailBody  = "You type some information which you want to show in side the email body"

 send-mailmessage -smtpserver $smtpserver -from $emailfrm -to $emailgrouptoo  -subject $Subject -body $EmailBody

Read More»

Delete SharePoint list items based on particular view using PowerShell

In this article you can able to see how to delete  SharePoint list items based on the particular view and also having another condition how have to delete items on every Monday, we created a couple of views what type of data have to delete based on item created date.

One view is used to delete SharePoint list items every day and another delete only on Monday.

Note:  by default list item limit is 30 items, we have to modify the view based on the requirement I change to 5000 so every day it will delete only 5000 items to delete.

add-pssnapin microsoft.sharepoint.powershell

$web = get-spweb -identity "http://dotnetsharepoint.com/sites/sharepoint/deleteitems"

$MainList = $web.lists["DeleteListItems"];

$today = (get-date).DayOfWeek

if($today -eq "Monday")

{

$view = $MainList.Views["DeleteMondaylistitems"];

}   

else

{

$view = $MainList.Views["DeleteEverydaylistitems"];

}

$items = $MainList.GetItems($view)

$totalcount = $items.Count

$j = 0;

for($i = $totalcount -1; $i -ge 0; $i--)

{

$deleteitem = $items[$i]

write-host $deleteitem.ID

$deleteitem.Delete()

}

Read More»

Who Created Site Collection using PowerShell

In this article we can able to see who created the site collection with username and time using PowerShell.

In our environment we are having so many site collection, due to some reasons we need to know who created the site collection and when he created the site with data and time information.

The below PowerShell Script is very useful to get the basic information who created the site collection.

add-pssnapin microsoft.sharepoint.powershell

$site = Get-SPSite http://dotnetsharepoint.com/

$site.RootWeb.Author

$site.RootWeb.Created

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

Read More»

Who created list in SharePoint using PowerShell

In this article we can learn, who created the list with name and date using PowerShell.

Import and Export document library in SharePoint PowerShell

How to Create Self-Signed Certificate on IIS Server 

Adding Certificate into SharePoint Central Administration

This script is very useful to know who created the list with created username and created date with time in any environment like Dev, QA and Prod using PowerShell.

Here we are having a list someone created long time back but as of now we don’t know who created this list, using below PowerShell script we can get it easily.

Add-PSSnapin microsoft.sharepoint.powershell

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

$list = $web.lists["listname"]

$listwhocreated = $list.Author

$listcreateddate = $list.Created

Write-Host "Created User Name:" $listwhocreated

Write-Host "Created Date:" $listcreateddate

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

Read More»

Import and Export document library in SharePoint PowerShell

In this article we can able to see how to export and import document library using PowerShell, here we need to get all version document modified history and including users.

How to get field empty values in SharePoint usingPowerShell

The attempted operation is prohibited because it exceedsthe list view threshold enforced by the administrator

 Enter only numbers in text box in SharePoint

Now using the below script we are exporting in to our local D drive.

Export-SPWeb http://dotsharepoint.com/sites/SP/Documentsite/ –Path "D:\Documents.cmp" -ItemURL "Shared%20Documents" –IncludeUserSecurity  -IncludeVersions All

Now using the below script we are importing to another SharePoint site

Export-SPWeb http://dotsharepoint.com/sites/SPSite/NewDocuments/ –Path "D:\Documents.cmp" – force  –IncludeUserSecurity

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

Read More»

How to get field empty values in SharePoint using PowerShell

In this article we can able to see how to get the empty values in a field with count using PowerShell

We are having list with more than 10k items in that we are have a field with Status, now we have to know for this particular filed having empty values.

Add-PSSnapin microsoft.sharepoint.powershell

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

$list = $web.lists["ListName"] 

  $i = 0;

write-host $list

$items = $list.items

 #Go through all items

foreach($item in $items)

{

 $mystring = $item["Status"]

IF([string]::IsNullOrEmpty($mystring))

{

write-host  $item.ID

$i = $i+1

}

 }

Write-host "total final items" $i

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

Read More»

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

In this article we are copying values from one list to another list in SharePoint using PowerShell

Here we are having two list LISTA and LISTB.

Reduce one day in SharePoint list Column using PowerShell
Disable list throttling SharePoint using PowerShell
How to get the date in textbox using JQuery

In both list having field “uniqueid” , using the “uniqueid” only I am updating values from LISTB to LISTA. In LISTB having more fields we need to copy the value from LISTB to LISTA , using camel query we are getting the value from LISTA in to this variable “$item['uniqueid']” and in FieldRef Name  we have to give the LISTB  field name.

Below is the script to update the items.

Add-PSSnapin Microsoft.sharepoint.powershell

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

      write-host $web

    $Source =$web.Lists["LISTA"]           

     $Dest = $web.lists["LISTB”]

     write-host = $Source

     Write-host = $Dest

                            

    $items = $Source.items

    foreach ($item in $items) {

  

      $camlQuery ="<Where><Eq><FieldRef Name='uniqueid' /><Value Type='Text'>"+$item['uniqueid']+"</Value></Eq></Where>"

        $spQuery = new-object Microsoft.SharePoint.SPQuery

        $spQuery.Query = $camlQuery

        $spQuery.RowLimit = 1

        #check if the item is already present in destination list

         $ditems =  $Dest.GetItems($spQuery)

             $item["UserName"] = $ditems[0]["UserName"] 

 $modifiedBy = $item["Editor"]

$modifieddate =$item["Modified"]

Write-Host $item.ID

$item["Editor"] = $modifiedBy

$item["Modified"] = $modifieddate

$item.Update()

$Source.Update()

#Write-Host $count+1

        }

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

Read More»