Peter

This user hasn't shared any biographical information

Posts by Peter

SharePoint 2013 Hosting UK – HostForLIFE.eu :: Reading The SharePoint News Using Rest API In SPFx

Sep 6th

Posted by Peter in European SharePoint 2013 Hosting

Sharing news among employees is a big challenge for any organization. The Intranet is a possible solution. Companies can develop digital intranet as a communication and collaboration tool with all the custom settings they prefer.

But still, we can’t avoid news from SharePoint sites. Let’s see how to read the published SharePoint news through Rest API using SPFx.

SharePoint Search

SharePoint is one of the most powerful tools in its search feature. It allows looking for the data across sites/tenants. The same concept is going to help us to read the promoted news from the SharePoint sites.

There are already a lot of REST API URLs available to search data in SharePoint like people search and document search using specific id’s. Let’s jump into the implementation. Here the main key parameter to find the published news is with its promoted state. If the promoted state of a piece of news is set to 2 then that means the news will be published and available for everyone to read.

Below is the URL to get the promoted news from a site.

{SiteUrl}/_api/search/query?querytext=’IsDocument:True AND FileExtension:aspx AND PromotedState:2′

Here you can define the search scope with a slight change in the URL. Let’s say we have a site called Intranet and you want to search the promoted news only within that site, the URL will be like below,
https://tenantName.sharepoint/com/sites/Intranet/_api/search/query?querytext=’IsDocument:True AND FileExtension:aspx AND PromotedState:2′

If you want to get all the published news from all the sites across the tenant then your site URL in the REST API URL must point to SharePoint search site and the URL will look like below,
https://tenantName.sharepoint/com/search/_api/search/query?querytext=’IsDocument:True AND FileExtension:aspx AND PromotedState:2′

Don’t worry that you need to authenticate two different sites as SPFx takes care of it internally, that’s the beauty of SharePoint Framework apps. If the current user has permission over the entity he can play around with it, otherwise he can’t.

Error – Microsoft.SharePoint.Client.UnknownError

Before going to the actual code sample, let me show you the expected error and solution for that. We might end up the with weird error Microsoft.SharePoint.Client.UnknownError.

Office 365 API’s use OData v4.0 protocol for exchanging data between the client and the server like below,

Accept: application/json;odata.metadata=minimal  
OData-Version: 4.0

1 2	Accept: application/json;odata.metadata=minimal OData-Version: 4.0

If the same headers are used in SharePoint Search API in Search site then we will end up with the below error,

{  
    "error": {  
        "code": "-1,  
        Microsoft.SharePoint.Client.UnknownError ",  
        "message": "Unknown Error"  
    }  
}

{

"error": {

"code": "-1,

Microsoft.SharePoint.Client.UnknownError ",

"message": "Unknown Error"

}

The same protocol will work fine in all other SharePoint API’s except Search API. So, it’s better to use OData v3.0 protocol in SharePoint Search API like the below code snippet.

Code Snippet

let spOpts = {  
    headers: {  
        'odata-version': '3.0',  
        'Content-Type': 'application/json; odata=verbose'  
    }  
};  
this.context.spHttpClient.get(requestUrl, SPHttpClient.configurations.v1, spOpts).then((response: SPHttpClientResponse) => {  
    if (response.ok) {  
        response.json().then((responseJSON) => {  
            if (responseJSON != null) {  
                let searchResult: any = responseJSON;  
            }  
        });  
    }  
});

let spOpts = {

headers: {

'odata-version': '3.0',

'Content-Type': 'application/json; odata=verbose'

}

};

this.context.spHttpClient.get(requestUrl, SPHttpClient.configurations.v1, spOpts).then((response: SPHttpClientResponse) => {

if (response.ok) {

response.json().then((responseJSON) => {

if (responseJSON != null) {

let searchResult: any = responseJSON;

}

});

}

});

How to get the name of the Site in SharePoint Search Result?
As we search the entire tenant for the news, how do we differentiate the news of different sites?

Yes, we do get the Path/OriginalPath of the news page and we do have the site URL in that, but that’s not the efficient way to do it. In SharePoint, there is a default Managed Metadata property called “SiteTitle”, which will exactly give you the site name from which the news is from.

To get the SiteTitle you need to select it using the selectProperties in the REST Url like below,

https://tenantName.sharepoint/com/search/_api/search/query?querytext='IsDocument:True AND FileExtension:aspx AND PromotedState:2' &selectproperties='Title,Author,PictureThumbnailURL,SiteTitle,SPWebUrl,OriginalPath,LastModifiedTime,ViewsLifeTime,ViewsRecent,LikesCount,PromotedState’

1	https://tenantName.sharepoint/com/search/_api/search/query?querytext='IsDocument:True AND FileExtension:aspx AND PromotedState:2' &selectproperties='Title,Author,PictureThumbnailURL,SiteTitle,SPWebUrl,OriginalPath,LastModifiedTime,ViewsLifeTime,ViewsRecent,LikesCount,PromotedState’

I hope you have got to know about SharePoint news, and the search feature to crawl the published news. Follow my next blog to know about handling the SharePoint search result row limit.

If you have any questions/issues about this article, please let me know in the comments.

SharePoint 2013 Hosting UK – HostForLIFE.eu :: PowerShell to Get/Add/Remove Users of Local Administrator Group

Aug 23rd

Posted by Peter in European SharePoint 2013 Hosting

No comments

This article outlines how to get, add and remove users of a local administrator group on SharePoint servers using a PowerShell script.

Local Administrators

The script does the following functionality.

Gets the local administrators of the machine.
Adds a user to the local administrator of the machine (the user must enter the user details into the AddUsers.csv file and place it under the folder where the PowerShell script exists).
Removes a user from the local administrator of the machine (the user must enter the user details into the RemoveUsers.csv file and place it under the folder where the PowerShell script exists).

Get the local administrators of the machine
The following piece of code gets the users under the local administrator group of the machine.

    Function GetServerAdministrators([Microsoft.SharePoint.Administration.SPFarm]$farm)  
    {  
        write-host ""  
        write-host "Preparing to collect SP server administrator details" -fore magenta  
        $output = $scriptbase + "\" + "ServerAdminDetails.csv"  
        "ServerName" + "," + "AdminMember" | Out-File -Encoding Default -FilePath $Output;  
    foreach($server in $farm.Servers)  
    {  
        foreach($instance in $server.ServiceInstances)  
        {  
              if($instance.TypeName -eq $timerServiceInstanceName)  
            {  
                [string]$serverName = $server.Name  
                write-host "Collecting administrator details for the server " $servername -fore yellow  
                $admins = invoke-command {net localgroup administrators | where {$_ -AND $_ -notmatch           "command completed successfully"} | select -skip 4} -computer $serverName  
                foreach($admin in $admins)  
                {  
                    write-host $admin " is member of administrator group in server " $serverName                -fore cyan  
                    $serverName + "," + $admin | Out-File -Encoding Default -Append -FilePath               $Output;  
                }  
        write-host "Administrator details for the server " $serverName " has been collected" -fore green  
            }  
        }  
    }  
    Write-host "Administrator details collected for all the SP servers in the farm" -fore green  
      }

Function GetServerAdministrators([Microsoft.SharePoint.Administration.SPFarm]$farm)

{

write-host ""

write-host "Preparing to collect SP server administrator details" -fore magenta

$output = $scriptbase + "\" + "ServerAdminDetails.csv"

"ServerName" + "," + "AdminMember" | Out-File -Encoding Default -FilePath $Output;

foreach($server in $farm.Servers)

{

foreach($instance in $server.ServiceInstances)

{

if($instance.TypeName -eq $timerServiceInstanceName)

{

[string]$serverName = $server.Name

write-host "Collecting administrator details for the server " $servername -fore yellow

$admins = invoke-command {net localgroup administrators | where {$_ -AND $_ -notmatch "command completed successfully"} | select -skip 4} -computer $serverName

foreach($admin in $admins)

{

write-host $admin " is member of administrator group in server " $serverName -fore cyan

$serverName + "," + $admin | Out-File -Encoding Default -Append -FilePath $Output;

}

write-host "Administrator details for the server " $serverName " has been collected" -fore green

}

Write-host "Administrator details collected for all the SP servers in the farm" -fore green

}

Add users to the local administrator of the machine

The following piece of code helps to add the users to the local administrator group on the SharePoint servers.

    Function AddUserToServerAdminGroup([String]$AdminMember, [String]$ServerName)  
    {  
        $ans = read-host "Do you want to add user $AdminMember to server $ServerName (y/n)? "  
        if($ans -eq 'y')  
        {  
            write-host "Adding user " $AdminMember " to administrator group on server " $ServerName -fore   yellow  
        $AdminMember1 = $AdminMember.split("\")  
        $AdminMember2 = $AdminMember1[0] + "/" + $AdminMember1[1]  
        $GroupObj = [ADSI]"WinNT://$ServerName/Administrators"  
        $GroupObj.Add("WinNT://$AdminMember2")  
        write-host $AdminMember " added to the local administrator group on the server " $ServerName -fore  green  
        }  
        else  
        {  
        write-host "User choose not to add user " $AdminMember " to the server " $ServerName " administrator    group" -fore cyan  
        }  
    }

Function AddUserToServerAdminGroup([String]$AdminMember, [String]$ServerName)

{

$ans = read-host "Do you want to add user $AdminMember to server $ServerName (y/n)? "

if($ans -eq 'y')

{

write-host "Adding user " $AdminMember " to administrator group on server " $ServerName -fore yellow

$AdminMember1 = $AdminMember.split("\")

$AdminMember2 = $AdminMember1[0] + "/" + $AdminMember1[1]

$GroupObj = [ADSI]"WinNT://$ServerName/Administrators"

$GroupObj.Add("WinNT://$AdminMember2")

write-host $AdminMember " added to the local administrator group on the server " $ServerName -fore green

}

else

{

write-host "User choose not to add user " $AdminMember " to the server " $ServerName " administrator group" -fore cyan

}

Remove users from local administrator of the machine
The following piece of code helps to remove the users from the local administrator group on the SharePoint servers.

Function RemoveUserFromServerAdminGroup([String]$AdminMember, [String]$ServerName)  
{  
    $ans = read-host "Do you want to remove user $AdminMember from server $ServerName (y/n)? "  
    if($ans -eq 'y')  
    {  
        write-host "Removing user " $AdminMember " from administrator group on server " $ServerName -       fore yellow  
        $AdminMember1 = $AdminMember.split("\")  
        $AdminMember2 = $AdminMember1[0] + "/" + $AdminMember1[1]  
        $GroupObj = [ADSI]"WinNT://$ServerName/Administrators"  
        $GroupObj.Remove("WinNT://$AdminMember2")  
        write-host $AdminMember " removed from the local administrator group on the server "        $ServerName -fore green  
    }  
    else  
    {  
    write-host "User choose not to remove user " $AdminMember " from the server " $ServerName "     administrator group" -fore cyan  
    }  
}

Function RemoveUserFromServerAdminGroup([String]$AdminMember, [String]$ServerName)

{

$ans = read-host "Do you want to remove user $AdminMember from server $ServerName (y/n)? "

if($ans -eq 'y')

{

write-host "Removing user " $AdminMember " from administrator group on server " $ServerName - fore yellow

$AdminMember1 = $AdminMember.split("\")

$AdminMember2 = $AdminMember1[0] + "/" + $AdminMember1[1]

$GroupObj = [ADSI]"WinNT://$ServerName/Administrators"

$GroupObj.Remove("WinNT://$AdminMember2")

write-host $AdminMember " removed from the local administrator group on the server " $ServerName -fore green

}

else

{

write-host "User choose not to remove user " $AdminMember " from the server " $ServerName " administrator group" -fore cyan

}

Complete Code

$LogTime = Get-Date -Format yyyy-MM-dd_hh-mm  
$LogFile = ".\GetServerAdministratorsPatch-$LogTime.rtf"  

# Add SharePoint PowerShell Snapin  
  
  
if ( (Get-PSSnapin -Name Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue) -eq $null ) {  
    Add-PSSnapin Microsoft.SharePoint.Powershell  
}  
import-module WebAdministration  
  
$scriptBase = split-path $SCRIPT:MyInvocation.MyCommand.Path -parent  
Set-Location $scriptBase  
  
write-host "TESTING FOR LOG FOLDER EXISTENCE" -fore yellow  
$TestLogFolder = test-path -path $scriptbase\Logs  
if($TestLogFolder)  
{  
    write-host "The log folder already exist in the script location" -fore yellow  
    $clearlogfolder = read-host "Do you want to clear the log folder (y/n)"  
    if($clearlogfolder -eq 'y')  
    {  
        write-host "The user choosen to clear the log folder" -fore yellow  
        write-host "Clearing the log folder" -fore yellow  
        remove-item $scriptbase\Logs\* -recurse -confirm:$false  
        write-host "Log folder cleared" -fore yellow  
    }  
    else  
    {  
        write-host "The user choosen not to clear the log files" -fore yellow  
    }  
}  
else  
{  
    write-host "Log folder does not exist" -fore yellow  
    write-host "Creating a log folder" -fore yellow  
    New-Item $Scriptbase\Logs -type directory  
    write-host "Log folder created" -fore yellow  
}         

#moving any .rtf files in the scriptbase location  
$FindRTFFile = Get-ChildItem $scriptBase\*.* -include *.rtf  
if($FindRTFFile)  
{  
    write-host "Some old log files are found in the script location" -fore yellow  
    write-host "Moving old log files into the Logs folder" -fore yellow  
    foreach($file in $FindRTFFile)  
        {  
            move-item -path $file -destination $scriptbase\logs  
        }  
    write-host "Old log files moved successfully" -fore yellow  
}  
  
start-transcript $logfile  
  
$global:timerServiceName = "SharePoint 2010 Timer"  
$global:timerServiceInstanceName = "Microsoft SharePoint Foundation Timer"  

# Get the local farm instance  
[Microsoft.SharePoint.Administration.SPFarm]$farm = [Microsoft.SharePoint.Administration.SPFarm]::get_Local()  
  
Function GetServerAdministrators([Microsoft.SharePoint.Administration.SPFarm]$farm)  
{  
  
    write-host ""  
    write-host "Preparing to collect SP server administrator details" -fore magenta  
  
    $output = $scriptbase + "\" + "ServerAdminDetails.csv"  
    "ServerName" + "," + "AdminMember"  | Out-File -Encoding Default -FilePath $Output;  
  
    foreach($server in $farm.Servers)  
        {  
        foreach($instance in $server.ServiceInstances)  
                {  
              
                      if($instance.TypeName -eq $timerServiceInstanceName)  
            {  
                          [string]$serverName = $server.Name  
                write-host "Collecting administrator details for the server " $servername -fore yellow  
                $admins = invoke-command {net localgroup administrators | where {$_ -AND $_ -notmatch "command completed successfully"} | select -skip 4} -computer $serverName  
                foreach($admin in $admins)  
                {  
                    write-host $admin " is member of administrator group in server " $serverName -fore cyan  
                    $serverName + "," + $admin | Out-File -Encoding Default  -Append -FilePath $Output;  
                }  
                write-host "Administrator details for the server " $serverName " has been collected" -fore green  
            }  
        }  
    }  
    Write-host "Administrator details collected for all the SP servers in the farm" -fore green  
  
}  
  
  
Function AddUserToServerAdminGroup([String]$AdminMember, [String]$ServerName)  
{  
  
    $ans = read-host "Do you want to add user $AdminMember to server $ServerName (y/n)? "  
    if($ans -eq 'y')  
    {  
        write-host "Adding user " $AdminMember " to administrator group on server " $ServerName -fore yellow  
          
        $AdminMember1 = $AdminMember.split("\")  
        $AdminMember2 = $AdminMember1[0] + "/" + $AdminMember1[1]  
          
        $GroupObj = [ADSI]"WinNT://$ServerName/Administrators"  
        $GroupObj.Add("WinNT://$AdminMember2")  
        write-host $AdminMember " added to the local administrator group on the server " $ServerName -fore green  
    }  
    else  
    {  
        write-host "User choose not to add user " $AdminMember " to the server " $ServerName " administrator group" -fore cyan  
    }  
  
}  
  
  
Function RemoveUserFromServerAdminGroup([String]$AdminMember, [String]$ServerName)  
{  
  
    $ans = read-host "Do you want to remove user $AdminMember from server $ServerName (y/n)? "  
    if($ans -eq 'y')  
    {  
        write-host "Removing user " $AdminMember " from administrator group on server " $ServerName -fore yellow  
          
        $AdminMember1 = $AdminMember.split("\")  
        $AdminMember2 = $AdminMember1[0] + "/" + $AdminMember1[1]  
          
        $GroupObj = [ADSI]"WinNT://$ServerName/Administrators"  
        $GroupObj.Remove("WinNT://$AdminMember2")  
        write-host $AdminMember " removed from the local administrator group on the server " $ServerName -fore green  
    }  
    else  
    {  
        write-host "User choose not to remove user " $AdminMember " from the server " $ServerName " administrator group" -fore cyan  
    }  
  
}  
  
write-host "########################################################################################################" -fore cyan  
write-host "Enter 1 to get the SP server administrator details" -fore green  
write-host "Enter 2 to add users to local administrator group" -fore green  
write-host "Enter 3 to remove users from local administrator group" -fore green  
write-host "########################################################################################################" -fore cyan  
  
  
$option = read-host "Enter the option "  
  
switch($option)  
  
{  
  
    1{  
        GetServerAdministrators $farm  
      }  
  
    2{  
        write-host "Preparing to add users to the server administrator group" -fore magenta  
        $csvfile = $scriptbase + "\" + "AddUsers.csv"  
        import-csv $csvfile | where {  
        AddUserToServerAdminGroup $_.AdminMember $_.ServerName  
        }  
        write-host "Users has been added to local administrators group" -fore green  
      }  
  
    3{  
        write-host "Preparing to remove users from the server administrator group" -fore magenta  
        $csvfile1 = $scriptbase + "\" + "RemoveUsers.csv"  
        import-csv $csvfile1 | where {  
        RemoveUserFromServerAdminGroup $_.AdminMember $_.ServerName  
        }  
        write-host "Users has been removed from local administrators group" -fore green       
      }  
  
}  
  
stop-transcript

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

$LogTime = Get-Date -Format yyyy-MM-dd_hh-mm

$LogFile = ".\GetServerAdministratorsPatch-$LogTime.rtf"

# Add SharePoint PowerShell Snapin

if ( (Get-PSSnapin -Name Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue) -eq $null ) {

Add-PSSnapin Microsoft.SharePoint.Powershell

}

import-module WebAdministration

$scriptBase = split-path $SCRIPT:MyInvocation.MyCommand.Path -parent

Set-Location $scriptBase

write-host "TESTING FOR LOG FOLDER EXISTENCE" -fore yellow

$TestLogFolder = test-path -path $scriptbase\Logs

if($TestLogFolder)

{

write-host "The log folder already exist in the script location" -fore yellow

$clearlogfolder = read-host "Do you want to clear the log folder (y/n)"

if($clearlogfolder -eq 'y')

{

write-host "The user choosen to clear the log folder" -fore yellow

write-host "Clearing the log folder" -fore yellow

remove-item $scriptbase\Logs\* -recurse -confirm:$false

write-host "Log folder cleared" -fore yellow

}

else

{

write-host "The user choosen not to clear the log files" -fore yellow

}

else

{

write-host "Log folder does not exist" -fore yellow

write-host "Creating a log folder" -fore yellow

New-Item $Scriptbase\Logs -type directory

write-host "Log folder created" -fore yellow

}

#moving any .rtf files in the scriptbase location

$FindRTFFile = Get-ChildItem $scriptBase\*.* -include *.rtf

if($FindRTFFile)

{

write-host "Some old log files are found in the script location" -fore yellow

write-host "Moving old log files into the Logs folder" -fore yellow

foreach($file in $FindRTFFile)

{

move-item -path $file -destination $scriptbase\logs

}

write-host "Old log files moved successfully" -fore yellow

}

start-transcript $logfile

$global:timerServiceName = "SharePoint 2010 Timer"

$global:timerServiceInstanceName = "Microsoft SharePoint Foundation Timer"

# Get the local farm instance

[Microsoft.SharePoint.Administration.SPFarm]$farm = [Microsoft.SharePoint.Administration.SPFarm]::get_Local()

Function GetServerAdministrators([Microsoft.SharePoint.Administration.SPFarm]$farm)

{

write-host ""

write-host "Preparing to collect SP server administrator details" -fore magenta

$output = $scriptbase + "\" + "ServerAdminDetails.csv"

"ServerName" + "," + "AdminMember" | Out-File -Encoding Default -FilePath $Output;

foreach($server in $farm.Servers)

{

foreach($instance in $server.ServiceInstances)

{

if($instance.TypeName -eq $timerServiceInstanceName)

{

[string]$serverName = $server.Name

write-host "Collecting administrator details for the server " $servername -fore yellow

$admins = invoke-command {net localgroup administrators | where {$_ -AND $_ -notmatch "command completed successfully"} | select -skip 4} -computer $serverName

foreach($admin in $admins)

{

write-host $admin " is member of administrator group in server " $serverName -fore cyan

$serverName + "," + $admin | Out-File -Encoding Default -Append -FilePath $Output;

}

write-host "Administrator details for the server " $serverName " has been collected" -fore green

}

Write-host "Administrator details collected for all the SP servers in the farm" -fore green

}

Function AddUserToServerAdminGroup([String]$AdminMember, [String]$ServerName)

{

$ans = read-host "Do you want to add user $AdminMember to server $ServerName (y/n)? "

if($ans -eq 'y')

{

write-host "Adding user " $AdminMember " to administrator group on server " $ServerName -fore yellow

$AdminMember1 = $AdminMember.split("\")

$AdminMember2 = $AdminMember1[0] + "/" + $AdminMember1[1]

$GroupObj = [ADSI]"WinNT://$ServerName/Administrators"

$GroupObj.Add("WinNT://$AdminMember2")

write-host $AdminMember " added to the local administrator group on the server " $ServerName -fore green

}

else

{

write-host "User choose not to add user " $AdminMember " to the server " $ServerName " administrator group" -fore cyan

}

Function RemoveUserFromServerAdminGroup([String]$AdminMember, [String]$ServerName)

{

$ans = read-host "Do you want to remove user $AdminMember from server $ServerName (y/n)? "

if($ans -eq 'y')

{

write-host "Removing user " $AdminMember " from administrator group on server " $ServerName -fore yellow

$AdminMember1 = $AdminMember.split("\")

$AdminMember2 = $AdminMember1[0] + "/" + $AdminMember1[1]

$GroupObj = [ADSI]"WinNT://$ServerName/Administrators"

$GroupObj.Remove("WinNT://$AdminMember2")

write-host $AdminMember " removed from the local administrator group on the server " $ServerName -fore green

}

else

{

write-host "User choose not to remove user " $AdminMember " from the server " $ServerName " administrator group" -fore cyan

}

write-host "########################################################################################################" -fore cyan

write-host "Enter 1 to get the SP server administrator details" -fore green

write-host "Enter 2 to add users to local administrator group" -fore green

write-host "Enter 3 to remove users from local administrator group" -fore green

write-host "########################################################################################################" -fore cyan

$option = read-host "Enter the option "

switch($option)

{

GetServerAdministrators $farm

}

write-host "Preparing to add users to the server administrator group" -fore magenta

$csvfile = $scriptbase + "\" + "AddUsers.csv"

import-csv $csvfile | where {

AddUserToServerAdminGroup $_.AdminMember $_.ServerName

}

write-host "Users has been added to local administrators group" -fore green

}

write-host "Preparing to remove users from the server administrator group" -fore magenta

$csvfile1 = $scriptbase + "\" + "RemoveUsers.csv"

import-csv $csvfile1 | where {

RemoveUserFromServerAdminGroup $_.AdminMember $_.ServerName

}

write-host "Users has been removed from local administrators group" -fore green

}

stop-transcript

Execution Procedure

Download and copy the script folder to the SharePoint server.
Launch the SharePoint management shell.
Navigate to the script path and execute the script.

Enter the desired option.

SharePoint 2013 Hosting UK – HostForLIFE.eu :: Find Default Page And Approve It Using Powershell In SPO

Aug 21st

Posted by Peter in European SharePoint 2013 Hosting

No comments

Basically in SPO, default.aspx are discontinued however while migration default pages also get migrated. Here this piece of code finding default pages as it may set up Homepage of sites.

Here, we are finding those default pages across site and subsites and approving it along with the particular user who created or modified.

    #Passing inputs through CSV file  
    # Pass Site URL and Library Name as Inputs.  
    Param(  
        [Parameter(Mandatory = $true)]  
        [string] $Csv)  
    # Pass your DLL 's   
    Add - Type - Path "C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll"  
    Add - Type - Path "C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll"  
    Add - Type - Path "C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Publishing.dll"  
    Import - Module Microsoft.Online.SharePoint.PowerShell  
    # Not required  
    for on premise site - Start  
    $userId = "xxxx@msdcloud.onmicrosoft.com"  
    $pwd = Read - Host - Prompt "Enter password" - AsSecureString  
    $creds = New - Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($userId, $pwd)  
    $root = Import - Csv $Csv  
    foreach($record in $root) {  
        $TargetSite = $record.SharePointUrl  
        $LibraryName = $record.LibraryName  
        $ctx = New - Object Microsoft.SharePoint.Client.ClientContext($TargetSite)  
        # Not required  
        for on premise site - Start  
        $ctx.credentials = $creds  
        # Iterating across subsites and finding  
        default pages.  
        $web = $ctx.Web  
        $ctx.Load($web.Webs)  
        $ctx.ExecuteQuery()  
        if ($web.Webs.Count - gt 0) {  
            foreach($AllWeb in $web.Webs) {  
                try {#  
                    Get all files from the Library  
                    $List = $AllWeb.Lists.GetByTitle($LibraryName)  
                    $q = New - Object Microsoft.SharePoint.Client.CamlQuery  
                    $q.ViewXml = "<View Scope='RecursiveAll' />"  
                    $Items = $List.GetItems($q)  
                    $ctx.Load($Items)  
                    $ctx.ExecuteQuery()  
                    $FileName = "default.aspx"  
                    Foreach($Item in $Items) {  
                        $File = $Item["FileRef"].Substring($Item["FileRef"].LastIndexOf("/") + 1)  
                        if ($File - eq $FileName) {  
                            if ($Item["_ModerationStatus"] - eq "2" - and($Item["Editor"].LookupValue - eq("xxxUserName") - or $Item["Editor"].LookupValue - eq("xxxUserName"))) {  
                                $Item["_ModerationStatus"] = "0"  
                                $Item.Update()  
                                $ctx.ExecuteQuery()  
                                write - host "done"  
                            }  
                        }  
                    }  
                } catch {  
                    $_ | Out - File errors.txt - Append  
                }  
            }  
        }  
        if ($web.Webs.Count - eq 0) {  
            try {  
                #Get all files from the Library  
                $List = $AllWeb.Lists.GetByTitle($LibraryName)  
                $q = New - Object Microsoft.SharePoint.Client.CamlQuery  
                $q.ViewXml = "<View Scope='RecursiveAll' />"  
                $Items = $List.GetItems($q)  
                $ctx.Load($Items)  
                $ctx.ExecuteQuery()  
                $FileName = "default.aspx"  
                Foreach($Item in $Items) {  
                    $File = $Item["FileRef"].Substring($Item["FileRef"].LastIndexOf("/") + 1)  
                    if ($File - eq $FileName) {  
                        if ($Item["_ModerationStatus"] - eq "2" - and($Item["Editor"].LookupValue - eq("xxxUserName") - or $Item["Editor"].LookupValue - eq("xxxUserName"))) {  
                            $Item["_ModerationStatus"] = "0"  
                            $Item.Update()  
                            $ctx.ExecuteQuery()  
                            write - host "done"  
                        }  
                    }  
                }  
            } catch {  
                $_ | Out - File errors.txt - Append  
            }  
        }  
    }

#Passing inputs through CSV file

# Pass Site URL and Library Name as Inputs.

Param(

[Parameter(Mandatory = $true)]

[string] $Csv)

# Pass your DLL 's

Add - Type - Path "C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll"

Add - Type - Path "C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll"

Add - Type - Path "C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Publishing.dll"

Import - Module Microsoft.Online.SharePoint.PowerShell

# Not required

for on premise site - Start

$userId = "xxxx@msdcloud.onmicrosoft.com"

$pwd = Read - Host - Prompt "Enter password" - AsSecureString

$creds = New - Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($userId, $pwd)

$root = Import - Csv $Csv

foreach($record in $root) {

$TargetSite = $record.SharePointUrl

$LibraryName = $record.LibraryName

$ctx = New - Object Microsoft.SharePoint.Client.ClientContext($TargetSite)

# Not required

for on premise site - Start

$ctx.credentials = $creds

# Iterating across subsites and finding

default pages.

$web = $ctx.Web

$ctx.Load($web.Webs)

$ctx.ExecuteQuery()

if ($web.Webs.Count - gt 0) {

foreach($AllWeb in $web.Webs) {

try {#

Get all files from the Library

$List = $AllWeb.Lists.GetByTitle($LibraryName)

$q = New - Object Microsoft.SharePoint.Client.CamlQuery

$q.ViewXml = "<View Scope='RecursiveAll' />"

$Items = $List.GetItems($q)

$ctx.Load($Items)

$ctx.ExecuteQuery()

$FileName = "default.aspx"

Foreach($Item in $Items) {

$File = $Item["FileRef"].Substring($Item["FileRef"].LastIndexOf("/") + 1)

if ($File - eq $FileName) {

if ($Item["_ModerationStatus"] - eq "2" - and($Item["Editor"].LookupValue - eq("xxxUserName") - or $Item["Editor"].LookupValue - eq("xxxUserName"))) {

$Item["_ModerationStatus"] = "0"

$Item.Update()

$ctx.ExecuteQuery()

write - host "done"

}

} catch {

$_ | Out - File errors.txt - Append

}

if ($web.Webs.Count - eq 0) {

try {

#Get all files from the Library

$List = $AllWeb.Lists.GetByTitle($LibraryName)

$q = New - Object Microsoft.SharePoint.Client.CamlQuery

$q.ViewXml = "<View Scope='RecursiveAll' />"

$Items = $List.GetItems($q)

$ctx.Load($Items)

$ctx.ExecuteQuery()

$FileName = "default.aspx"

Foreach($Item in $Items) {

$File = $Item["FileRef"].Substring($Item["FileRef"].LastIndexOf("/") + 1)

if ($File - eq $FileName) {

if ($Item["_ModerationStatus"] - eq "2" - and($Item["Editor"].LookupValue - eq("xxxUserName") - or $Item["Editor"].LookupValue - eq("xxxUserName"))) {

$Item["_ModerationStatus"] = "0"

$Item.Update()

$ctx.ExecuteQuery()

write - host "done"

}

} catch {

$_ | Out - File errors.txt - Append

}

Moderation Status is a 4-byte integer indicating the moderation approval status of a list item.

Configurations can require moderation approval to publish a list item or allow automatic approval. A published list item MUST have a Moderation Status of 0. The following are all possible valid values for Moderation Status.

SharePoint 2013 Hosting UK – HostForLIFE.eu :: How To Connect To Microsoft Teams Using PowerShell?

Aug 16th

Posted by Peter in European SharePoint 2013 Hosting

No comments

Microsoft Teams PowerShell cmdlets are currently available in beta version and this would be helpful for Microsoft Teams administration and management.

Open PowerShell window and run the following command to Install Microsoft Teams Module.

# Install Microsoft Teams Module  
Install-Module MicrosoftTeams

1 2	# Install Microsoft Teams Module Install-Module MicrosoftTeams

Run the following command to add Teams module to the current session.

# Add MicrosoftTeams Module to the current session  
Import-Module MicrosoftTeams

1 2	# Add MicrosoftTeams Module to the current session Import-Module MicrosoftTeams

Run the following command to connect to Microsoft Teams.

# Get the credentials    
$credentials=Get-Credential   
    
# Connect to Microsoft Teams  
Connect-MicrosoftTeams -Credential $credentials

# Get the credentials

$credentials=Get-Credential

# Connect to Microsoft Teams

Connect-MicrosoftTeams -Credential $credentials

Run the following command to get all the teams.

# Get all the teams   
Get-Team

1 2	# Get all the teams Get-Team

Reference
https://docs.microsoft.com/en-us/powershell/module/teams/?view=teams-ps

Thus in this blog, you saw how to connect to Microsoft Teams using PowerShell for service administration and management.

SharePoint 2013 Hosting UK – HostForLIFE.eu :: How to Overcome Yammer URL Encoding Issues in the Webpart Title?

Aug 14th

Posted by Peter in European SharePoint 2013 Hosting

No comments

In this blog, I will demonstrate how to overcome Yammer URL encoding issues in the webpart title. I have added a content editor webpart to embed a Yammer group feed and it works fine.

Further, we have configured webpart title URL to point to that Yammer group, so that the users can open group conversations in full window. Group link is copied from the address bar of that specific yammer group, as shown below.

https://www.yammer.com/company.com/#/threads/inGroup?type=in_group&feedId=12668139&view=all

Surprisingly, after saving the page webpart, title link didn’t work. After having a close look, I noticed ‘#’ is replaced with ‘%23’.

https://www.yammer.com/company.com/%23/threads/inGroup?type=in_group&feedId=12668139&view=all

Here are some approaches to fix the issue.

URL Formatting

Format yammer group URL as below.

https://www.yammer.com/{network permalink}/groups/{feedId}

Original URL

https://www.yammer.com/company.com/#/threads/inGroup?type=in_group&feedId=12668139&view=all

Formatted URL

https://www.yammer.com/company.com/groups/12668139

Simply Add ‘?’ before ‘#’ (you will like this 🙂 )

https://www.yammer.com/company.com/?#/threads/inGroup?type=in_group&feedId=12668139&view=all

SharePoint 2013 Hosting – HostForLIFE.eu : How To Get All The Lists Which Have Unique Permissions From the Sharepoint Online Site Using PnP PowerShell

Aug 9th

Posted by Peter in European SharePoint 2013 Hosting

No comments

In this blog, you will see how to get all the lists which have unique permissions from the root site as well as sub sites using PnP PowerShell.

You can download setup files from the releases section of the PnP PowerShell repository. Copy the below script and paste it in a notepad. Save the file as GetUniquePermissions.ps1.

# Input Parameters  
$siteURL="https://c986.sharepoint.com/sites/dev"  
  
# foLoop through all the lists and check if the list has unique permissions  
Function GetUniquePermissions($web)  
{  
    $listColl=Get-PnPList -Web $web -Includes HasUniqueRoleAssignments     
    foreach($list in $listColl)  
    {    
        if($list.HasUniqueRoleAssignments)  
        {  
            write-host -ForegroundColor Yellow $list.Title " has unique permissions"  
        }        
    }      
}  
  
# Get the root web and call the GetUniquePermissions function  
Function GetRootWeb()  
{  
    $rootWeb=Get-PnPWeb      
    write-host -ForegroundColor Magenta "Getting information from the website - " $rootWeb.Title " - " $rootWeb.Url  
    GetUniquePermissions($rootWeb);  
}  
  
# Get the all the sub webs and call the GetUniquePermissions function  
Function GetSubWebs()  
{  
    $webColl=Get-PnPSubWebs -Recurse      
    foreach($web in $webColl)  
    {      
        write-host -ForegroundColor Magenta "Getting information from the website - " $web.Title " - " $web.Url  
        GetUniquePermissions($web);  
    }  
}  
  
# Connect to SharePoint Online site  
Connect-PnPOnline –Url $siteURL –Credentials (Get-Credential)  
  
# Call the functions  
GetRootWeb  
GetSubWebs

# Input Parameters

$siteURL="https://c986.sharepoint.com/sites/dev"

# foLoop through all the lists and check if the list has unique permissions

Function GetUniquePermissions($web)

{

$listColl=Get-PnPList -Web $web -Includes HasUniqueRoleAssignments

foreach($list in $listColl)

{

if($list.HasUniqueRoleAssignments)

{

write-host -ForegroundColor Yellow $list.Title " has unique permissions"

}

# Get the root web and call the GetUniquePermissions function

Function GetRootWeb()

{

$rootWeb=Get-PnPWeb

write-host -ForegroundColor Magenta "Getting information from the website - " $rootWeb.Title " - " $rootWeb.Url

GetUniquePermissions($rootWeb);

}

# Get the all the sub webs and call the GetUniquePermissions function

Function GetSubWebs()

{

$webColl=Get-PnPSubWebs -Recurse

foreach($web in $webColl)

{

write-host -ForegroundColor Magenta "Getting information from the website - " $web.Title " - " $web.Url

GetUniquePermissions($web);

}

# Connect to SharePoint Online site

Connect-PnPOnline –Url $siteURL –Credentials (Get-Credential)

# Call the functions

GetRootWeb

GetSubWebs

Open PowerShell window and run the following command.

>cd "<folderlocation>"

1	>cd "<folderlocation>"

folderlocation – GetUniquePermissions.ps1 file location

Run the following command

>.\GetUniquePermissions.ps1

1	>.\GetUniquePermissions.ps1

Thus in this blog, you saw how to get all the lists which have unique permissions from the SharePoint online site using PnP PowerShell.

Peter

Posts by Peter

SharePoint 2013 Hosting UK – HostForLIFE.eu :: Reading The SharePoint News Using Rest API In SPFx

SharePoint 2013 Hosting UK – HostForLIFE.eu :: PowerShell to Get/Add/Remove Users of Local Administrator Group

SharePoint 2013 Hosting UK – HostForLIFE.eu :: Find Default Page And Approve It Using Powershell In SPO

SharePoint 2013 Hosting UK – HostForLIFE.eu :: How To Connect To Microsoft Teams Using PowerShell?

SharePoint 2013 Hosting UK – HostForLIFE.eu :: How to Overcome Yammer URL Encoding Issues in the Webpart Title?

SharePoint 2013 Hosting – HostForLIFE.eu : How To Get All The Lists Which Have Unique Permissions From the Sharepoint Online Site Using PnP PowerShell

BLOGROLL

Featured On

Peter

Posts by Peter

SharePoint 2013 Hosting UK – HostForLIFE.eu :: Reading The SharePoint News Using Rest API In SPFx

SharePoint 2013 Hosting UK – HostForLIFE.eu :: PowerShell to Get/Add/Remove Users of Local Administrator Group

SharePoint 2013 Hosting UK – HostForLIFE.eu :: Find Default Page And Approve It Using Powershell In SPO

SharePoint 2013 Hosting UK – HostForLIFE.eu :: How To Connect To Microsoft Teams Using PowerShell?

SharePoint 2013 Hosting UK – HostForLIFE.eu :: How to Overcome Yammer URL Encoding Issues in the Webpart Title?

SharePoint 2013 Hosting – HostForLIFE.eu : How To Get All The Lists Which Have Unique Permissions From the Sharepoint Online Site Using PnP PowerShell

BLOGROLL

Featured On

Tags